Graphs no longer showing new data after upgrading to 1.2.9 & updating system timezone

[RFick73]

Hello,

Please be gentle as I'm new to systems administration (CentOS7) & I'm totally new to using Cacti & I'm running into the following issue after using yum update to go from 1.2.8 to 1.2.9 & updating the system timezone.
If I recall, the sequence that I did this, I ran the yum update, updated the systems timezone from America/Winnipeg to America/Vancouver & then went to the web interface to finalize the Cacti upgrade.
Since then, I have seen no new graph data populate in my graphs. The last timestamp I see in the web interface graphs looks to be correct but there is no graphing data from what I assume was directly after I made the previous two changes.
My system time before making the timezone change: Tue Feb 25 13:37:59 CST 2020
My system time after making the timezone change: Tue Feb 25 11:39:07 PST 2020
After reading this post (viewtopic.php?t=3081) I thought I'd only have to wait until the system time passed the last known graphing time which was a 2 hour wait but that time has come & gone by almost 20mins to no avail.

Any suggestions would be greatly appreciated.

Thank You.

[netniV]

Make sure all timezones across all php, mysql, system and if necessary web server software are on the same timezone. That's very important.

Aside from that, make sure you've enabled your system cron to run the poller again.

[RFick73]

Further to this post. I totally forgot I was requested to also change the polling to every minute. I made the change in the web interface but I did not change the cron job, it looks like this was my culprit as to why I was not receiving graphing data. I have changed it back to every 5 mins in the interface & I'm now receiving graphing data again, but there is a discrepancy to the time it is placing the data at. It is still placing the graphing data 2 hours in the past but it shows the correct time at the bottom of the graph. The system time is correct though.

image.png (73.83 KiB) Viewed 905 times

What must I do to get the data to now start to show the correct time stamp & is there an "easy" way to have all the old data shifted up by 2 hours? It's only a few days worth, so if not it's not the end of the world.

[RFick73]

After looking at the configuration files & trying to figure out how to change the timezone in mariadb, it looks like restarting mariadb fixed my display issue & the graphs are now populating graph data with the correct time. YAY!

My previous question still stands, is there an "easy" way to take the older data & move it forward by 2 hours?

[netniV]

The date is stored in epoch time if I remember rightly, so it's timezone independant, the reason we need all the timezones in sync is because we have to convert input that isn't in epoch/UTC time to epoch for comparision. So if one part of the system is comparing in one timezone, and the other in a different one, it doesn't get handled correctly since 8pm in the UTC timezone is different to 8pm in the EST one.

I think as long as you change ALL timezones to the same one, you should be OK (oh and restart MariaDB )

[RFick73]

Rather than stacking issues in the same post, I have created a new one here: viewtopic.php?f=2&t=60704
Please close this post. Thank You.