Newbee: openHAB 2 tail shows MysqlPersistenceService error


(MrBurns) #1

Hi,

On starting openHAB 2 (V2.4.0-1) I get MysqlPersistenceService error, tail shows:

[ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Failed connecting to the SQL database using: driverClass=com.mysql.jdbc.Driver, url=jdbc:mysql://192.168.178.35/openhab, user=xxyyzzz

java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required

What does that mean and how can I get rid of it?

Thanks…


(Elias H.) #2

Uhm… well if you don’t use MySQL just uninstall the persistence binding?..

People would like to help you, but you make it hard for us… please consider reading this


(CM6.5 H102) #3

Maybe you need to add your password to mysql.cfg


(MrBurns) #4

Hi,

sorry may I was not very clear in my 1st post.
What I want to know is how to solve the error ‘CLIENT_PLUGIN_AUTH is required’?
I need the mysql database to store my values like temperature sensors, humidity sensors etc…
The database server is a Western Digital MyCloud. The mySQL version on the MyCloud server is 5.1.56.
The problem is I cannot update the mySQL to a newer version because then my MyCloud would not work anymore because MyCloud uses the database as well as I understand.
Username and password are already set in jdbc.cfg.


(MrBurns) #5

Hi,

I still need some help on this issue.
Any hint is appreciated.

Thanks a lot…