Hi Tom
Mysql is using the system timezone, and that is correct,
The difference between my time zone and UTC is 2 hours, i am SAST and that is +2:00
mysql> select now(); +---------------------+ | now() | +---------------------+ | 2016-10-11 07:13:35 | +---------------------+ 1 row in set (0.00 sec)
mysql> SELECT @@session.time_zone; +---------------------+ | @@session.time_zone | +---------------------+ | SYSTEM | +---------------------+ 1 row in set (0.00 sec)
mysql> SELECT @@global.time_zone; +--------------------+ | @@global.time_zone | +--------------------+ | SYSTEM | +--------------------+ 1 row in set (0.00 sec)
mysql> SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP); +--------------------------------+ | TIMEDIFF(NOW(), UTC_TIMESTAMP) | +--------------------------------+ | 02:00:00 | +--------------------------------+ 1 row in set (0.00 sec)
On 10 Oct 2016, at 20:33, Tom Laermans tom.laermans@powersource.cx wrote:
Hi Lyndon,
Check the MySQL timezone maybe?
Tom
On 10/10/2016 13:42, Lyndon Labuschagne wrote:
HI All
Can anyone point me in the right direction?
The billing graphs are working well, but for some reason the graph is 2 hours ahead. I assumed it may be the date.timezone setting in php.ini but that wasn't it. Thought it may have been the router time zone or incorrect NTP info, but that is also correct.
The Last Polled and Last Calculated times are correct.
Im sure its something simple that I am missing, but I can't fine it.
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium