I have a MySQL server running on a machine that (for reasons outside my control) is running in the America/Los_Angeles timezone while the OH2 Server is running in TZ Europe/Madrid.
I previously used to use the mysql persistence service with the configuration option to use OH2’s local time and all was happy.
After moving to the JDBC MySQL service for stability reasons, I seem to be unable to get the same behaviour.
At the end of the connection string I’ve added ?serverTimezone=America/Los_Angeles but all my logging shows up 9 hours back in time anyway. I also tried ?serverTimezone=Europe/Madrid instead and had the same result.
How can I make OH2 use the right TZ offset when logging its things so my charts aren’t all messed up?
Ah, I forgot to mention I tried that
It just dumps lots of information in the logs (I watched it in the karaf console) about how long the interactions with the database take, so it’s something entirely different
Has anyone come up with an answer to the original issue? That is, persisting to a mysql with a different timezone? What I am seeing is that the data is being stored in the timezone of the database server and being queried in the timezone of openhab. The effect is that habpanel never shows the most recent data.