Ok so I just reconfigure all my openhab from scratch on Openhab 2.3 ( previously on 2.0 ) I just resetup the mysql persistence and it’s working fine.
I have some issue with rules and I try to check the historic of the mysql persistence to see where is the issue but all the date and the state are random … ( I check with a php script who is looking directly in the database and with the rest API ) Also, I don’t know if it’s normal but I have no persistence info in Habmin
this is my .persistence :
everyMinute : "0 * * * * ?"
every5Minutes : "0 */5 * * * ?"
everyHour : "0 0 * * * ?"
everyDay : "0 0 0 * * ?"
default = everyChange
}
Items {
* : strategy = everyChange, everyMinute, restoreOnStartup
}
(I want all my item to be backup in persistence)
This is my .cfg :
url=jdbc:mysql://localhost:8889/Openhab2
user=openhab
password=openhab
reconnectCnt=1
Finaly here is some weird log I don’t get why he have an issue :
018-07-27 22:30:02.601 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Failed connecting to the SQL database using: driverClass=com.mysql.jdbc.Driver, url=jdbc:mysql://localhost:8889/Openhab2, user=openhab, password=openhab
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:357) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2482) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) [234:org.openhab.persistence.mysql:1.12.0]
at org.openhab.persistence.mysql.internal.MysqlPersistenceService.connectToDatabase(MysqlPersistenceService.java:521) [234:org.openhab.persistence.mysql:1.12.0]
at org.openhab.persistence.mysql.internal.MysqlPersistenceService.store(MysqlPersistenceService.java:383) [234:org.openhab.persistence.mysql:1.12.0]
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259) ~[?:?]
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:307) ~[?:?]