MySQL 8.0


(Andrew Oke) #1

I’m currently in the process of upgrading all my local mysql stuff to version 8. It looks like openhab doesn’t have support for this yet in either the mysql or jdbc-mysql modules. I’m wondering if I’m able to drop a new jar in the addons folder. The version in jdbc-mysql is mysql-connector-java-5.1.39.jar and is it possible to upgrade to 8.0.13? Any help is appreciated.


(Dominik Benner) #2

Hi!
Did you found a solution?


(Martin van Wingerden) #3

Facing the same problem here :slight_smile:

I created an issue: https://github.com/openhab/openhab1-addons/issues/5698


(Dominik Benner) #4

I found a solution.
In karaf console delete the v5 dB driver bundle with bundle:remove.
Download mysql v8 driver from maven repo and copy it to add-ons folder
Restart openhab an you’re done.


(Martin van Wingerden) #5

And I created a PR, essentially doing the same


(Andrew Oke) #6

Amazing! One project updated. Thanks for the tip.


(Dominik Benner) #7

Hi!

With the new 2.4 stable the JDBC mysql persistence still loads the v5 driver not v8.
So i’m fine with my workaround…