[SOLVED] MySQL no connection with OpenHAB in docker

Add-ons Persistence Services
1

Hello

My Openhab 2.5 is running in a Docker on a Debian server.
MariaDB runs directly on the Server.

My Docker Openhab can’t connect to SQL, but a local installed Openhab can connect with the same jdbc.cfg
jdbc.cfg:

url=jdbc:mariadb://192.168.0.249:3306/smarthome?serverTimezone=Europe/Vienna

user=smarthome

password=xxxxxxxxxxx

Log Error:

2019-10-10 05:48:57.225 [WARN ] [jdbc.internal.JdbcPersistenceService] - JDBC::store: No connection to database. Cannot persist item ‘SensorSZLUMI_Humidity (Type=NumberItem, State=38.16)’! Will retry connecting to database when error count:0 equals errReconnectThreshold:3

SQL binding address is 0.0.0.0
SQL User = smarthome@% with all rights for DB

So how can i find the error?

Thanks

2

So this is a Docker configuration issue better solved in a Docker forum.

3

Are you running OH with the --net=host option? It might not have network access to the host otherwise.

4

Thanks, sure as host.
Today i have changed OpenHAB Docker from snapshot to milestone and reinstalled MariaDB.
A little change in jdbc.cfg: url=jdbc:mariadb:// to url=jdbc:mysql://
and a newer mysql-connector-java.jar
and it works now :grinning: