[0.97.2] MariaDB issue - this seems to be common?

Installation Home Assistant OS
1

Suddenly after a reboot, the recorder won’t start anymore. Can anyone help me out here?

More topics are reporting this same error:

Error during connection setup: (MySQLdb._exceptions.OperationalError) (1130, "Host 'core-samba.local.hass.io' is not allowed to connect to this MariaDB server")
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)

I tried changing the MariaDB config: “host”: “%”
Also tried this change in configuration.yaml:
db_url: mysql://hass:drk-jo4e1z-3d4pdr98f@core-mariadb/homeassistant
to:
db_url: mysql://hass:[email protected]/homeassistant

And also uninstalled and reinstalled the MariaDB Hass.io add-on. But no luck.

Hass.io / HA 0.97.2 / supervisor 184 / host Ubuntu Server 18.04.2

2

This one got me a little while back as well.

Ran Mariadb for around 2 weeks then one day it didnt start.

I didnt really need it, so it was easier to just remove it and go back to the default. I never dug too deep into it.

Now I’m considering switching to a new db again, so I’m curious if anyone else had the issue and how to fix.

3

Have the same issue. Rebooted, and get this error…

4

Just solved it. I’ve changed the host into % and rebooted again

{
  "databases": [
    "homeassistant"
  ],
  "logins": [
    {
      "username": "hass",
      "host": "%",
      "password": "************"
    }
  ],
  "rights": [
    {
      "username": "hass",
      "host": "%",
      "database": "homeassistant",
      "grant": "ALL PRIVILEGES ON"
    }
  ]
}
5

Ah two places to put the %. That fixes it

6

In the 2.0 as I see there is no option host, so as I see there is no way to reach the db from outside.
I can’t find any relevant in documents. Guys, you who had this porblem and solved with host param, what’s your opinion?

7

This is my config now:

databases:
  - homeassistant
logins:
  - username: hass
    host: '%.local.hass.io'
    password: xxxxxxxxx
rights:
  - username: hass
    host: '%.local.hass.io'
    database: homeassistant
    grant: ALL PRIVILEGES ON
8

that,s nice but in my log:
20-03-03 18:39:58 WARNING (MainThread) [supervisor.addons.validate] Unknown options host
20-03-03 18:39:58 WARNING (MainThread) [supervisor.addons.validate] Unknown options host

9

How does your config look like?

Mine:

recorder:
  db_url: mysql://hass:xxxxxxxxx@core-mariadb/homeassistant?charset=utf8
10 
recorder:
  db_url: mysql://hass:zzzzzzzzz@core-mariadb/homeassistant?charset=utf8
  purge_keep_days: 20
  purge_interval: 1