JDBC Mysql persistence in OH3

[ohb1138 (Justus Reich)]

@Logos Hi Rolf,
I assume you are also running OH 3.1, right? It is not clear to me which change caused the trouble the upgrade to OH 3 or the move from mariadb5 to mariadb10. It looks to me that you made two changes at once?

Here is my jdbc.cfg:

url=jdbc:mariadb://<ip_address>:3307/<mariadb_name>?useLegacyDatetimeCode=false&serverTimezone=Europe/Berlin

user=xxx
password=yyy
default_time_zone='Europe/Berlin'

reconnectCnt=0
waitTimeout=28800

sqltype.LOCATION      =   VARCHAR(256)
sqltype.STRING         =   VARCHAR(4096)
sqltype.IMAGE          =   BLOB

Did you create a new database in MariaDB10 or did you move your old database from v5 to V10?
When you migrate from OH2.5 to OH3 you should definitely create a new database following these instructions:

How to setup MySQL persistence in a few minutes. Step by step

Some users keep struggling with MySql persistence. it are just a few steps to get it working in. This has been written for openhabian but will work on most linux based systems. Be prepared be able to check your log files use for example frontail If you are on a windows machine I suggest to use cmder instead of cmd (you have a larger buffer, and it does ssh, so you don’t need putty) Another helpful tool could be MySQL workbench. To check if you are able to make outside connections. Install …

JDBC Mysql Persistence failing (com.mysql.jdbc.Driver was not found, trying direct instantiation)

I have it working now. two things; need to make sure you set GRANT permission on your openhab, not just for the username, but for the username @ host!!, this was a little unexpected for me for (i’m postgres not mysql normally). I used this in the end; grant all on OpenHAB.* to 'openhab'@'%' IDENTIFIED BY 'PASSWORD'; set password for 'openhab'@'%' = password('********'); I’m not 100% sure it uses the connection setting in jdbc.cfg when using paperui. If using that, change your username p…

Somewhere in the web there is also a description how to exactly do it on a Synology NAS when leveraging the phpMyAdmin app that you can install from the Synology community. It creates the empty database with all required grants and rights.