What directions did you follow to switch to mariadb? I know how to install the Maria add-on. Not sure how to turn the SQL off and what is recommended other than the default settings for Mariadb.
It’s just a matter of changing your recorder URL. Look in the MariaDB addon, at the bottom of the documentation page it gives an example.
Just default config in MariaDB
databases:
- homeassistant
logins:
- username: homeassistant
password: password
rights:
- username: homeassistant
database: homeassistant
and configuration.yaml
recorder:
db_url: mysql://homeassistant:password@core-mariadb/homeassistant?charset=utf8
purge_keep_days: 1
exclude:
domains:
- updater
- media_player
entities:
- sun.sun # Don't record sun data
Regards,
Thanks. I’ll start working on it.
It worked, very easy. I need to understand the excludes, includes? For some reason none of my Wyze sensors are showing in the logbook. Then I can follow Tom_I guide on how to reduce size and extend life of SD card.
I set up my DB using your recorder statement:
recorder:
db_url: mysql://homeassistant:password@core-mariadb/homeassistant?charset=utf8
Where is the database stored?
I do not know, have looked before but it must be stored on another partition?
Looking with both SSH and Samba I can’t find it.Maybe someone else can help? I wanted to see the size compared to the SQLlite I was using.
I guess under /addons
Addons doesn’t show in Samba. In SSH it shows empty.
Using thé samba add-on ? Use whitelist external dies.
How? In the SAMBA config?
This is my working configuration as of now.
workgroup: WORKGROUP
username: redacted
password: redacted
interface: eth0
allow_hosts:
- 10.0.0.0/8
- 172.16.0.0/12
- 192.168.0.0/16
veto_files:
- ._*
- .DS_Store
- Thumbs.db
- .Trashes
compatibility_mode: false
Mine looks very close to yours I have no idea where to look.
Did you try in configuration.yaml :
homeassistant:
whitelist_external_dirs:
- /share
- /addons
I already have access to /share & /addons
nothing in them?
?
There is nothing in my addons folder either.
I believe the database is inside the Mosquitto addon docker container.
If the database is in the docker container, how are updates managed ? As far as I know, an upgrade replaces the docker container.
Good point. I just saw your post about whitlisting. Tried to add this:
whitelist_external_dirs:
- /config
- /addons
But got:
not a directory @ data['whitelist_external_dirs'][1]
It’s ok with config but not addons.