Hello all,
thank you for all the hints. I am not a expert and I try my best (I know, that my answers or my information to solve this issue are not very satisfactory).
At the end
- only one persistence module was active in the addons.cfg file
- in the jdbc.cfg file the user=openhab was listed (I do not know where root or openhab.fritz.box was defined)
- in the jdbc.cfg file I changed the url from IP to localhost
url=jdbc:mariadb://localhost:3306/OpenHAB?serverTimezone=Europe/Berlin
And I got an ERROR in the log file which was similar / like
[ERROR] [nal.common.AbstractInvocationHandler] - An error occurred while calling method ‘QueryablePersistenceService.query()’ on ‘org.openhab.core.persistence.internal.QueryablePersistenceServiceDelegate@1813401’: java.lang.Integer cannot be cast to java.lang.Long
This was mentioned in
A friend spend some time to check some things and he changed the log level.
Now we think that my jdbc version and the mariadb version are not compatiple
I deactivated all persistence files, uninstall the persistence and I got another error message
2020-06-12 20:07:54.090 [ERROR] [core.karaf.internal.FeatureInstaller] - Failed installing ‘openhab-persistence-jdbc’
But I got a lot of other errors in my log I think my installation is messed up so I will install it new.
The configuration files are saved it will be not so much work to install it new
In this request I have learnd to use the log (very important point) and write detaild requests answers
Marcel