OpenHAB2 JDBC Persistence funktioniert nicht mehr

openHAB - open Home Automation Bus

Moderator: Co-Administratoren

Antworten
mrburns
Beiträge: 89
Registriert: 03.06.2018, 19:49
Hat sich bedankt: 4 Mal

OpenHAB2 JDBC Persistence funktioniert nicht mehr

Beitrag von mrburns » 31.12.2018, 15:30

Hallo,

seit ich auf openHAB 2.4.0-1 upgegraded habe, funktioniert meine JDBC Persistence nicht mehr :cry:.
In openHAB 2 Log Viewer bekomme ich folgende Meldung;

CLIENT_PLUGIN_AUTH is required

der openHAB LogViewer zeigt:
2018-12-31 14:43:07.392 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Failed connecting to the SQL database using: driverClass=com.mysql.jdbc.Driver, url=jdbc:mysql://192.168.XXX.YYY/openhab, user=XXXYYY

java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[228:org.openhab.persistence.mysql:1.13.0]

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[228:org.openhab.persistence.mysql:1.13.0]

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[228:org.openhab.persistence.mysql:1.13.0]

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[228:org.openhab.persistence.mysql:1.13.0]

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[228:org.openhab.persistence.mysql:1.13.0]

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:79) ~[228:org.openhab.persistence.mysql:1.13.0]

at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) ~[228:org.openhab.persistence.mysql:1.13.0]

at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) ~[228:org.openhab.persistence.mysql:1.13.0]

at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) ~[228:org.openhab.persistence.mysql:1.13.0]

at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207) ~[228:org.openhab.persistence.mysql:1.13.0]

at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:?]

at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:?]

at org.openhab.persistence.mysql.internal.MysqlPersistenceService.connectToDatabase(MysqlPersistenceService.java:521) [228:org.openhab.persistence.mysql:1.13.0]

at org.openhab.persistence.mysql.internal.MysqlPersistenceService.activate(MysqlPersistenceService.java:191) [228:org.openhab.persistence.mysql:1.13.0]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]

at java.lang.reflect.Method.invoke(Method.java:498) ~[?:?]

at org.apache.felix.scr.impl.inject.methods.BaseMethod.invokeMethod(BaseMethod.java:228) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.inject.methods.BaseMethod.access$500(BaseMethod.java:41) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.inject.methods.BaseMethod$Resolved.invoke(BaseMethod.java:664) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.inject.methods.BaseMethod.invoke(BaseMethod.java:510) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:317) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:307) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:334) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:114) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:947) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:919) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:863) [40:org.apache.felix.scr:2.1.2]

at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse$1.run(ServiceFactoryUse.java:212) [?:?]

at java.security.AccessController.doPrivileged(Native Method) ~[?:?]

at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse.factoryGetService(ServiceFactoryUse.java:210) [?:?]

at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse.getService(ServiceFactoryUse.java:111) [?:?]

at org.eclipse.osgi.internal.serviceregistry.ServiceConsumer$2.getService(ServiceConsumer.java:45) [?:?]

at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.getService(ServiceRegistrationImpl.java:508) [?:?]

at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.getService(ServiceRegistry.java:461) [?:?]

at org.eclipse.osgi.internal.framework.BundleContextImpl.getService(BundleContextImpl.java:624) [?:?]

at org.apache.felix.scr.impl.manager.SingleRefPair.getServiceObject(SingleRefPair.java:73) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.inject.BindParameters.getServiceObject(BindParameters.java:47) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.inject.methods.BindMethod.getServiceObject(BindMethod.java:662) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.DependencyManager.getServiceObject(DependencyManager.java:2304) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.DependencyManager.doInvokeBindMethod(DependencyManager.java:1801) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.DependencyManager.invokeBindMethod(DependencyManager.java:1784) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.SingleComponentManager.invokeBindMethod(SingleComponentManager.java:409) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.DependencyManager$MultipleDynamicCustomizer.addedService(DependencyManager.java:333) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.DependencyManager$MultipleDynamicCustomizer.addedService(DependencyManager.java:302) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1216) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1137) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.trackAdding(ServiceTracker.java:944) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.track(ServiceTracker.java:880) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1168) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:125) [40:org.apache.felix.scr:2.1.2]

at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) [?:?]

at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:920) [?:?]

at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) [?:?]

at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) [?:?]

at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) [?:?]

at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) [?:?]

at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) [?:?]

at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) [?:?]

at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:469) [?:?]

