I am trying to set up MariaDB on my RPi hass.io system. I have installed the MariaDB addon from the repo and entered the following in the config:
{
"databases": [
"homeassistant"
],
"logins": [
{
"username": "hass",
"host": "core-mariadb",
"password": "myownpassword"
}
],
"rights": [
{
"username": "hass",
"host": "core-mariadb",
"database": "homeassistant",
"grant": "ALL PRIVILEGES ON"
}
]
}
The addon is started and the end of the log file reads:
[INFO] Start MariaDB
171115 19:06:17 mysqld_safe Logging to '/data/databases/core-mariadb.err'.
171115 19:06:17 mysqld_safe Starting mysqld daemon with databases from /data/databases
[INFO] Init custom database
[INFO] Create database homeassistant
[INFO] Init/Update users
[INFO] Create user hass
[INFO] Init/Update rights
[INFO] Alter rights for hass@core-mariadb - homeassistant
I have also added the following to my configuration.yaml:
recorder:
db_url: mysql://hass:myownpassword@core-mariadb/homeassistant
This is the error I get in the home-assistant.log:
2017-11-15 19:14:24 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1130, "Host 'homeassistant' is not allowed to connect to this MariaDB server") (retrying in 3 seconds)
2017-11-15 19:14:27 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1130, "Host 'homeassistant' is not allowed to connect to this MariaDB server") (retrying in 3 seconds)
I have tried to follow the instructions here, but it looks as if hass.io and the MariaDB addon are supposed to do most of the job for me. Am I missing some steps in the process?