RE: [Perfparse-users] Graph dates wrong

[Jordan K. <Jor...@ro...>]

Hi,

The timezone is correctly set to GMT, and SELECT now(); returns the
correct date/time.
I can't seem to set the timezone in mysql to anything different (if I
try "SET timezone =3D 'posix/UTC'; " I just get unknown system variable,
the same with time_zone).

SHOW VARIABLES; reports the timezone as GMT.



Jordan



-----Original Message-----
From: per...@li...
[mailto:per...@li...] On Behalf Of Ben
Clewett
Sent: 02 November 2005 08:27
To: Jonnathan Colt
Cc: per...@li...
Subject: Re: [Perfparse-users] Graph dates wrong

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 =3D 'posix/UTC';
mysql> SELECT NOW();
mysql> SET SET time_zone =3D 'America/Los_Angeles'; 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.....
>=20
> Thanks,
> Jon
>=20
> Jordan Kirby wrote:
>=20
>> Hi,
>>
>> I'm seeing a slightly odd problem with the rendered graphs.
>> See:
>> =
http://64.69.162.90/nagios/cgi-bin/perfgant.png?host=3Dwebsites&service
>> =3Dht=20
>> =
tp%3A%2F%2Fwww%2Erutland%2Egov%2Euk%2F&from=3D2005%2F10%2F01+00%3A00%3A
>> 01&
>> to=3D2005%2F11%2F1+23%3A59%3A59
>>
>> That _should_ be showing from "2005-10-01 00:00:01" to "2005-11-01=20
>> 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=20
>> server date and time are correctly set, and so is the hardware clock=20
>> 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=20
>> Certification Exam for All Training Attendees Through End of 2005=20
>> Visit http://www.jboss.com/services/certification for more=20
>> information _______________________________________________
>> Perfparse-users mailing list
>> Per...@li...
>> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>> =20
>>
>=20
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server.=20
> Download
> it for free - -and be entered to win a 42" plasma tv or your very own=20
> 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
>=20



-------------------------------------------------------
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