Re: [Perfparse-users] Graph dates wrong

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

Jordon,

You say your Nagios and MySQL server are set to GMT.  From last week 
this should be correct.  (I guess you co.uk means you are in the UK.)

Can you give me more information.  When you select an absolute time 
range, is the data you get back in the correct range, but the data 
relating to 8 hours ago.  Or is the data 8 hours out from your date 
range, but otherwise correct?

Ben


Jordan Kirby wrote:
> Hi,
> 
> Yeah, the times are correct in the database.
> 
> mysql> select ctime from perfdata_service_bin order by id desc limit 10;
> +---------------------+
> | ctime               |
> +---------------------+
> | 2005-11-02 14:16:56 |
> | 2005-11-02 14:16:55 |
> | 2005-11-02 14:15:56 |
> | 2005-11-02 14:15:56 |
> | 2005-11-02 14:15:56 |
> | 2005-11-02 14:15:45 |
> | 2005-11-02 14:15:15 |
> | 2005-11-02 14:15:15 |
> | 2005-11-02 14:15:15 |
> | 2005-11-02 14:15:15 |
> +---------------------+
> 10 rows in set (0.00 sec)
> 
> Both the nagios server and the mysql server machines are set to GMT too.
> 
> Jordan
>  
> 
> -----Original Message-----
> From: Ben Clewett [mailto:bcl...@pe...] 
> Sent: 02 November 2005 14:14
> To: Jordan Kirby
> Cc: per...@li...
> Subject: Re: [Perfparse-users] Graph dates wrong
> 
> Jordan,
> 
> MySQL 4.0 is dumb on time zone information, so this is probably not the
> cause of the problems.
> 
> This can be checked, look at the time of the last entries:
> 
> mysql> select ctime from perfdata_service_bin order by id desc limit 10;
> 
> Are these times correct?
> 
> PerfParse also uses your operating system date functions.  Please ensure
> that your operating system is set to your correct time zone.  This may
> be the problem.
> 
> Regards,
> 
> Ben
> 
> 
> Jordan Kirby wrote:
> 
>>Just realised I didn't do a reply to all, so the list didn't get
> 
> it.....
> 
>>
>>-----Original Message-----
>>From: Jordan Kirby
>>Sent: 02 November 2005 13:24
>>To: 'Ben Clewett'
>>Subject: RE: [Perfparse-users] Graph dates wrong
>>
>>Hi,
>>
>>We're running mysql 4.0.23. 
>>It looks like the timezone info is held in the variable "timezone"
>>(according to "show variables" anyway). I just can't change it, from 
>>what I can see it's a config file change required (it's a production 
>>mysql server so can't really do anything that'd require a restart).
>>Seeing as show variables reports GMT, and that's what I need it to be,
> 
> 
>>doesn't that indicate it's correct?
>>
>>Thanks
>>
>>Jordan
>>
>>-----Original Message-----
>>From: Ben Clewett [mailto:bcl...@pe...]
>>Sent: 02 November 2005 12:51
>>To: Jordan Kirby
>>Cc: per...@li...
>>Subject: Re: [Perfparse-users] Graph dates wrong
>>
>>I think this may be past of the problem.  MySQL seems confused as to 
>>what time zone it is in.
>>
>>Can you tell me what version you are using?
>>
>>With version 4.0 when upgraded to 4.1 (or greater), the timezone 
>>information is not included.  There is a program (somewhere) to 
>>generate the timezone tables and content.  I am sure there is a good 
>>page somewhere on:
>>
>>http://dev.mysql.com/doc/refman/5.0/en/index.html
>>
>>Regards,
>>
>>Ben
>>
>>
>>Jordan Kirby wrote:
>>
>>
>>>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 = '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 = 'posix/UTC'; SELECT NOW(); SET SET 
>>>mysql> time_zone = '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.....
>>>>
>>>>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&servic
>>>>>e
>>>>>=ht
>>>>>tp%3A%2F%2Fwww%2Erutland%2Egov%2Euk%2F&from=2005%2F10%2F01+00%3A00%3
>>>>>A
>>>>>01&
>>>>>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
>>>>
>>>
>>>
>>>
>>>
>>>-------------------------------------------------------
>>>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
>>>
>>>
>>>-------------------------------------------------------
>>>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
>>>
>>
>>
>>
>>
>>-------------------------------------------------------
>>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
>>
> 
> 
> 
> 
> -------------------------------------------------------
> 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
>