Cacti Time change - no longer graphing

[Primüs]

Hey guys,

Having an issue with my Cacti, after installing my Linux distro and everything on my box (running centos 5 if it makes a diff.), i went through the whole cacti install process (which i have done a couple times before, but i am familiar with SQL, PHP and httpd/apache). Everything was running sweet it was graphing, then i realised my time config was screwed. My server thought it was tomorrow at the morning, except for today at night, so i did the usual linux time update procudes using the date -s command and now when running poller.php i get the following:

Code: Select all

[root@nix-box cacti]# php poller.php
ERROR: illegal attempt to update using time 1192063528 when last update time is 1192147801 (minimum one second step)
ERROR: illegal attempt to update using time 1192063528 when last update time is 1192147801 (minimum one second step)
ERROR: illegal attempt to update using time 1192063528 when last update time is 1192147801 (minimum one second step)
ERROR: illegal attempt to update using time 1192063528 when last update time is 1192147801 (minimum one second step)
ERROR: illegal attempt to update using time 1192063528 when last update time is 1192147801 (minimum one second step)
ERROR: illegal attempt to update using time 1192063528 when last update time is 1192147801 (minimum one second step)
ERROR: illegal attempt to update using time 1192063529 when last update time is 1192147801 (minimum one second step)
ERROR: illegal attempt to update using time 1192063529 when last update time is 1192147801 (minimum one second step)
ERROR: illegal attempt to update using time 1192063529 when last update time is 1192147801 (minimum one second step)
ERROR: illegal attempt to update using time 1192063529 when last update time is 1192147801 (minimum one second step)
ERROR: illegal attempt to update using time 1192063530 when last update time is 1192147808 (minimum one second step)
ERROR: illegal attempt to update using time 1192063530 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063530 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063530 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063530 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063530 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063530 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063530 when last update time is 1192147808 (minimum one second step)
ERROR: illegal attempt to update using time 1192063530 when last update time is 1192147808 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
ERROR: illegal attempt to update using time 1192063531 when last update time is 1192147807 (minimum one second step)
10/11/2007 10:45:34 AM - SYSTEM STATS: Time:6.4157 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:49 RRDsProcessed:30

I figure this is because cacti thinks its still tomorrow due to its last lot of successful updates, so it wont update me, how do i change cacti's data or structure to make it run the process again, or will i have to wait for a day till the time catches itself up? (if this will work).

Thanks

[rony]

It will catch up, it's an RRDTool issue.

In the future, it's important to remember to set the time correctly before you start up Cacti graphing.

Also, if you do need to alter the time, make sure you do it slowly over a period of time, so that you graphs are still updated.

[caves]

I had a similar issue today, my server rebooted and it used the hardware clock which was set one month from now. So when cacti started polling I lost more than a month worth of polls.

I now have NaN values from today to November 26, 2007 which at the time of this post is in the future.

Is there a way to erase all those NaN and start graphing from today again?
Because at this moment I cannot replace the info, at lease don't know how to.

Thanks for your help.

Jorge

[TheWitness]

Not easily. Many companites set the clock to something like GMT to avoid such issues.

TheWitness