Cannot connect to mysql db after 3.2 -> 3.4 upgrade

I upgraded my installation from 3.3 to 3.4 and now my jdbc:mysql persistence cannot connect. I have edited/cleared everything I can find but with no luck (cache/tmp/jsondb and /var/lib/openhab/config/org). Statements from log is included below. The WARN is the same if I change user/database/password so it clearly cannot connect to the database, but it worked just before the upgrade and the database is still up and I can connect manually. Any ideas?

2023-04-23 11:47:43.343 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::activate: persistence service activated
2023-04-23 11:47:43.344 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig
2023-04-23 11:47:43.344 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::JdbcConfiguration
2023-04-23 11:47:43.345 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration size = 15
2023-04-23 11:47:43.345 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: user=openhab
2023-04-23 11:47:43.346 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: password exists? true
2023-04-23 11:47:43.347 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: url=jdbc:mysql://192.168.7.51:3306/OpenHAB3
2023-04-23 11:47:43.347 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: found serviceName = 'mysql'
2023-04-23 11:47:43.348 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: Init Data Access Object Class: 'org.openhab.persistence.jdbc.internal.db.JdbcMysqlDAO'
2023-04-23 11:47:43.349 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::initSqlTypes: Initialize the type array
2023-04-23 11:47:43.349 [DEBUG] [stence.jdbc.internal.db.JdbcMysqlDAO] - JDBC::initSqlTypes: Initialize the type array
2023-04-23 11:47:43.350 [DEBUG] [stence.jdbc.internal.db.JdbcMysqlDAO] - JDBC::initSqlQueries: 'JdbcMysqlDAO'
2023-04-23 11:47:43.350 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: dBDAO ClassName=org.openhab.persistence.jdbc.internal.db.JdbcMysqlDAO
2023-04-23 11:47:43.351 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: set sqlTypes: itemType=STRINGITEM value=TEXT
2023-04-23 11:47:43.351 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: errReconnectThreshold=1
2023-04-23 11:47:43.352 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableUseRealItemNames=true
2023-04-23 11:47:43.352 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: enableLogTime false
2023-04-23 11:47:43.353 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: load JDBC-driverClass was successful: 'com.mysql.cj.jdbc.Driver'
2023-04-23 11:47:43.353 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration complete. service=jdbc
2023-04-23 11:47:43.354 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::pingDB
2023-04-23 11:47:43.354 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection isDriverAvailable: true
2023-04-23 11:47:43.355 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: Driver is available::Yank setupDataSource
2023-04-23 11:47:43.361 [WARN ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: failed to open connection: Failed to initialize pool: Communications link failure

It was an outdated db…

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.