mySQL persistence shows wrong time

mr.burns · July 22, 2018, 12:36pm

Hi,

today I tried to configure persistence using an external mySQL database.
My openhabianpi shows correct time and the external mySQL database server as well.
But in the itemsX-tables show wrong timestamps and my HABPanel charts show these wrong time values as well.

What time is used here? Where I can adjust the time?

Thanks…

mr.burns · July 22, 2018, 7:49pm

Hi,

I found out something more:

Using phpmyadmin I tested following command:

SELET NOW();

It shows 12:46:51

If run the ‘date’ command via SSH on the mySQL server I get:

Sun Jul 22 21:46:51 CEST 2018

So for some reason there is adifference in the server’s time and the mySQL time.
How can I correct this?

Thanks…

vzorglub · July 22, 2018, 8:46pm

Have you tried a mysql help forum?

mr.burns · July 23, 2018, 5:27am

Yes - but up to now I don’t have any solution yet.

Maximo · July 23, 2018, 7:41am

Have you checked to make sure the timezone for MySQL has been configured correctly?

mr.burns · January 12, 2019, 10:02pm

Yes the timezone on MySQL server is correct.
I gave up now with MySQL and switched to influxDB and Grafana which nice and smoothy!