I migrated to OH 3 on Openhabian quite easily (great job you did there!) and now I am setting up the pages.
In the demo I really liked the Temperatures page with the trend lines and Analyse option. So I added a first item to a page and it works almost fine, but it seems to be missing the last hour of data in the chart.
I use a mariaDB for persistence.
I checked on all timezone settings and they seem to be ok.
$ timedatectl
Local time: Mon 2020-12-28 14:26:24 CET
Universal time: Mon 2020-12-28 13:26:24 UTC
RTC time: n/a
Time zone: Europe/Amsterdam (CET, +0100)
System clock synchronized: yes
NTP service: active
RTC in local TZ: no
Since this is not happening in the demo, I was wondering if there might be something wrong in some config I missed. Or should I report it as a bug?
Anyone else having the same experience or a solution?
I’m using rrd4j as database and it is working as expected ( no missing hour). I am also on CET, did you set your timezone also in openHAB regional settings?
I just discovered a fix (or better “work-around”) for that issue. (shoutout to @Xypersonic, who seems to have the same issue).
If you set the server time zone to match the database time zone, the issue seems to be gone.
You may use the documentation at https://linuxconfig.org/how-to-set-time-on-raspberry-pi on how to set the time zone for openhabian.
If you use openhabian, then it boils down to:
ssh openhabian@youropenhabianserver # default password is openhabian
sudo raspi-config
# now open the "Localisation Options" and set the correct locale, in my case Europe/Berlin
systemctl restart openhab # just to be sure all changes apply ;)
This did the trick for me. I use jdbc persistence with MariaDB on a Synology NAS. The database time zone is also Europe/Berlin.
