Recorder errors

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,

1 Like

Thanks. I’ll start working on it. :worried:

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
image

nothing in them?

image

image
?

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.