Current MariaDB docker on rpi will become obsolete?

Configuration
1 
Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:304
Integration: Recorder (documentation, issues)
First occurred: 19:09:08 (1 occurrences)
Last logged: 19:09:08

Version 10.0.38 of MariaDB is not supported; minimum supported version is 10.3.0. Starting with Home Assistant 2022.2 this will prevent the recorder from starting. Please upgrade your database software before then

I’m currently using the docker image from Docker Hub, should I use a different one? Any suggestions?

2

Yes, you should use a differenr one. The one you are currently using has not been updated for 6 months.

Maybe try this one Docker Hub

or my always preferred ones are from linuxserver.io

https://hub.docker.com/r/linuxserver/mariadb

3

Using (only the image changed)

          container_name: mariadb
          image: linuxserver/mariadb:10.5.13
          volumes:
                  - /media/ssd/storage/mariadb:/var/lib/mysql
          ports:
                  - "3307:3306"
          environment:
                  - mysql_root_passsword='snip'
                  - MYSQL_DATABASE='snip'
                  - MYSQL_USER='snip'
                  - MYSQL_PASSWORD='snip'

But it looks like I’m missing something as HA can’t connect to it:

sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2002, "Can't connect to MySQL server on '192.168.1.240' (115)")
(Background on this error at: https://sqlalche.me/e/14/e3q8)

Any ideas?

I also tried with the other one on DockerHub and same issue…

4

@Burningstone Any ideas? I pointed the volume to a new location which I believe will have HA recreate the database in case that was the issue but it looks like HA just cannot connect to the database though the credentials are exactly the same in the docker-compose file.

Now 2022.2 is out I’d like to fix this to be able to upgrade, can’t seem to figure this one out at the moment.

5

Try setting PUID and PGID.

Please also show how you configured the database on Home Assistant side.