today after a restart of openhab i get the message below…
The server time zone value ‘CEST’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
had the same issue after a reboot
I used this tutorial and changed the time zone configuration for my MariaDB-Server from “SYSTEM” to “+02:00”. The only difference was, that I needed to change the file /etc/mysql/my.cnf. I just added the line as given in the tutorial, did a restart and Openhab (and persistence) works as expected.
The only thing is- I assume- I need to do that change again with the next change to “Winter Time” to ammend then to “+01:00”. Anyone an idea how to fix this properly?
Cheers
Matthias.
P.S.: what happened is that we changed just this weekend from CET (Central European Time) to CEST (Central European SUMMER Time). So we changed from Winter Time to Summer Time and looks like that JDBC Driver or MariaDB or whatever only understands CET??? Time to get rid of the time changes…