Hey. The MariaDB addon just runs an instance of MariaDB Server as a separate image that Home Assistant can talk to. You don’t need it if you want to host your DB on a separate server, just change “core-mariadb” in your db_url value in configuration.yaml to the IP address or hostname of your new server.
On your DB server you need to configure MariaDB to allow connections from external sources (ie not localhost), and add an exception on that server’s firewall if you’ve configured one on there. (Most Linux distros don’t have one by default.)
By and large a generic MariaDB install should be fine for hosting, so any guide to installing it on Raspbian/Ubuntu/whatever will suffice. HomeAssistant is coded to create the DB structure if it doesn’t already exist, so you don’t need to do anything other than create a new DB named “homeassistant” or whatever you decide to call it.
Once it’s working you can safely kill the old .db file if you want.
hello I’m not able to connect to MariaDb sever…
i’m able to connect with phpmyadmin addon, but I’m not from node red and sqldevelopper tool…
it was working before the last update and Nginx installation. But I’m not sure about the issue.
I read from the mariadb change log that the 3306 port is not forwarding anymore… could be that? but how tu eneable the forwarding?
can you help to understand why?
On my db (currently using Mariadb) , I in getting some 1366, “Incorrect string value: \xF0\x9F\x98\x80\xF0\x9F…’ for column ‘name’ at row 1”) in the error logs. I believe this started with the security update was done. Any idea on how to fix this? Searching on the internet it seems this is a common problem and on stackoverflow it says this can be fixed by editing the python code. I don’t know how to do this?
Thank. I didn’t read this but I did read the docs on setting up the recorder. I now see that the string was changed from charset=utf8 to utf8mb4.
Thanks.
How can I grant access to all databases like “MyVideos116”, “MyVideos115”? Can I use regex in configuration? Tried as in the example below. But without success …
rights:
- username: kodi
database: MyVideos\d+
host: '%'
grant: ALL PRIVILEGES ON
But even when I try your config, it isn’t working. In logs, it was asking for db MyVideos116 first, so I even changed config for that, result the same. I have no idea why. I am able to connect to db from my computer, but seems that kodi can’t for some reason (port 3306 is open from kodi).
root@w541:~# mysql -ukodi -p -h 10.0.1.8
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.5.5-10.4.19-MariaDB MariaDB Server
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| MyVideos |
| MyVideos116 |
| information_schema |
| kodi |
+--------------------+
4 rows in set (0,00 sec)
So I removed the db and after kodi reboot it is not created. In logs, there is still this message:
2019-04-11 18:28:42.101 T:2881561456 ERROR: Unable to open database: MyVideos116 [2002](Can't connect to MySQL server on '10.0.1.8' (101))
2019-04-11 18:28:42.101 T:2881561456 ERROR: Unable to create new database
Yes, I have it open. I am able to connect to db from other computer, so that is ok.
Small progress right now, in LibreELEC I have set “wait for network” option and it has at least created two databases (Video116 nad Music72), but I can’t still update the library. I think I am on the right track now
Alright, so the main problem was in LibreELEC and “Wait for network before starting Kodi”. Then I had to re-add sources and library was updating to db. Problem resolved. Thanks guys!
