I am running docker on a Synology NAS.
HA and Mosquitto are running perfectly well.
Mariadb is running. I can access MariaDB from PHPMyAdmin on the Synology NAS.
The problem: HA does not connect to the MariaDB!
There’s a Mariadb installation on the Synology NAS. This unfortunately is running version 10.3.23.
An upgrade is not available.
HA requires 10.5.17 or higher.
So installing MariaDB on the docker should solve the version issue…
But HA wont connect!
In order to distinguish between the two installations the docker version is using port 3307 instead of 3306.
As a result the connect string looks like this:
db_url: mysql://Homeassistant:[email protected]:3307/Homeassistant?charset=utf8
Any idea?
Here’s my temporary ‘solution’:
Deinstalling Mariadb from Synology NAS → necessary to release port 3306
Install Mariadb on docker using port 3306
It seems that the binary image of mariadb just ignores the directive to use port 3307.
See the message from the log when installing Mariadb on port 3307 ->7<- 
Version: ‘11.6.2-MariaDB-ubu2404’ socket: ‘/run/mysqld/mysqld.sock’ port: 3306 mariadb.org binary distribution
Hope this helps anybody to not spend several hours to get Mariadb on docker with a different port number!