Graph times incorrect -- doesn't match system time

[nishr]

I know I've searched over the forums but I can't find an issue quite like this. DST obviously came early and I thought that might have been the cause of my issues.

Earlier, I looked at my graph and thought it had stopped graphing. Then I realized it was just 'graphing' data an hour behind the end of the graph. Thinking that it must be related to DST, I checked my system clock. Sure enough, the clock was one hour behind the time it should be. I adjusted the system clock and a gap appeared in the graph. Save it didn't even really 'adjust' anything. The graph data is *still* an hour behind.

My system says this:
[root@cplxneatc log]# date
Mon Mar 12 16:45:40 CST 2007

The cacti logs are weird:
03/12/2007 04:45:06 PM - CACTID: Poller[0] Host[32] DS[4578] WARNING: Result from SNMP not valid. Partial Result: ...
03/12/2007 04:45:06 PM - CACTID: Poller[0] Host[32] DS[4579] WARNING: Result from SNMP not valid. Partial Result: ...
03/12/2007 04:45:06 PM - CACTID: Poller[0] Host[32] DS[4580] WARNING: Result from SNMP not valid. Partial Result: ...
03/12/2007 05:45:15 PM - SYSTEM STATS: Time:13.7857 Method:cactid Processes:5 Threads:5 Hosts:26 HostsPerProcess:6 DataSources:3326 RRDsProcessed:1522

Notice the hour difference? It's 4:45 right now and cactid shows that in the logs. However, when it finishes and prints the system stats summary, the time says it's one hour ahead? 5:45?

Cacti must believe it's 5:45 because thats what the one day graphs say (yesterday 5:45 to today 5:45).

Attached is an image of my graph. You can see the gap where I adjusted it once. Then I realized it was still an hour behind. It's almost like it's scaling to keep up with me. So the graph has data at 3:45. My System says it's 4:45 (which it is) and the logs show polling at 4:45 (correct) but the summary prints an incorrect time of 5:45. Strange?

Im sure there is something stupid I'm not doing. Can anyone please help or point me in the right direction? I checked the rrd files and they show the correct timestamp as well.

I did notice this fedora core box appeared patched for dst:
[root@cplxneatc log]# zdump -v CST5CDT | grep 2007
CST5CDT Sun Mar 11 06:59:59 2007 UTC = Sun Mar 11 01:59:59 2007 CST isdst=0 gmtoff=-18000
CST5CDT Sun Mar 11 07:00:00 2007 UTC = Sun Mar 11 03:00:00 2007 CDT isdst=1 gmtoff=-14400
CST5CDT Sun Nov 4 05:59:59 2007 UTC = Sun Nov 4 01:59:59 2007 CDT isdst=1 gmtoff=-14400
CST5CDT Sun Nov 4 06:00:00 2007 UTC = Sun Nov 4 01:00:00 2007 CST isdst=0 gmtoff=-18000

Which is odd, because my system time never updated anyways. Any help?

[Linegod]

Is the timezone in your php.ini set? ie: date.timezone=America/Regina

Note: If you set/reset it in your php.ini , remember to reload your webserver.

[nishr]

Is the timezone in your php.ini set? ie: date.timezone=America/Regina

Note: If you set/reset it in your php.ini , remember to reload your webserver.

Good suggestion, I tried that. It didn't work. It appears that RRD just isn't updating at the current time stamp. I dumped an rrd file at 9:45 CST (about 10 mins ago) and saw:

<lastupdate> 1173797104 </lastupdate> <!-- 2007-03-13 08:45:04 CST -->

The graphs do indeed scale to 9:45, but only have data at 8:45 wich aligns with when rrd said the last update was. This is probably because I messed with the system time. Do I need to look for something in the file to fix it?

[Linegod]

Is your '/etc/localtime' set correctly?

You might try symbolically linking the localtime to the configuration, fixing the date and resetting your clock.

Code: Select all

$ su
# rm -rf /etc/localtime
# ln -s /usr/share/zoneinfo/Canada/Saskatchewan /etc/localtime (use your timezone :) )
# ls -la /etc/localtime 
lrwxrwxrwx 1 root root 39 Oct  2 09:42 /etc/localtime -> /usr/share/zoneinfo/Canada/Saskatchewan 
# date MMDDhhmm2007 (fill in with proper time)
# clock --localtime
# clock --systohc

I had issues a while ago with one of my Mandriva boxes, and this, along with php.ini fixed it up.

[nishr]

Is your '/etc/localtime' set correctly?

You might try symbolically linking the localtime to the configuration, fixing the date and resetting your clock.

I had issues a while ago with one of my Mandriva boxes, and this, along with php.ini fixed it up.

Thank you linegod, this appears to have fixed me. The logs now look right and a one hour gap has appeared. Everything seems correct now. Thank you!

[adnanmir]

hi every one , I am having a similar issue with my windows 7 ultimate machine, my system clock is showing 5.28pm where as cacti log is displaying 10:28pm , i have no graphs coming up in my screen. i have very less knowledge about this thing please help me, in getting my first ever graph run on the machine