MySQL connection no longer runs after update to openHAB 2.5

Add-ons Persistence Services
,
1

I today I updated my openHAB from 2.4 stable to 2.5. Now I get following error message in the log file:

2019-12-18 19:25:56.857 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: Driver is available::Yank setupDataSource
2019-12-18 19:25:56.960 [WARN ] [.zaxxer.hikari.util.DriverDataSource] - Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2019-12-18 19:25:57.550 [ERROR] [org.openhab.persistence.jdbc        ] - bundle org.openhab.persistence.jdbc:1.14.0 (231)[org.openhab.persistence.jdbc(217)] : The activate method has thrown an exception
com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: CLIENT_PLUGIN_AUTH is required
    at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:516) ~[?:?]

OpenHAB runs on an raspberryPi with raspbian buster and Zulu Java.
The MySQL is version 5.1.73

java -version
openjdk version "1.8.0_212"
OpenJDK Runtime Environment (Zulu8.38.0.163-CA-linux_aarch32hf) (build 1.8.0_212-b163)
OpenJDK Client VM (Zulu8.38.0.163-CA-linux_aarch32hf) (build 25.212-b163, mixed mode, Evaluation)

I’m using the JDBC persistence. The config file see below:

url=jdbc:mysql://192.16x.xxx.xxx:3306/database-name
user=<my_secret_user_name>
password=<my_secret_passwort>
tableNamePrefix=Item
tableIdDigitCount=0

Ideas how I can fix the bug and get MySQL running again?

2

Is the MySQL persistence installed after update? I would uninstall and reinstall.

Then restart and clear cache, check the logs see if there is an error. That’s my best suggestion

3

Hi @Thedannymullen, thank you for your answer. In the meantime I know that the error occurs by an authentication failure because my MySQL server version is too old (see quote above).

To solve the problem I moved my SQL server from my QNAP NAS to the Raspberry Pi.

1 Like