at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:891) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:877) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:128) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:944) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:727) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.AbstractComponentManager.enableInternal(AbstractComponentManager.java:661) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.AbstractComponentManager.enable(AbstractComponentManager.java:427) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.manager.ConfigurableComponentHolder.enableComponents(ConfigurableComponentHolder.java:665) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.BundleComponentActivator.initialEnable(BundleComponentActivator.java:339) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.Activator.loadComponents(Activator.java:381) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.Activator.access$200(Activator.java:49) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.Activator$ScrExtension.start(Activator.java:263) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.AbstractExtender.createExtension(AbstractExtender.java:196) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.AbstractExtender.modifiedBundle(AbstractExtender.java:169) [40:org.apache.felix.scr:2.1.2]

at org.apache.felix.scr.impl.AbstractExtender.modifiedBundle(AbstractExtender.java:49) [40:org.apache.felix.scr:2.1.2]

at org.osgi.util.tracker.BundleTracker$Tracked.customizerModified(BundleTracker.java:482) [?:?]

at org.osgi.util.tracker.BundleTracker$Tracked.customizerModified(BundleTracker.java:415) [?:?]

at org.osgi.util.tracker.AbstractTracked.track(AbstractTracked.java:232) [?:?]

at org.osgi.util.tracker.BundleTracker$Tracked.bundleChanged(BundleTracker.java:444) [?:?]

at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:908) [?:?]

at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) [?:?]

at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) [?:?]

at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEventPrivileged(EquinoxEventPublisher.java:213) [?:?]

at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEvent(EquinoxEventPublisher.java:120) [?:?]

at org.eclipse.osgi.internal.framework.EquinoxEventPublisher.publishBundleEvent(EquinoxEventPublisher.java:112) [?:?]

at org.eclipse.osgi.internal.framework.EquinoxContainerAdaptor.publishModuleEvent(EquinoxContainerAdaptor.java:168) [?:?]

at org.eclipse.osgi.container.Module.publishEvent(Module.java:476) [?:?]

at org.eclipse.osgi.container.Module.start(Module.java:467) [?:?]

at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1634) [?:?]

at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.incStartLevel(ModuleContainer.java:1614) [?:?]

at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.doContainerStartLevel(ModuleContainer.java:1585) [?:?]

at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1528) [?:?]

at org.eclipse.osgi.container.ModuleContainer$ContainerStartLevel.dispatchEvent(ModuleContainer.java:1) [?:?]

at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) [?:?]

at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) [?:?]

Caused by: com.mysql.cj.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:?]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]

at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:?]

at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[?:?]

at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~[?:?]

at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:205) ~[?:?]

at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1442) ~[?:?]

at com.mysql.cj.NativeSession.connect(NativeSession.java:165) ~[?:?]

at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:955) ~[?:?]

at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825) ~[?:?]

... 89 more
Meine MySQL-Server-Version ist 5.1.56, und kann nicht upgegraded werden, da die MySQL-Datenbank in einem MyCloud Ext 2-System ist und dann evtl. MyCloud nicht mehr funktioniert.

Habe gelesen, dass es wohl mit dem neueren JDBC-Treiber zu tun hat. Dieser kam wohl als ich mit

Code: Alles auswählen

sudo apt-get update; sudo apt-get upgrade
auf 2.4.0-1 geupdated habe.
Kann ich irgendwie den 'alten' JDBC-Treiber wieder installieren? Ich weiß aber nicht mehr welche Versionsnummer der hatte :oops:.
Und ich weiß auch nicht, ob openHAB 2.4.0-1 dann mit dem 'alten' JDBC-Treiber zurecht kommt.

Wie kann ich das Problem 'CLIENT_PLUGIN_AUTH is required' nun lösen?

Vielen Dank für jede Art von Hilfe...

hoedlmoser
Beiträge: 215
Registriert: 19.01.2015, 07:42
Hat sich bedankt: 22 Mal
Danksagung erhalten: 8 Mal

Re: OpenHAB2 JDBC Persistence funktioniert nicht mehr

Beitrag von hoedlmoser » 02.01.2019, 01:09

1. code tags verwenden
2. ein MySQL 5.1 will man nicht mehr betreiben https://en.wikipedia.org/wiki/MySQL#Release_history
RaspberryMatic 3.73.9.20231130 on Proxmox, HB-RF-ETH and Aurel Groundplane binded by openHAB 4.1.1

Antworten

Zurück zu „openHAB“