graphs show wrong current time after chaning localtime

[easytouch]

While Zabbix was running I had to correct the timezone and date on the Linux Server.

On a screen the Flash Clock displays the correct system time,
but the graphs show at the right end a wrong current time.
The graphs are now 6 hours in the past.
(The difference of the timezone before and after the change on OS level)

I tried to TRUNCATE all history and trends tables,
and clearedall values of hosts.disable_until,
but the graphs stay in the past (see screenshot).

Also > Monitoring > Latest data shows values in the past.

Seems that some mysql timestamps have messed up.

How can I reset the whole thing?
Where does Zabbix Webinterface get the current time information for the graphs and latest data?

Thanks in advance for any help.

[easytouch]

different clocks on linux

Aha, the Hardware Clock was not set

# date
Mon Aug 13 18:48:52 CEST 2007

# ls -l /etc/localtime
-rw-r--r-- 1 root root 1267 2007-08-12 17:09 /etc/localtime

# hwclock
Mon 13 Aug 2007 12:49:02 PM CEST  -0.422784 seconds

I also set date.timezone in php.ini

but after restarting apache, mysql, zabbix-agent and zabbix-server still the same problem with graphs some hours back.

[easytouch]

After making hwclock permanent and the hours difference have been past,
now the graphs are at the right time again.

Is this because of the 'nextcheck' and 'lastclock' columns in the 'items' table?