Failed installing 'openhab-persistence-jdbc'

FyingEaglE · April 8, 2020, 2:42pm

Openhab 2.5.3

I havent installed any persistence bindung/action but I get this message in my log.
I deleted everything with jdbc/mysql/mariadb in all files also in .cfg/.persist/.config in userdata/*

[ERROR] [.core.karaf.internal.FeatureInstaller] - Failed installing 'openhab-persistence-jdbc'

nothing installed:

openhab> bundle:list | grep -i jdbc
openhab> bundle:list | grep -i maria
openhab> bundle:list | grep -i mysql

I want to use jdbc with mariadb, but can not get it to work.
I installed via karaf and feature:install - after the installation finished i got a lot of messages in log, but after some seconds i got an error message and after that a bundle:list or feature:list shows me an uninstalled persistence again.
Before the error message the .list showed me an installed and active persistence.

I tried jdbc-mariadb and jbdc-mysql

2020-04-07 23:48:29.290 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::setItemRegistry
2020-04-07 23:48:29.292 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::activate: persistence service activated
2020-04-07 23:48:29.296 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig
2020-04-07 23:48:29.302 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::JdbcConfiguration
2020-04-07 23:48:29.303 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration size = 10
2020-04-07 23:48:29.307 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: user=openhab
2020-04-07 23:48:29.309 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: password exists? true
2020-04-07 23:48:29.310 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: url=jdbc:mariadb://192.168.3.3:3306/openhab
2020-04-07 23:48:29.311 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: found serviceName = 'mariadb'
2020-04-07 23:48:29.312 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: Init Data Access Object Class: 'org.openhab.persistence.jdbc.db.JdbcMariadbDAO'
2020-04-07 23:48:29.318 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::initSqlTypes: Initialize the type array
2020-04-07 23:48:29.319 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::initSqlQueries: 'JdbcMariadbDAO'
2020-04-07 23:48:29.321 [DEBUG] [b.persistence.jdbc.db.JdbcMariadbDAO] - JDBC::initSqlTypes: Initialize the type array
2020-04-07 23:48:29.322 [DEBUG] [b.persistence.jdbc.db.JdbcMariadbDAO] - JDBC::initSqlQueries: 'JdbcMariadbDAO'
2020-04-07 23:48:29.324 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: dBDAO ClassName=org.openhab.persistence.jdbc.db.JdbcMariadbDAO
2020-04-07 23:48:29.366 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableUseRealItemNames=true
2020-04-07 23:48:29.368 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: enableLogTime false
2020-04-07 23:48:29.409 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: load JDBC-driverClass was successful: 'org.mariadb.jdbc.Driver'
2020-04-07 23:48:29.410 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration complete. service=jdbc
2020-04-07 23:48:29.411 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::pingDB
2020-04-07 23:48:29.413 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection isDriverAvailable: true
2020-04-07 23:48:29.415 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: Driver is available::Yank setupDataSource
2020-04-07 23:48:29.597 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::setDbConnected true
2020-04-07 23:48:29.599 [DEBUG] [b.persistence.jdbc.db.JdbcMariadbDAO] - JDBC::initAfterFirstDbConnection: Initializing step, after db is connected.
2020-04-07 23:48:29.634 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - dbMajorVersion = '10'
2020-04-07 23:48:29.636 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - dbMinorVersion = '4'
2020-04-07 23:48:29.637 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - driverMajorVersion = '1'
2020-04-07 23:48:29.639 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - driverMinorVersion = '3'
2020-04-07 23:48:29.640 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - dbProductName = 'MySQL'
2020-04-07 23:48:29.641 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - dbProductVersion = '10.4.11-MariaDB-1:10.4.11+maria~bionic-log'
2020-04-07 23:48:29.643 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::pingDB asking db for name as absolutely first db action, after connection is established.
2020-04-07 23:48:29.752 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::checkDBAcessability, first try connection: true
2020-04-07 23:48:29.754 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::createItemsTableIfNot
2020-04-07 23:48:29.756 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::doCreateItemsTableIfNot sql=CREATE TABLE IF NOT EXISTS items (ItemId INT NOT NULL AUTO_INCREMENT,itemname VARCHAR(500) NOT NULL,PRIMARY KEY (ItemId))
2020-04-07 23:48:30.503 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::getItemIDTableNames
2020-04-07 23:48:30.504 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::doGetItemIDTableNames sql=SELECT itemid, itemname FROM items
2020-04-07 23:48:30.534 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:48:30.537 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig: configuration complete for service=jdbc.
2020-04-07 23:48:30.541 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:48:30.547 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:48:30.550 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:48:30.553 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:48:30.556 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:48:30.559 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:48:30.563 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.

2020-04-07 23:49:29.565 [ERROR] [core.karaf.internal.FeatureInstaller] - Failed installing 'openhab-persistence-jdbc'

2020-04-07 23:49:31.384 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:49:31.386 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:49:31.388 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:49:31.390 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:49:31.392 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:49:31.394 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-07 23:49:31.397 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::deactivate:  persistence bundle stopping. Disconnecting from database. reason=6
2020-04-07 23:49:31.399 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::unsetItemRegistry


2020-04-08 00:08:26.991 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::setItemRegistry
2020-04-08 00:08:26.993 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::activate: persistence service activated
2020-04-08 00:08:26.994 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig
2020-04-08 00:08:26.999 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::JdbcConfiguration
2020-04-08 00:08:27.001 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration size = 11
2020-04-08 00:08:27.004 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: user=openhab
2020-04-08 00:08:27.006 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: password exists? true
2020-04-08 00:08:27.007 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: url=jdbc:mariadb://192.168.3.3:3306/openhab
2020-04-08 00:08:27.008 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: found serviceName = 'mariadb'
2020-04-08 00:08:27.009 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: Init Data Access Object Class: 'org.openhab.persistence.jdbc.db.JdbcMariadbDAO'
2020-04-08 00:08:27.015 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::initSqlTypes: Initialize the type array
2020-04-08 00:08:27.017 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::initSqlQueries: 'JdbcMariadbDAO'
2020-04-08 00:08:27.018 [DEBUG] [b.persistence.jdbc.db.JdbcMariadbDAO] - JDBC::initSqlTypes: Initialize the type array
2020-04-08 00:08:27.019 [DEBUG] [b.persistence.jdbc.db.JdbcMariadbDAO] - JDBC::initSqlQueries: 'JdbcMariadbDAO'
2020-04-08 00:08:27.021 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: dBDAO ClassName=org.openhab.persistence.jdbc.db.JdbcMariadbDAO
2020-04-08 00:08:27.024 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableNamePrefix=Item
2020-04-08 00:08:27.025 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableUseRealItemNames=true
2020-04-08 00:08:27.026 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: enableLogTime false
2020-04-08 00:08:27.028 [ERROR] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: could NOT load JDBC-driverClassName or JDBC-dataSourceClassName. ClassNotFoundException: 'org.mariadb.jdbc.Driver cannot be found by org.openhab.persistence.jdbc_1.14.0'
2020-04-08 00:08:27.029 [WARN ] [ence.jdbc.internal.JdbcConfiguration] - 

	!!!
	To avoid this error, place an appropriate JDBC driver file for serviceName 'mariadb' in addons directory.
	Copy missing JDBC-Driver-jar to your OpenHab/addons Folder.
	!!!
	DOWNLOAD: 
	MariaDB:   version >= 1.2.0 from              http://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client

2020-04-08 00:08:27.030 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration complete. service=jdbc
2020-04-08 00:08:27.032 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::pingDB
2020-04-08 00:08:27.033 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection isDriverAvailable: false
2020-04-08 00:08:27.034 [WARN ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: no driver available!
2020-04-08 00:08:27.036 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::pingDB
2020-04-08 00:08:27.037 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection isDriverAvailable: false
2020-04-08 00:08:27.038 [WARN ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: no driver available!
2020-04-08 00:08:27.039 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::checkDBAcessability, second try connection: false
2020-04-08 00:08:27.040 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:08:27.041 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig: configuration complete for service=jdbc.
2020-04-08 00:08:27.043 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:08:27.046 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:08:27.048 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:08:27.049 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:08:27.050 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:08:27.052 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:08:27.054 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.

2020-04-08 00:16:01.736 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:01.738 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:01.741 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:01.751 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:01.753 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:01.758 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:01.765 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::deactivate:  persistence bundle stopping. Disconnecting from database. reason=6
2020-04-08 00:16:01.767 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::unsetItemRegistry
2020-04-08 00:16:02.159 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::setItemRegistry
2020-04-08 00:16:02.161 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::activate: persistence service activated
2020-04-08 00:16:02.162 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig
2020-04-08 00:16:02.188 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::JdbcConfiguration
2020-04-08 00:16:02.206 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration size = 11
2020-04-08 00:16:02.226 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: user=openhab
2020-04-08 00:16:02.228 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: password exists? true
2020-04-08 00:16:02.229 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: url=jdbc:mariadb://192.168.3.3:3306/openhab
2020-04-08 00:16:02.243 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: found serviceName = 'mariadb'
2020-04-08 00:16:02.245 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: Init Data Access Object Class: 'org.openhab.persistence.jdbc.db.JdbcMariadbDAO'
2020-04-08 00:16:02.340 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::initSqlTypes: Initialize the type array
2020-04-08 00:16:02.342 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::initSqlQueries: 'JdbcMariadbDAO'
2020-04-08 00:16:02.344 [DEBUG] [b.persistence.jdbc.db.JdbcMariadbDAO] - JDBC::initSqlTypes: Initialize the type array
2020-04-08 00:16:02.346 [DEBUG] [b.persistence.jdbc.db.JdbcMariadbDAO] - JDBC::initSqlQueries: 'JdbcMariadbDAO'
2020-04-08 00:16:02.348 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: dBDAO ClassName=org.openhab.persistence.jdbc.db.JdbcMariadbDAO
2020-04-08 00:16:02.363 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableNamePrefix=Item
2020-04-08 00:16:02.367 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableUseRealItemNames=true
2020-04-08 00:16:02.369 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: enableLogTime false
2020-04-08 00:16:02.379 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: load JDBC-driverClass was successful: 'org.mariadb.jdbc.Driver'
2020-04-08 00:16:02.380 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration complete. service=jdbc
2020-04-08 00:16:02.382 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::pingDB
2020-04-08 00:16:02.384 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection isDriverAvailable: true
2020-04-08 00:16:02.398 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: Driver is available::Yank setupDataSource
2020-04-08 00:16:02.650 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::setDbConnected true
2020-04-08 00:16:02.652 [DEBUG] [b.persistence.jdbc.db.JdbcMariadbDAO] - JDBC::initAfterFirstDbConnection: Initializing step, after db is connected.
2020-04-08 00:16:02.717 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - dbMajorVersion = '10'
2020-04-08 00:16:02.736 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - dbMinorVersion = '4'
2020-04-08 00:16:02.745 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - driverMajorVersion = '1'
2020-04-08 00:16:02.753 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - driverMinorVersion = '3'
2020-04-08 00:16:02.758 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - dbProductName = 'MySQL'
2020-04-08 00:16:02.774 [DEBUG] [ab.persistence.jdbc.utils.DbMetaData] - dbProductVersion = '10.4.11-MariaDB-1:10.4.11+maria~bionic-log'
2020-04-08 00:16:02.782 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::pingDB asking db for name as absolutely first db action, after connection is established.
2020-04-08 00:16:02.897 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::checkDBAcessability, first try connection: true
2020-04-08 00:16:02.908 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::createItemsTableIfNot
2020-04-08 00:16:02.911 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::doCreateItemsTableIfNot sql=CREATE TABLE IF NOT EXISTS items (ItemId INT NOT NULL AUTO_INCREMENT,itemname VARCHAR(500) NOT NULL,PRIMARY KEY (ItemId))
2020-04-08 00:16:02.918 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::getItemIDTableNames
2020-04-08 00:16:02.922 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::doGetItemIDTableNames sql=SELECT itemid, itemname FROM items
2020-04-08 00:16:02.942 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:02.950 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig: configuration complete for service=jdbc.
2020-04-08 00:16:02.953 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:02.959 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:02.961 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:02.970 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:02.974 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:02.982 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2020-04-08 00:16:02.986 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.

2020-04-08 00:21:01.499 [ERROR] [core.karaf.internal.FeatureInstaller] - Failed installing 'openhab-persistence-jdbc'

I deleted all tables in my database, after installing, i have a new table “items” empty and nothing more.

H102 · April 8, 2020, 2:45pm

Stop OH clean the cache then after OH has fully restarted do two more restarts.

FyingEaglE · April 8, 2020, 2:46pm

I restarted OH nearly every 30 minutes since the last two days.

rlkoshak · April 8, 2020, 3:24pm

Are you or have you ever used $OH_CONF/services/addons.cfg? This file takes precedence over all others so if you have an entry in that file for persistence addons, even if it’s blank, periodically OH will check it, see that the jdbc binding is not configured and uninstall it.

FyingEaglE · April 8, 2020, 3:31pm

Yes I had, but removed it also…

I think I missed to delete the cache-dir, now the messages are gone …

Next step to hell, re-install the jdbc-mariadb …

FyingEaglE · April 8, 2020, 4:11pm

I think I’m going nuts.
I fumble around here for two days and now it works without further error messages.
But it looks like I have to reinstall the bindings etc. now. At least the config files are not gone.
Thanks a lot!

mhmreza · June 28, 2020, 5:53pm

Hi Rick
I installed mysql but in subfolder persistance no file create.
i expect that mysql.persist create in that route.
i must create it manually or i’m wrong?

lewie · June 29, 2020, 2:13pm

Hi mhmreza,
no, if you use jdbc-mariadb the name for configuration file is “jdbc.persist”. It should be created. There you can config as known from old mysql.persist generated by the mysql binding.

mhmreza · June 29, 2020, 2:37pm

I installed mysql binding but mysql.persist doesn’t create… what should i do?

lewie · June 29, 2020, 2:45pm

If it is not generated, create it.

“jdbc-mysql” binding -> jdbc.persist and for the “mysql” binding -> mysql.persist

Note: All “jdbc-*” Bindings were developed as the replacement of the “mysql” binding. The “mysql” is obsolete and is no longer developed in opneHAB 3.