HA ignoring mysql config

Configuration
21

Just a final thought on this one. Are you using the recorder component?


Check the bottom for MariaDB specific formatting.
For your external DB
22

yes ofcourse, i might be stupid but im not that stupid… i think

23

I wasn’t implying you were. I cant even count the amount of times I’ve tried to diagnose an issue and as a techie over complicated the troubleshooting. Finally finding out it was something simple I overlooked!

Even after 30years in IT.

24

i understand, i have a tendency to overengineer stuff too.

i accidentally fixed it, promise me you wont kill me.

see if you find the difference :S
(the facepalm is big in this one)

old:

 recorder:
   purge_interval: 1
   purge_keep_days: 7
   db_url: mysql://user:[email protected]/homeassistant

new:

recorder:
  purge_interval: 1
  purge_keep_days: 7
  db_url: mysql://user:[email protected]/homeassistant

if you’ll excuse me now, ill go jump off a bridge or something after i stopped banging my head on the table hehe

25

Hmmm might it be… indentation?

Happy its fixed though hahaha!

1 Like
26

thx for helping out :wink:

27

No worries. :+1:

28

Glad you fixed it, ‘yamllint’ is your friend :wink: