Page 2 of 2

Re: Please help with this SQL error!!

Posted: Wed May 03, 2017 2:00 pm
by tgriep
What I think the problem was at one time the systems time was incorrectly set to a time in the future and the graphs were updated.
Then the time on the server was put back to the correct time, all of the rrd files timestamp were in the future so the RRD will not update because the current time is less than the file timestamp.
You could reset the timestamp recursively for all of the files/folders by changing to the following folder

Code: Select all

/usr/local/pnp4nagios/var/perfdata/
And running the command below

Code: Select all

find ./ -exec touch {} \;
Try that and see if the graphs start to populate again.