Invalid Config History, Log and default_config

Installation Home Assistant OS
1

I have noticed that I keep getting that notification:

The following integrations and platforms could not be set up:

* [logbook](https://www.home-assistant.io/integrations/logbook)
* [history](https://www.home-assistant.io/integrations/history)
* [default_config](https://www.home-assistant.io/integrations/default_config)

Please check your config and [logs](https://ha.ppmt.org/config/logs).

I think it appeared recently either wiht 2021.05 or 2021.05 but not so sure.

In the logs I can see this:

Error doing job: Exception in callback Recorder.async_connection_failed()

19:16:13 – (ERROR) components/recorder/__init__.py

Error during connection setup to mysql://hass:redacted@core-mariadb/homeassistant?charset=utf8mb4: (MySQLdb._exceptions.OperationalError) (2005, "Unknown MySQL server host 'core-mariadb' (-3)") (Background on this error at: http://sqlalche.me/e/14/e3q8) (retrying in 3 seconds)

19:16:10 – (ERROR) recorder - message first occurred at 19:10:28 and shows up 10 times

I thought the mariadb addon didn’t start properly so I restarted it and then restarted HA but it stayed the same. I even uninstalled it and reinstalled it but it didn’t help.

The addon itself says it started properly.

I read the latest release note but could not find anything that is related.

Do you have any advice on how to troubleshoot my issue?

2

What does your configuration for the recorder integration look like?

This is mine and it is working:

recorder: mysql://hass:my_password_redacted@core-mariadb/homeassistant?charset=utf8

Corresponding mariadb addon configuration:

databases:
  - homeassistant
logins:
  - username: hass
    password: my_password_redacted
rights:
  - username: hass
    database: homeassistant

Edit: actually I can see it in the error message. The only difference is that you are using ?charset=utf8mb4 where as I am using ?charset=utf8
Also I can see your database password in that error message. You might want to change it.

3

Hello @tom_l and thanks for your input.
I have changed the config and it still is the same. It was actually as yours before but I tried that setting after reading the doc and it mentioned that setting

databases:
  - homeassistant
logins:
  - username: hass
    password: redacted
rights:
  - username: hass
    database: homeassistant

recorder:
  #db_url: !secret mariadb_url
  db_url: mysql://hass:redacted@core-mariadb/homeassistant?charset=utf8
  commit_interval: 30
  purge_keep_days: 4

it says that core-mariadb doesn’t exist but it always worked like that before

Error during connection setup to mysql://hass:redacted@core-mariadb/homeassistant?charset=utf8: (MySQLdb._exceptions.OperationalError) (2005, "Unknown MySQL server host 'core-mariadb' (-3)") (Background on this error at: http://sqlalche.me/e/14/e3q8) (retrying in 3 seconds)

sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2005, "Unknown MySQL server host 'core-mariadb' (-3)")
(Background on this error at: http://sqlalche.me/e/14/e3q8)
4

I did the update to 2021.5.4 and the problem is fixed.

Not sure what happened but all sorted for now