1.2.14 OVF timezone change about cacti-template

[KnoAll]

There is not another place that I'm aware of that I recall. I can go through and check though.

[mottld]

It turns out the graphs started populating after the difference in timezones. In this case after 3 hours.

You should think about making your ovf UTC time.

I will close the case.

[KnoAll]

Interesting. good to know the changes you made worked.

[mottld]

Turns out mysql is still pulling the wrong system timezone information. Looking in cacti->system utilities->Technical Support->Database Settings the variable time_zone was set to PST (Not sure where this is coming from)

logging into mysql and running SELECT @@global.time_zone; i get SYSTEM so it should have been pulling it from the system timezone. I ended up editing /etc/my.cnf and adding the line

default-time-zone='America/New_York'

restart mysql and all is right with the world now.

Any idea where it is getting the PST value from? Is there a environment variable set someplace?

[KnoAll]

Interesting. I'm not exactly sure where MYSQL would be pulling that from. Seems the SYSTEM setting should prevail there. I'll have to check around. Perhaps I'll add the line you indicated to my.cnf so that it is easier for others to find.

[KnoAll]

The MariaDB support docs indicate that the system_time_zone is pulled at OS startup....
https://mariadb.com/kb/en/server-system-variables/#system_time_zone
Did you reboot the system after TZ change? If not this could explain why that value did not update.

[KnoAll]

I did some testing and this is indeed the case. the System timezone setting does not take effect until reboot so MYSQL will not pick up the change

[mottld]

Yeah I rebooted a few times. I may try a second install. I'll close this ticket and will reopen if I find anything different.