Menu
▾
▴
perfparse-users — Problems using PerfParse
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(12) |
Jun
(56) |
Jul
(68) |
Aug
(141) |
Sep
(82) |
Oct
(76) |
Nov
(115) |
Dec
(74) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(65) |
Feb
(113) |
Mar
(82) |
Apr
(37) |
May
(44) |
Jun
(22) |
Jul
(12) |
Aug
(3) |
Sep
(17) |
Oct
(11) |
Nov
(23) |
Dec
(1) |
| 2006 |
Jan
(1) |
Feb
(9) |
Mar
(6) |
Apr
(12) |
May
(10) |
Jun
(23) |
Jul
(1) |
Aug
(4) |
Sep
(3) |
Oct
(4) |
Nov
(6) |
Dec
(15) |
| 2007 |
Jan
(17) |
Feb
(14) |
Mar
(20) |
Apr
(7) |
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(5) |
Oct
(1) |
Nov
|
Dec
(2) |
| 2008 |
Jan
|
Feb
|
Mar
(2) |
Apr
(2) |
May
(6) |
Jun
(5) |
Jul
(13) |
Aug
(2) |
Sep
(16) |
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: barry m. <bar...@sh...> - 2005-11-02 14:44:32
|
I have been gathering stats over 700+ servers for 3-4 months and the database has grown to 75GB. I'm looking to tidy up the database and only have 1 month on-line. I know this should have been done at the start. When I try and run a script to delete entries before a date it does delete but very very slow. Any help on tuning the database would be great. Many Thanks Barry |
|
From: Ben C. <bcl...@pe...> - 2005-11-02 14:34:46
|
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 > |
|
From: Jordan K. <Jor...@ro...> - 2005-11-02 14:20:04
|
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 =20 -----Original Message----- From: Ben Clewett [mailto:bcl...@pe...]=20 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..... >=20 >=20 > -----Original Message----- > From: Jordan Kirby > Sent: 02 November 2005 13:24 > To: 'Ben Clewett' > Subject: RE: [Perfparse-users] Graph dates wrong >=20 > Hi, >=20 > We're running mysql 4.0.23.=20 > It looks like the timezone info is held in the variable "timezone" > (according to "show variables" anyway). I just can't change it, from=20 > what I can see it's a config file change required (it's a production=20 > 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? >=20 > Thanks >=20 > Jordan >=20 > -----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 >=20 > I think this may be past of the problem. MySQL seems confused as to=20 > what time zone it is in. >=20 > Can you tell me what version you are using? >=20 > With version 4.0 when upgraded to 4.1 (or greater), the timezone=20 > information is not included. There is a program (somewhere) to=20 > generate the timezone tables and content. I am sure there is a good=20 > page somewhere on: >=20 > http://dev.mysql.com/doc/refman/5.0/en/index.html >=20 > Regards, >=20 > Ben >=20 >=20 > Jordan Kirby wrote: >=20 >>Hi, >> >>The timezone is correctly set to GMT, and SELECT now(); returns the=20 >>correct date/time. >>I can't seem to set the timezone in mysql to anything different (if I=20 >>try "SET timezone =3D 'posix/UTC'; " I just get unknown system = variable, >=20 >=20 >>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=20 >>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=20 >>believe some of the figures are stored as UTC and converted to your >=20 > time zone on >=20 >> 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 >=20 > timezone. >=20 >>You can check this easily in MySQL: >> >>mysql> SELECT NOW(); >>mysql> SET SET time_zone =3D 'posix/UTC'; SELECT NOW(); SET SET=20 >>mysql> 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,=20 >>>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=3Dwebsites&servi= c >>>>e >>>>=3Dht >>>>tp%3A%2F%2Fwww%2Erutland%2Egov%2Euk%2F&from=3D2005%2F10%2F01+00%3A00%= 3 >>>>A >>>>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 >>>>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=20 >>>>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 >>>> >>>> >>> >>> >>> >>>------------------------------------------------------- >>>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 >>>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=20 >>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.=20 >>Download it for free - -and be entered to win a 42" plasma tv or your=20 >>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 >> >=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=20 > very own Sony(tm)PSP. Click here to play:=20 > http://sourceforge.net/geronimo.php > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users >=20 |
|
From: Ben C. <bcl...@pe...> - 2005-11-02 14:13:57
|
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&service >>>>=ht >>>>tp%3A%2F%2Fwww%2Erutland%2Egov%2Euk%2F&from=2005%2F10%2F01+00%3A00%3A >>>>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 > |
|
From: Jordan K. <Jor...@ro...> - 2005-11-02 13:27:18
|
Just realised I didn't do a reply to all, so the list didn't get it..... -----Original Message----- From: Jordan Kirby=20 Sent: 02 November 2005 13:24 To: 'Ben Clewett' Subject: RE: [Perfparse-users] Graph dates wrong Hi, We're running mysql 4.0.23.=20 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, >=20 > The timezone is correctly set to GMT, and SELECT now(); returns the=20 > correct date/time. > I can't seem to set the timezone in mysql to anything different (if I=20 > try "SET timezone =3D 'posix/UTC'; " I just get unknown system = variable, > the same with time_zone). >=20 > SHOW VARIABLES; reports the timezone as GMT. >=20 >=20 >=20 > Jordan >=20 >=20 >=20 > -----Original Message----- > From: per...@li... > [mailto:per...@li...] On Behalf Of Ben=20 > Clewett > Sent: 02 November 2005 08:27 > To: Jonnathan Colt > Cc: per...@li... > Subject: Re: [Perfparse-users] Graph dates wrong >=20 > Can you please check the time zone on your system is correct? I=20 > 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. >=20 > If not this may be a bug. >=20 > Check your UNIX installation on configuration to set your UNIX timezone. >=20 > You can check this easily in MySQL: >=20 > mysql> SELECT NOW(); > mysql> SET SET time_zone =3D 'posix/UTC'; SELECT NOW(); SET SET=20 > mysql> time_zone =3D 'America/Los_Angeles'; SELECT NOW(); >=20 > Do these return correct values? >=20 > Regards, >=20 > Ben Clewett. >=20 > Jonnathan Colt wrote: >=20 >>I have the same problem with graphs not showing the correct time, mine >=20 >=20 >>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=3Dwebsites&servic= e >>>=3Dht >>>tp%3A%2F%2Fwww%2Erutland%2Egov%2Euk%2F&from=3D2005%2F10%2F01+00%3A00%3= A >>>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 >=20 >=20 >>>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 >>> >> >> >> >>------------------------------------------------------- >>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 >=20 >=20 >=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=20 > 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 >=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=20 > 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 >=20 |
|
From: Ben C. <bcl...@pe...> - 2005-11-02 12:51:35
|
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'; > mysql> SELECT NOW(); > mysql> SET SET 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&service >>>=ht >>>tp%3A%2F%2Fwww%2Erutland%2Egov%2Euk%2F&from=2005%2F10%2F01+00%3A00%3A >>>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 > |
|
From: Jordan K. <Jor...@ro...> - 2005-11-02 12:27:49
|
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 |
|
From: Ben C. <bcl...@pe...> - 2005-11-02 08:26:55
|
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 > |
|
From: Jonnathan C. <jc...@di...> - 2005-11-01 17:38:47
|
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 > > |
|
From: Jordan K. <Jor...@ro...> - 2005-11-01 11:55:44
|
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=3D= ht tp%3A%2F%2Fwww%2Erutland%2Egov%2Euk%2F&from=3D2005%2F10%2F01+00%3A00%3A01= & to=3D2005%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 |
|
From: John C. <po...@ya...> - 2005-10-31 15:21:20
|
Hi gurus, On a new perfparse setup, it seems to be ALMOST working, but no data lines are plotted on the performance graphs. The perfparse summary table lists the hosts, services, last reading, and values. Click on a graph and perfparse generates a graph image (.png) which includes the hostname, service name, and metric. BUT, no data lines are drawn on the graph. I've waited a couple of days for data to be collected. Same behavior with different hosts and services. Same behavior when adjusting the scale, size, and time periods. Nagios 2.0b4 (./configure --with-command-group=nobody --enable-embedded-perl --with-perlcache --with-default-perfdata) Perfparse v0.105.6 Solaris 9 mysql-max-4.1.14-sun-solaris2.9-sparc-64bit.pkg (from Sunfreeware) I have confirmed the Nagios "Process Info" link shows "Performance Data Being Processed? Yes" I have confirmed performance data is being provided by the plugins. I have confirmed performance data is being stored in the database. (I don't know if it's all the right data in the right places, but the db is being populated with values that look reasonable to me.) My Nagios Status Map is drawn correctly so I assume(?) my gd-2.0.33, Freetype 2, zlib, jpeg, and libpng graphic libraries are installed properly. TIA for any direct solutions or hints on where to looks next! -John __________________________________ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs |
|
From: <nu...@ts...> - 2005-10-17 14:55:42
|
The mysql database was having problems for over a day. In the meantime,
Nagios was still executing and I received several messages in nagios.log
and messages. Can I add entries that are a few days old and not
compromise the database? Any other gotchas?
I was going to execute the following command that the log shows. See
example below:
** Message **
Oct 13 03:49:40 oma3l003 nagios: Warning: Service performance data command
'/usr/bin/printf "%b" "1129193374\toma3s023\tOS - Load Average\tOK - load
average: 1.25, 0.85, 0.73\tOK\tload1=1.253906;10.000000;30.000000;0.000000
load5=0.847656;10.000000;20.000000;0.000000
load15=0.726563;10.000000;15.000000;0.000000\n" |
/usr/local/nagios//bin/perfparse-log2mysql -c
/usr/local/nagios//etc/perfparse.cfg' for service 'OS - Load Average' on
host 'oma3s023' timed out after 5 seconds
** Command **
/usr/bin/printf "%b" "1129193374\toma3s023\tOS - Load Average\tOK - load
average: 1.25, 0.85, 0.73\tOK\tload1=1.253906;10.000000;30.000000;0.000000
load5=0.847656;10.000000;20.000000;0.000000
load15=0.726563;10.000000;15.000000;0.000000\n" |
/usr/local/nagios//bin/perfparse-log2mysql -c
/usr/local/nagios//etc/perfparse.cfg
Steve Nuffer
_________________________________________________________________________________________________
Transaction Systems Architects, Inc. 330 S.
108th Ave. Omaha, NE 68154-2684
This e-mail message and any attachments may contain confidential,
proprietary or non-public information. This information
is intended solely for the designated recipient(s). If an addressing or
transmission error has misdirected this e-mail, please
notify the sender immediately and destroy this e-mail. Any review,
dissemination, use or reliance upon this information by
unintended recipients is prohibited. Any opinions expressed in this
e-mail are those of the author personally. |
|
From: Glen K. <Gle...@dp...> - 2005-10-14 00:25:44
|
Sorry but the URL's were wrong in my previous post and I added a bit
more info, it should have read
>>> Glen Kelly 14/10/2005 10:58 am >>>
Whenever I try to view a graph I get the follow error reported in
Internet Explorer.
The URL for the page is
http://gabar/nagios/cgi-bin/perfparse.cgi?graph=1&&metric=%2Fvar
"Line: 7
Char: 3
Error: 'document.graph.timerange' is null or not an object
Code: 0
URL: http//gabar/nagios/cgi-bin/perfparse.cgi?graph=1&&metric=load1"
Not sure if that error is complete, unfortunately that is all of the
error I can see in the window.
The source of the page it is trying to display is
"<HTML>
<HEAD>
<TITLE>
PerfParse</TITLE>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
function isAbsRelVisible() {
if (document.graph.timerange[1].checked) showAbsolute();
else showRelative();
}
function showAbsolute() {
Abs1.style.visibility="visible";
Abs2.style.visibility="visible";
Abs3.style.visibility="visible";
Abs4.style.visibility="visible";
Rel1.style.visibility="hidden";
Rel2.style.visibility="hidden";
Rel3.style.visibility="hidden";
Rel4.style.visibility="hidden";
}
function showRelative() {
Abs1.style.visibility="hidden";
Abs2.style.visibility="hidden";
Abs3.style.visibility="hidden";
Abs4.style.visibility="hidden";
Rel1.style.visibility="visible";
Rel2.style.visibility="visible";
Rel3.style.visibility="visible";
Rel4.style.visibility="visible";
}
</SCRIPT>
<BODY BGcolor="#EEFFFF" TEXT="#000000" LINK="#000000" VLINK="#000000"
ALINK="#000000" onload="isAbsRelVisible()">
"
From playing around it does not seem to be correctly passing parameters
between scripts
i.e. It is generating URL's like this
http://gabar/nagios/cgi-bin/perfparse.cgi?graph=1&&metric=%2Fvar
or
http://gabar/nagios/cgi-bin/perfparse.cgi?select_metric=1&host_name=%2E
I am sure it is because
1 - we are using "." is the hostname i.e. gabar.pacit.tas.gov.au
2 - for plugin's like check_disk the binary data contains a "/"
character
i.e.
[root@gabar nrpe]# /usr/local/nagios/libexec/check_disk -w 10% -c 5% -p
/var
DISK OK - free space: /var 3491 MB (88%);| /var=475MB;3569;3767;0;3966
This is a URL that works (I made a host called test)
http://gabar/nagios/cgi-bin/perfparse.cgi?graph=1&host=test&service=CPULoad&metric=load1
if I change the URL for a host that does not work i.e.
http://gabar/nagios/cgi-bin/perfparse.cgi?graph=1&host=gabar.pacit.tas.gov.au&service=CPULoad&metric=load1
then this works as well, as does this
http://gabar/nagios/cgi-bin/perfparse.cgi?graph=1&host=test&service=disk_var&metric=/var
Perfparse does not seem to be able to generate URL's containing a "."
or a "/" character.
Any ideas on how to fix?
Just about to try altering the illegal characters in perfparse.cfg to
see if that helps.
Glen
|
|
From: Glen K. <Gle...@dp...> - 2005-10-13 23:59:45
|
Whenever I try to view a graph I get the follow error reported in
Internet Explorer.
The URL for the page is
http://gabar/nagios/cgi-bin/perfparse.cgi?graph=1&host=test&service=%5F&metric=%2Fvar
"Line: 7
Char: 3
Error: 'document.graph.timerange' is null or not an object
Code: 0
URL: http//gabar/nagios/cgi-bin/perfparse.cgi?graph=1&&metric=load1"
Not sure if that error is complete, unfortunately that is all of the
error I can see in the window.
The source of the page it is trying to display is
"<HTML>
<HEAD>
<TITLE>
PerfParse</TITLE>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
function isAbsRelVisible() {
if (document.graph.timerange[1].checked) showAbsolute();
else showRelative();
}
function showAbsolute() {
Abs1.style.visibility="visible";
Abs2.style.visibility="visible";
Abs3.style.visibility="visible";
Abs4.style.visibility="visible";
Rel1.style.visibility="hidden";
Rel2.style.visibility="hidden";
Rel3.style.visibility="hidden";
Rel4.style.visibility="hidden";
}
function showRelative() {
Abs1.style.visibility="hidden";
Abs2.style.visibility="hidden";
Abs3.style.visibility="hidden";
Abs4.style.visibility="hidden";
Rel1.style.visibility="visible";
Rel2.style.visibility="visible";
Rel3.style.visibility="visible";
Rel4.style.visibility="visible";
}
</SCRIPT>
<BODY BGcolor="#EEFFFF" TEXT="#000000" LINK="#000000" VLINK="#000000"
ALINK="#000000" onload="isAbsRelVisible()">
"
From playing around it does not seem to be correctly passing parameters
between scripts
i.e. It is generating URL's like this
http://gabar/nagios/cgi-bin/perfparse.cgi?graph=1&host=test&service=%5F&metric=%2Fvar
I am sure it is because
1 - we are using "." is the hostname i.e. gabar.pacit.tas.gov.au
2 - for plugin's like check_disk the binary data contains a "/"
character
i.e.
[root@gabar nrpe]# /usr/local/nagios/libexec/check_disk -w 10% -c 5% -p
/var
DISK OK - free space: /var 3491 MB (88%);| /var=475MB;3569;3767;0;3966
Any ideas on how to fix?
Just about to try altering the illegal characters in perfparse.cfg to
see if that helps.
Glen
|
|
From: Glen K. <Gle...@dp...> - 2005-10-13 21:10:14
|
Hi Just wanted to say that Pavol's instructions worked and perfparse is now working. Regards Glen |
|
From: Pavol L. <pavol.luptak@i.cz> - 2005-10-13 11:17:13
|
Hello, I need to merge two perfparse databases. Each of them has the same structure and represents different time period. I've tried to merge two MySQL dumps, but there are a lot of duplications (maybe I should try to replace INSERT to UPDATE). I didn't find any tool or method how to do it. Do you have some experience with merging two perfparse databases? If yes, can you describe it? Thanks a lot. Cheers, Pavol -- ___________________________________________________________________ [Pavol Luptak, ICZ a.s.] [Pavol.Luptak@i.cz] [tel: +420(2)44100726] |
|
From: Yves <yme...@pe...> - 2005-10-13 08:12:52
|
Hello, As far as I remember, Perfparse creates the pipe itself. I don't remember any problem if you create it yourself, but put the corre= ct permissions (I don't remember what they are) I also remember that you have to start Nagios AFTER Perfparse because if = Nagios starts first, it can create the file as a regular file instead of a pipe. Then P= erfparse is confused. This is what I remember about it after 10 months far from Perfparse (too = many things else to do) I hope that Pavol Luptak's answer also helps. Yves > Hi > > I have read all the doco I have found about install PerfParse but am > unable to get it to work using the pipe method on Red Hat Linux. > > I am using the perfparse_nagios_pipe_command.pl as I not sure about how > to use the Nagios 2.0b4 pipe capability. > > However I can't get it to work, it seems like the > perfparse_nagios_pipe_command.pl cannot place data onto the pipe, when = I > try to run the perfparse_nagios_pipe_command.pl command manually with > the appropriate arguements the script just hangs. > > By the way I create the pipe file manually using the mkfifo command and > it appears to have the correct ownership and permissions. > > Any ideas? > > Is there a comprehensive install doco of installing PerfParse on Nagios > 2? > > Glen > --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://www.perfparse.org/ - |
|
From: Pavol L. <pavol.luptak@i.cz> - 2005-10-12 23:23:16
|
Hello,
I use Nagios 2.0b4 with perfparse through a pipe without any problem.
Use the following configuration:
1. Nagios 2.0b4
..
..
process_performance_data=1
host_perfdata_command=process-host-perfdata
service_perfdata_command=process-service-perfdata
define command{
command_name process-service-perfdata
command_line
/usr/local/nagios/bin/perfparse_nagios_pipe_command.pl /
usr/local/nagios/var/perfdata-service.pipe "$TIMET$" "$HOSTNAME$"
"$SERVICEDESC$" "$SERVICEOUTPUT$" "$SERVICESTATE$" "$SERVICEPERFDATA$"
}
define command{
command_name process-host-perfdata
command_line
/usr/local/nagios/bin/perfparse_nagios_pipe_command.pl /
usr/local/nagios/var/perfdata-host.pipe "$TIMET$" "$HOSTNAME$"
"$HOSTOUTPUT$" "$HOSTPERFDATA$"
}
..
..
2. # cat perfparse.cfg
Server_Port = 1976
Service_Log = "|/usr/local/nagios/var/perfdata-service.pipe"
Service_Log_Position_Mark_Path = "/usr/local/nagios/var"
Error_Log = "/usr/local/nagios/var/perfparse.log"
Error_Log_Rotate = "Yes"
Error_Log_Keep_N_Days = "7"
Drop_File = "/tmp/perfparse.drop"
Drop_File_Rotate = "Yes"
Drop_File_Keep_N_Days = "7"
Lock_File = "/var/lock/perfparse.lock"
Show_Status_Bar = "no"
Do_Report = "no"
Default_user_permissions_Policy = "rw"
Default_user_permissions_Host_groups = "rw"
Default_user_permissions_Summary = "rw"
Output_Log_File = "no"
Output_Log_Filename =
"/usr/local/nagios/var/perfparse_output_log"
Output_Log_Rotate = "yes"
Output_Log_Keep_N_Days = "7"
Use_Storage_Socket_Output = "no"
Storage_Socket_Output_Host_Name = "localhost"
Storage_Socket_Output_Port = "1974"
Storage_Modules_Dir = "/usr/local/nagios/lib"
Storage_Modules_Load = "mysql"
Server_Port = "1976"
Use_Storage_Mysql = "yes"
No_Raw_Data = "no"
No_Bin_Data = "no"
DB_User = "nagios"
DB_Name = "user"
DB_Pass = "name"
DB_Host = "localhost"
Dummy_Hostname = "dummy"
3. # cat /usr/local/nagios/bin/perfparse_nagios_pipe_command.pl
#! /usr/bin/perl -w
use strict;
my $file = shift @ARGV;
open FH, ">$file" or die "'$file' could not be opened for appending\n";
print FH join("\t", @ARGV);
print FH "\n";
close FH;
system ('/usr/local/nagios/bin/perfparse-log2mysql --serviceperf-log
/usr/local/nagios/var/perfdata-service.pipe');
----
And it will certainly work!
Cheers,
Pavol
Glen Kelly wrote:
> Hi
>
> I have read all the doco I have found about install PerfParse but am
> unable to get it to work using the pipe method on Red Hat Linux.
>
> I am using the perfparse_nagios_pipe_command.pl as I not sure about how
> to use the Nagios 2.0b4 pipe capability.
>
> However I can't get it to work, it seems like the
> perfparse_nagios_pipe_command.pl cannot place data onto the pipe, when I
> try to run the perfparse_nagios_pipe_command.pl command manually with
> the appropriate arguements the script just hangs.
>
> By the way I create the pipe file manually using the mkfifo command and
> it appears to have the correct ownership and permissions.
>
> Any ideas?
>
> Is there a comprehensive install doco of installing PerfParse on Nagios 2?
>
> Glen
--
___________________________________________________________________
[Pavol Luptak, ICZ a.s.] [Pavol.Luptak@i.cz] [tel: +420(2)44100726]
|
|
From: Glen K. <Gle...@dp...> - 2005-10-12 22:41:29
|
Hi I have read all the doco I have found about install PerfParse but am unable to get it to work using the pipe method on Red Hat Linux. I am using the perfparse_nagios_pipe_command.pl as I not sure about how to use the Nagios 2.0b4 pipe capability. However I can't get it to work, it seems like the perfparse_nagios_pipe_command.pl cannot place data onto the pipe, when I try to run the perfparse_nagios_pipe_command.pl command manually with the appropriate arguements the script just hangs. By the way I create the pipe file manually using the mkfifo command and it appears to have the correct ownership and permissions. Any ideas? Is there a comprehensive install doco of installing PerfParse on Nagios 2? Glen |
|
From: Brandon S. <bra...@wy...> - 2005-10-05 17:01:12
|
Is it possible to run perfparse with mysql3? I'm loading it up on a server that I can only run MySQL3 on due to being locked into that database version from another piece of vendor's software. What are my options for using perfparse so I can get it integrated with Nagios? Thanks, BrandonS |
|
From: Brandon S. <bra...@wy...> - 2005-10-05 16:58:58
|
Is it possible to run perfparse with mysql3? I'm loading it up on a server that I can only run MySQL3 on due to being locked into that database version from another piece of vendor's software. What are my options for using perfparse so I can get it integrated with Nagios? Thanks, BrandonS |
|
From: Garrett H. <gh...@3g...> - 2005-09-30 00:05:18
|
Does the service you are monitoring return performance data? -g On Thu, 2005-09-29 at 16:37 -0700, Jonnathan Colt wrote: > Good news and bad news. I am seeing graphed data. However, its only > from one machine being monitored. Any ideas why the others wouldnt > work? Also I have no graphs showing in the RAW Plugin when I choose > "generate report" after picking a service. It shows a broken image. > Obviously the GD is working because I can see graphs for one host/all > services on that host. I have no idea at this point what I am doing > wrong. > > Thanks for *any* input, > > Jon > > > On Wed, 2005-09-28 at 16:00 -0500, Garrett Honeycutt wrote: > > On Wed, 2005-09-28 at 13:53 -0700, Jonnathan Colt wrote: > > > I will try recompling. A bit of fooling around has given some more > > > information. When I goto "Graph Binary Data" and click on a machine > > > that monitors disk space. Then click on the volume that its monitoring. > > > I do get a graph. But the graph is empty. I looked at the raw data and > > > it only has 2 samples of data. Point of me saying this is that I > > > believe that the GD is working if its able to show this graph...or am I > > > wrong? Also is it not showing anything on the graph because it only has > > > 2 sample thus far? > > > > > > Thanks for any input, you have been TONS of help...I will have to send > > > you a Starbucks gift card or something... > > > > > > Jon > > > > > > On Wed, 2005-09-28 at 15:36 -0500, Garrett Honeycutt wrote: > > > > did you just now install it or was it installed before you compiled > > > > perfparse? if you just now did it, then you will need to recompile > > > > perfparse. > > > > > > > > in fact, recompiling perfparse can't hurt :) > > > > > > > sounds like everything is working fine.. take a break and come back to > > it tomorrow and check out your graphs :) > > > > -g > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: > Power Architecture Resource Center: Free content, downloads, discussions, > and more. http://solutions.newsforge.com/ibmarch.tmpl > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users -- // Garrett Honeycutt // Sr. Systems Administrator // 3GUpload.com, Inc. // 317.472.4969 Office |
|
From: Jonnathan C. <jc...@di...> - 2005-09-29 23:34:36
|
Good news and bad news. I am seeing graphed data. However, its only from one machine being monitored. Any ideas why the others wouldnt work? Also I have no graphs showing in the RAW Plugin when I choose "generate report" after picking a service. It shows a broken image. Obviously the GD is working because I can see graphs for one host/all services on that host. I have no idea at this point what I am doing wrong. Thanks for *any* input, Jon On Wed, 2005-09-28 at 16:00 -0500, Garrett Honeycutt wrote: > On Wed, 2005-09-28 at 13:53 -0700, Jonnathan Colt wrote: > > I will try recompling. A bit of fooling around has given some more > > information. When I goto "Graph Binary Data" and click on a machine > > that monitors disk space. Then click on the volume that its monitoring. > > I do get a graph. But the graph is empty. I looked at the raw data and > > it only has 2 samples of data. Point of me saying this is that I > > believe that the GD is working if its able to show this graph...or am I > > wrong? Also is it not showing anything on the graph because it only has > > 2 sample thus far? > > > > Thanks for any input, you have been TONS of help...I will have to send > > you a Starbucks gift card or something... > > > > Jon > > > > On Wed, 2005-09-28 at 15:36 -0500, Garrett Honeycutt wrote: > > > did you just now install it or was it installed before you compiled > > > perfparse? if you just now did it, then you will need to recompile > > > perfparse. > > > > > > in fact, recompiling perfparse can't hurt :) > > > > sounds like everything is working fine.. take a break and come back to > it tomorrow and check out your graphs :) > > -g |
|
From: Garrett H. <gh...@3g...> - 2005-09-28 20:23:39
|
On Wed, 2005-09-28 at 12:30 -0700, Jonnathan Colt wrote: > Garrett, > > I am sure I am quite annoying....if I am coming across like that, my > apologizes. I finally have data coming into Perfparse. How long did it > take before you were able to see graphs? For example, I click on, "View > Raw Plugin Data" -- and I can see my services that I am monitoring. > Then if I click "all" -- I can see that <host> was pinged 7 times > sucessfully in the last 30 minutes. But at the bottom its showing a > broken image. Should a graph be showing there? Also if I return to the > main menu and click on "View and Graph Binary Data" -- I get a list of > <hosts> that have things checked like disk space and such. But when I > click on the graph icon, I get a blank page. I started to wonder if it > just takes time for data to populate the database? > > I ended up reverting back to 1.2 from 2.0b4 and followed your config > files in order to get it working late last night. > > Thanks again for any input, > > Jon You should not see a broken image. You should see an image with little to no visible data on it since you just started polling. Make sure you have GD installed. If you are running a RedHat based system make sure you both the gd and gd-devel packages. But if data is populating then you are on the right track. Go back to your perfparse source directory and run ./configure with the same args as last time and pay close attention to the output and make sure you aren't getting any errors, especially with GD. -g -- // Garrett Honeycutt // Sr. Systems Administrator // 3GUpload.com, Inc. // 317.472.4969 Office |
|
From: Jonnathan C. <jc...@di...> - 2005-09-28 19:26:50
|
Garrett, I am sure I am quite annoying....if I am coming across like that, my apologizes. I finally have data coming into Perfparse. How long did it take before you were able to see graphs? For example, I click on, "View Raw Plugin Data" -- and I can see my services that I am monitoring. Then if I click "all" -- I can see that <host> was pinged 7 times sucessfully in the last 30 minutes. But at the bottom its showing a broken image. Should a graph be showing there? Also if I return to the main menu and click on "View and Graph Binary Data" -- I get a list of <hosts> that have things checked like disk space and such. But when I click on the graph icon, I get a blank page. I started to wonder if it just takes time for data to populate the database? I ended up reverting back to 1.2 from 2.0b4 and followed your config files in order to get it working late last night. Thanks again for any input, Jon On Tue, 2005-09-27 at 15:58 -0500, Garrett Honeycutt wrote: > On Tue, 2005-09-27 at 11:35 -0700, Jonnathan Colt wrote: > > Are you running Nagios 2.0b4? > > > > Jon > > No, I am running the 1.2 branch. > > -g |
34 messages has been excluded from this view by a project administrator.
