Re: [Perfparse-users] Graph dates wrong

[Ben C. <bcl...@pe...>]

Can you please check the time zone on your system is correct?  I believe 
some of the figures are stored as UTC and converted to your time zone on 
  read.  Both on your MySQL system and the Perfparse / Nagios system.

If not this may be a bug.

Check your UNIX installation on configuration to set your UNIX timezone.

You can check this easily in MySQL:

mysql> SELECT NOW();
mysql> SET SET time_zone = 'posix/UTC';
mysql> SELECT NOW();
mysql> SET SET time_zone = 'America/Los_Angeles';
mysql> SELECT NOW();

Do these return correct values?

Regards,

Ben Clewett.

Jonnathan Colt wrote:
> I have the same problem with graphs not showing the correct time, mine 
> are about 8 hours off.  The server is correct in my case as well.....
> 
> Thanks,
> Jon
> 
> Jordan Kirby wrote:
> 
>> Hi,
>>
>> I'm seeing a slightly odd problem with the rendered graphs.
>> See:
>> http://64.69.162.90/nagios/cgi-bin/perfgant.png?host=websites&service=ht
>> tp%3A%2F%2Fwww%2Erutland%2Egov%2Euk%2F&from=2005%2F10%2F01+00%3A00%3A01&
>> to=2005%2F11%2F1+23%3A59%3A59
>>
>> That _should_ be showing from "2005-10-01 00:00:01" to "2005-11-01
>> 23:59:59", yet when the graph is drawn it's showing today's data (ie.
>> The incomplete data) on yesterdays date, and also an hour ahead. The
>> server date and time are correctly set, and so is the hardware clock on
>> the server. The data in the database contains the correct date and time
>> too.
>>
>> Anyone got any ideas why it's doing this?
>>
>> Thanks
>>
>> Jordan
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by the JBoss Inc.
>> Get Certified Today * Register for a JBoss Training Course
>> Free Certification Exam for All Training Attendees Through End of 2005
>> Visit http://www.jboss.com/services/certification for more information
>> _______________________________________________
>> Perfparse-users mailing list
>> Per...@li...
>> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>>  
>>
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. 
> Download
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>