perfparse-users — Problems using PerfParse

RE: [Perfparse-users] re: deletion policys

[James O. <jo...@re...>]

The table was empty prior to this:

mysql> insert into perfdata_delete_policy ( 'Always' , '90' ) ;
ERROR 1064: You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use near
''Always' , '90' )' at line 1
mysql> insert into perfdata_delete_policy values ( 'Always' , '90' ) ;
Query OK, 1 row affected (0.12 sec)

mysql> insert into perfdata_delete_policy values ( 'Bin Default' , '90' ) ;
Query OK, 1 row affected (0.57 sec)

mysql> select * from perfdata_delete_policy
    -> ;
+-------------+---------------+
| policy_name | delete_policy |
+-------------+---------------+
| Always      |            90 |
| Bin Default |            90 |
+-------------+---------------+
2 rows in set (0.00 sec)

mysql> quit
Bye

And now I get:

[root@mon-01 bin]# ./perfparse-db-tool --reset_host_delete_policy mon-01
"UPDATE perfdata_host SET raw_delete_policy_type = 'template',
bin_delete_policy_type = 'template', raw_delete_policy_name = 'Raw Default',
bin_delete_policy_name = 'Bin Default' WHERE host_name = 'mon-01'" failed:
Cannot add or update a child row: a foreign key constraint fails
[root@mon-01 bin]# ./perfparse-db-purge -r
"UPDATE perfdata_service SET raw_delete_policy_name = 'Raw Default' WHERE
raw_delete_policy_type = 'template' AND raw_delete_policy_name IS NULL"
failed:
Cannot add or update a child row: a foreign key constraint fails
[root@mon-01 bin]#

-----Original Message-----
From: Ben Clewett [mailto:Be...@cl...] 
Sent: Friday, August 27, 2004 12:33 AM
To: James Ochs; 'per...@li...'
Subject: Re: [Perfparse-users] re: deletion policys

James,

I need some information from your MySQL.  Can you start the MySQL shell 
(mysql -u nagios -pnagios -D nagios) and enter:

mysql> select * from perfdata_delete_policy;

This should produce at least this:

+-------------+---------------+
| policy_name | delete_policy |
+-------------+---------------+
| Always      |            30 |
| Bin Default |            30 |
+-------------+---------------+

Which will have different values in the second column.

Let me know and we can go from there.

Ben



James Ochs wrote:

> I'm still having this issue.  Does anyone know what the foreign key that 
> it is referring to is?  Or how to find out?   Here's the latest output:
> 
> 
> 
> [jochs@mon-01 bin]$
> [jochs@mon-01 bin]$ ./perfparse-db-tool --update
> [jochs@mon-01 bin]$ ./perfparse-db-purge -r
> "UPDATE perfdata_service_metric SET bin_delete_policy_name = 'Bin 
> Default' WHERE bin_delete_policy_type = 'template' AND 
> bin_delete_policy_name IS NULL" failed:
> 
> Cannot add or update a child row: a foreign key constraint fails
> [jochs@mon-01 bin]$ ./perfparse-db-purge --show_config
> DB_User =        "nagios"
> DB_Name =        "nagios"
> DB_Pass =        "n4g10s"
> DB_Host =        "127.0.0.1"
> Drop_File =      "/tmp/perfparse.drop"
> Service_Log =    "/usr/local/nagios/var/serviceperf.log"
> Host_Log =       "/usr/local/nagios/var/hostperf.log"
> Dummy_Hostname = "dummy"
> Delete_Service_Log =         "No"
> Delete_Host_Log =            "No"
> Nagios_Lock =    "/usr/local/nagios/var/nagios.lock"
> Lock_File =      "/var/lock/perfparse.lock"
> Be_Silent =      "no"
> Do_Report =      "no"
> Accept_Odd_Chars_in_Label =      "no"
> Default_user_permissions_Policy = "rw"
> Default_user_permissions_Host_groups = "rw"
> [jochs@mon-01 bin]$
> 
> -----Original Message-----
> From: Tim Brazil [mailto:br...@se...]
> Sent: Wednesday, August 25, 2004 2:43 PM
> To: James Ochs
> Cc: per...@li...
> Subject: Re: [Perfparse-users] re: deletion policys
> 
> Hi James
> 
> The only other thing I did was changed to the newer sample version
> perfparse.cfg.
> 
> Here are some thoughts...
> Did you see any "upgrade" output from ./perfparse-db-tool --update when
> you ran it indicating something actually happened?
> Is the binary from  perfparse-db-tool the new one that was built with
> 0.99.09.
> I initially didn't "configure" correctly which "make install"ed
> perfparse-db-tool  to the wrong directory (/usr/local/bin) which left
> the older version of perfparse-db-tool  in place under 
> /usr/local/nagios/bin
> 
> Tim
> 
> James Ochs wrote:
> 
>  > Upgrading to 0.99.09 didn't fix this problem for me.  Nor did running
>  > perfparse-db-tool --update.
>  >
>  > James
>  >
>  > -----Original Message-----
>  > From: Tim Brazil [mailto:br...@se...]
>  > Sent: Wednesday, August 25, 2004 1:39 PM
>  > Cc: per...@li...
>  > Subject: Re: [Perfparse-users] re: deletion policys
>  >
>  > Thanks Garry
>  > I updated to 0.99.09, ran ./perfparse-db-tool --update and it fixed my
>  > problem.
>  >
>  > Tim
>  >
>  > Cook, Garry wrote:
>  >
>  > >per...@li... wrote:
>  > >
>  > >
>  > >>I have been watching this post becasue I too am experiencing this
>  > >>problem.  It's been about 1 month since I've started collection
>  > >>performance statistics and I'd like to do some cleanup. I
>  > >>cannot create
>  > >>deletion policies due to the "Cannot add or update a child row: a
>  > >>foreign key constraint fails"  error.
>  > >>Any ideas on how to rectify this. I also ran the ./perfparse-db-tool
>  > >>--update to see whether it would correct the problem. It
>  > >>didn't change
>  > >>anything. I have Version 0.99.05. Schema Version 0.12
>  > >>
>  > >>Thanks in advance
>  > >>Tim
>  > >>  
>  > >>
>  > >
>  > >I believe that this bug was fixed in Version 0.99.08, but it might
have
>  > >been 0.99.09. Either way, you should definitely be using the latest
>  > >stable version -> 0.99.09.
>  > >I thought that I saw someone else post about this issue and say that 
> the
>  > >version upgrade did not fix it for them. However, they did not mention
>  > >if they ran 'perfparse-db-tool --update' after upgrading PerfParse.
>  > >
>  > >Everyone needs to realize something very important:
>  > >With new versions, there are changes to the PerfParse code and there 
> are
>  > >sometimes changes made to the MySQL DB as well. You need to use the
>  > >perfparse-db-tool to update your DB with each upgrade. This tool 
> will be
>  > >installed in your '<path_to>/nagios/bin/' directory, run it with the
>  > >'--update' argument to ensure that DB changes are made properly.
>  > >
>  > >Garry W. Cook, CCNA
>  > >Network Infrastructure Manager
>  > >MACTEC, Inc. - http://www.mactec.com/
>  > >303.308.6228 (Office) - 720.220.1862 (Mobile)
>  > >
>  > >
>  > >-------------------------------------------------------
>  > >SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>  > >100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>  > >Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>  > >http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>  > >_______________________________________________
>  > >Perfparse-users mailing list
>  > >Per...@li...
>  > >https://lists.sourceforge.net/lists/listinfo/perfparse-users
>  > >
>  > >
>  >
>  >
>  >
>  > -------------------------------------------------------
>  > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>  > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>  > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>  > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>  > _______________________________________________
>  > Perfparse-users mailing list
>  > Per...@li...
>  > https://lists.sourceforge.net/lists/listinfo/perfparse-users
>  >
> 

RE: [Perfparse-users] check_nt 1.24 doesn't see format strings w hen using COUNTER

[Ferrill, J. <jam...@NE...>]

Thanks Paulo, that worked perfectly.

-----Original Message-----
From: Paulo Afonso Graner Fessel [mailto:pau...@pr...]
Sent: Friday, August 27, 2004 9:11 AM
To: Ferrill, James; per...@li...
Subject: RES: [Possible SPAM] - [Perfparse-users] check_nt 1.24 doesn't
see format strings when using COUNTER - Found word(s) inkjet cartridges
in the Text body


James,

Read my answers below.

Paulo Afonso Graner Fessel
Administrador de Ambiente e Sistemas UNIX
pau...@pr...
OWT
Fone: +55 (11) 3038-6464
Fax: +55 (11) 3038-6508
http://www.primesys.com.br
 


> -----Mensagem original-----
> De: per...@li... 
> [mailto:per...@li...] Em nome 
> de Ferrill, James
> Enviada em: quinta-feira, 26 de agosto de 2004 22:02
> Para: per...@li...
> Assunto: [Possible SPAM] - [Perfparse-users] check_nt 1.24 
> doesn't see format strings when using COUNTER - Found word(s) 
> inkjet cartridges in the Text body
> 
> > I've been trying to collect some counter data and it 
> doesn't seem to 
> > work quite right using the latest check_nt from CVS (1.24):
> > 
> > nexismdev04:/usr/local/nagios/libexec# ./check_nt -H 
> 172.29.19.28 -p 
> > 1248 -v COUNTER -l "\\Memory\\Available Bytes"
> > 270553088
> > 
> > nexismdev04:/usr/local/nagios/libexec# ./check_nt -H 
> 172.29.19.28 -p 
> > 1248 -v COUNTER -l "\\Memory\\Available Bytes","Free memory"
> > No unit counter specified
> > 
> > nexismdev04:/usr/local/nagios/libexec# ./check_nt -H 
> 172.29.19.28 -p 
> > 1248 -v COUNTER -l "\\Memory\\Available Bytes","Free memory %.2f"
> > Free memory %.2f = 271278080.00 %|'Free memory 
> > %.2f'=271278080.000000%;0.000000;;
> > 
> > nexismdev04:/usr/local/nagios/libexec# ./check_nt -H 
> 172.29.19.28 -p 
> > 1248 -v COUNTER -l "\\Paging File(_Total)\\%% Usage","%.f 
> %% paging file used."
> > %.f %% paging file used. = 0.00 %|'%.f %% paging file 
> > used.'=0.000000%;0.000000;;
> > 
> > Is this a bug or am I doing it wrong?

Well, I've modified check_nt to show performance data with maximum,
minimum and warning/critical thresholds. With these changes, the
functionality of specifying the formatting string at the output has
really been scrapped. This happened because the description field should
exist for PerfParse in order to be graphed - and using the description
field already provided for check_nt in CHECK_COUNTER seemed to be the
most sensible idea.

On the other hand, I couldn't include the formatting field as perfdata
information is processed by specific functions (perfdata and fperfdata
in plugins/utils.c) where a formatting string can't be used to inform
data. So, I thought like Bill Gates and concluded that "two decimal
places should be sufficient for anybody". If someone has a better
solution, please submit to nagios-plugin-devel list.

Until then, you should invoke the plugin like this:

[root@nagioslab plugins]#./check_nt -H 10.4.8.210 -v COUNTER -l
"\\Paging File(_Total)\\% Usage","Total Paging File Usage"
Total Paging File Usage = 12.50 %|'Total Paging File
Usage'=12.503050%;0.000000;0.000000;
[root@nagioslab plugins]# ./check_nt -H 10.4.8.210 -v COUNTER -l
"\\Memory\\Available Bytes","Free memory","Bytes"
Free memory = 135479296.00 Bytes|'Free
memory'=135479296.000000Bytes;0.000000;0.000000;

[]'s
Paulo

RE: [Perfparse-users] new to perfmon

[Cook, G. <GW...@ma...>]

per...@li... wrote:
> Hello
> I'm having a small problem with perfmon
> I've followed the instructions on
> http://perfparse.sourceforge.net/docs.php
> to the letter...
>=20
> I've set up the crontab job as:
> # Run PerfParse every 15 minutes to update Nagios graphs.
> 15 * * * * /usr/local/nagios/bin/perfparse.sh

So far, so good.


> but all I get is the following and no data is building upp in the DB.
> why ? what ? why????=20
>=20
> [nagios@black148 nagios]$ /usr/local/nagios/bin/perfparse.sh
> /usr/local/nagios/bin/perfparse:
> Please use --delete-service-log instead of --delete

I think there is still an error (bug) in the perfparse.sh file.
Hopefully this will be fixed in the next version (Ben?). Please edit
perfparse.sh and change --delete to --delete-service-log. Alternatively,
you could just remove the '--delete' option altogether, and PerfParse
should use what you've set in perfparse.cfg.


> Usage:
> /usr/local/nagios/bin/perfparse [[-U | --user] user] [[-P |
> --password] password]
>         [[-D | --database] database] [-H database_host]
>         [[-c | --config-file] config_file_name] [-n no_of_lines] [-s]
>         [-l logfile] [-n no_of_lines] [-s]
>         [--serviceperf-log logfile] [--delete-service-log]
>         [--host-log logfile] [--delete-host-log]
>         [-r | --report] [--no-raw] [--del-old n]
>         [-v | --version] [-h | --help]
>=20
>         -U -P -D -H   Database Parameters.
>         -l                     Short option for --serviceperf-log
>         --serviceperf-log      Location of the serviceperf.log file.
>         --host-log             Location of the serviceperf.log file.
>         --delete-service-log   Truncate log file to zero
> length on exit.
>         --delete-host-log      Truncate log file to zero
> length on exit.
>                       ** Need the location of nagios.lock in
> the config
> file **
>         -n            Parse only n lines, then stop.
>         --no-raw      Do not log the raw data.  Not used by perfparse.
>                       This containes the original message from plugin.
>         --del-old n   Delete data from database more than n days old.
>         -s            Silent.  Do not display progress.
>         -r --report   Displays a report of activity on exit.
>=20
>         -v --version  Print version and exit.
>         -h --help     Print this help exit.
>=20
> Using default configuration file
> '//usr/local/nagios/etc/perfparse.cfg'
> /usr/local/nagios/bin/perfparse --show_config  Show the configuration

Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)

[Perfparse-users] new to perfmon

[Arnar T. <ar...@ca...>]

Hello
I'm having a small problem with perfmon
I've followed the instructions on
http://perfparse.sourceforge.net/docs.php
to the letter...

I've set up the crontab job as:
# Run PerfParse every 15 minutes to update Nagios graphs.
15 * * * * /usr/local/nagios/bin/perfparse.sh


but all I get is the following and no data is building upp in the DB.
why ? what ? why????

[nagios@black148 nagios]$ /usr/local/nagios/bin/perfparse.sh
/usr/local/nagios/bin/perfparse:
Please use --delete-service-log instead of --delete
Usage:
/usr/local/nagios/bin/perfparse [[-U | --user] user] [[-P | --password]
password]
        [[-D | --database] database] [-H database_host]
        [[-c | --config-file] config_file_name] [-n no_of_lines] [-s]
        [-l logfile] [-n no_of_lines] [-s]
        [--serviceperf-log logfile] [--delete-service-log]
        [--host-log logfile] [--delete-host-log]
        [-r | --report] [--no-raw] [--del-old n]
        [-v | --version] [-h | --help]

        -U -P -D -H   Database Parameters.
        -l                     Short option for --serviceperf-log
        --serviceperf-log      Location of the serviceperf.log file.
        --host-log             Location of the serviceperf.log file.
        --delete-service-log   Truncate log file to zero length on exit.
        --delete-host-log      Truncate log file to zero length on exit.
                      ** Need the location of nagios.lock in the config
file **
        -n            Parse only n lines, then stop.
        --no-raw      Do not log the raw data.  Not used by perfparse.
                      This containes the original message from plugin.
        --del-old n   Delete data from database more than n days old.
        -s            Silent.  Do not display progress.
        -r --report   Displays a report of activity on exit.

        -v --version  Print version and exit.
        -h --help     Print this help exit.

Using default configuration file '//usr/local/nagios/etc/perfparse.cfg'
/usr/local/nagios/bin/perfparse --show_config  Show the configuration

--=20
Kve=C3=B0ja
Arnar =C3=9E=C3=B3rarinsson

T=C3=B6lvunarfr=C3=A6=C3=B0ingur
Kerfisdeild
S=C3=ADmi : 569 4289
----------------------
Flugm=C3=A1lastj=C3=B3rn =C3=8Dslands
Reykjav=C3=ADkurflugv=C3=B6llur
121 Reykjav=C3=ADk
http://www.caa.is
----------------------

RE: [Perfparse-users] Cannot run db-tool update [was: nagios restarting]

[Wilson P. J. <wp....@te...>]

Ben,

I've used the correct prefix. Now, I've deleted the program and done the
complete recompile. The program was regenerated:

[root@genesis bin]# ./configure --prefix=/usr/local/nagios
--with-imagedir=/usr/local/nagios/share/images/ --with-cgidir
=/usr/local/nagios/sbin --with-http_image_path=/nagios/images

-rwxr-xr-x    1 root     root       253547 Aug 27 11:25 perfparse-db-tool

but the problem persisted, it looks for the cfg file the wrong place:

[root@genesis bin]# ./perfparse-db-tool --update
Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"

So, I've copied perfparse.cfg to /usr/local/etc and the update was
successfully performed. 

Thanks for the help. But I'm still curious about the program checking the
cfg file into the wrong path...

Regards,

Wilson


> -----Original Message-----
> From: Ben Clewett [mailto:Be...@cl...]
> Sent: sexta-feira, 27 de agosto de 2004 11:18
> To: Wilson Pires Jr
> Cc: per...@li...
> Subject: Re: [Perfparse-users] Cannot run db-tool update [was: nagios
> restarting]
> 
> I note the error is:
> 
> Error, can't open configuration file: "//usr/local/etc/perfparse.cfg"
> 
> The file you are after is:
> 
> /usr/local/nagios/etc/perfparse.cfg
> 
> Are you are configuring using: --prefix=/usr/local/nagios ??
> 
> This should work. :(
> 
> Can you try deleting the program 'perfparse-db-tool' and doing a
> complete recompile, as stated in the README?
> 
> Does this regenerate this program?   If you run it, does it work?
> 
> Ben
> 
> 
> 
> 
> 
> 
> 
> Wilson Pires Jr wrote:
> 
> >>Remember as well that by default PP will install the file:
> >>/usr/local/nagios/etc/perfparse.cfg.example
> >>You need to rename this:
> >>/usr/local/nagios/etc/perfparse.cfg
> >>And add your own settings.
> >>Ben.
> >>
> >
> >
> > [Wilson Pires Jr]
> > I've recompiled and reinstalled, as suggested by Paulo, and renamed and
> set
> > perfparse.cfg.example and perfparse.sh.example. But the problem remains.
> I
> > can't run the db update:
> >
> > [root@genesis bin]# ./perfparse-db-tool --update
> > Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"
> >
> > The files perfparse-db-tool and perfparse.cfg are owned by root, and
> > perfparse.sh is owned by nagios. Is this correct?
> >
> > /usr/local/nagios/bin
> > -rwxr-xr-x    1 root     root       250813 Aug 27 10:24 perfparse
> > -rwxr-xr-x    1 root     root         1661 Jul 28 10:42
> perfparse_daemon.sh
> > -rwxr-xr-x    1 root     root       262873 Aug 27 10:24 perfparse-db-
> purge
> > -rwxr-xr-x    1 root     root       253547 Aug 27 10:24 perfparse-db-
> tool
> > -rwxr-xr-x    1 nagios   nagios     252518 Jul 19 16:59 perfparse-
> install-db
> > -rwxr-xr-x    1 nagios   nagios     259533 Jul 19 16:59 perfparse-purge-
> db
> > -rwxr-xr-x    1 nagios   nagios       1326 Aug 27 10:32 perfparse.sh
> >
> > /usr/local/nagios/etc
> > [root@genesis etc]# ls -la perfparse.cfg*
> > -rw-r--r--    1 root     root         1303 Aug 27 10:58 perfparse.cfg
> > -rw-r--r--    1 root     root         1303 Aug 27 10:24
> > perfparse.cfg.example
> >
> > As you can see I've tried to run the update as root. What is my mistake?
> Now
> > I can't see the pp web page:
> >
> > Error message:
> > malformed header from script. Bad header=<pre>: perfgraph.cgi
> >
> > Regarding the nagios restarting and stopping checks problems, they seems
> to
> > be solved. I've changed the use_retained_program_state from 0 to 1 and
> my
> > nagios is checking around 16 hours :-)))
> >
> >
> >
> >>Paulo Afonso Graner Fessel wrote:
> >>
> >>
> >>>Recompile perfparse according to the instructions:
> >>>
> >>>./configure \
> >>>            --prefix=/usr/local/nagios \
> >>>            --with-imagedir=/usr/local/nagios/share/images/ \
> >>>            --with-cgidir=/usr/local/nagios/sbin \
> >>>            --with-http_image_path=/nagios/images
> >>>
> >>>(Of course, I'm assuming that you've got nagios in /usr/local/nagios.)
> >>>
> >>>This way, perfparse.cfg will be installed at /usr/local/nagios/etc.
> >>>
> >>>
> >>>>>You should upgrade to 0.99.09. It may or may not help with
> >>>>
> >>>>this issue,
> >>>>
> >>>>>but there are a couple of other bugfixes/enhancements
> >>>>
> >>>>available in the
> >>>>
> >>>>>latest version. And don't forget to run
> >>>>>'/<path_to>/nagios/bin/perfparse-db-tool --update' after
> >>>>
> >>>>each upgrade...
> >>>>
> >>>>[Wilson Pires Jr]
> >>>>I'm upgrading, but I can't run the upgrade:
> >>>>Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"
> >>>>I'm logged as root. The perfparse.cfg owner is root. What
> >>>>mistake am I doing?
> >>>>
> >>>>
> >
> >

RE: [Perfparse-users] nagios restarting

[Wilson P. J. <wp....@te...>]

> 
> But I suggest that you do it every 24h anyways.
> It can also fix
> nagios problems when you compiled the embedded perl interpreter in nagios,
> and refresh
> the state of the services... but this is beyond our subject :)
> 
> Here is some suggestion before we release the new version with such a
> feature (not soon):
> 1/ Use perfparse every 10 minutes without --delete* options. This will
> send the perf data.
> 2/ Use perfparse every 24 hours *with* the --delete option. This will
> empty the perf log
> (and send the perf data).
> 
> I'm interested in how many lines you get in such a file in 24h, the size
> of the file,
> and the size when you compress it with gzip -9.
> I can see what priorities to set on my developments :)
> 

[Wilson Pires Jr] 
Yves, as I said in other message, the restarting problem was solved by
changing use_retained_program_state from 0 to 1. Even maintaining --delete
every 10 minutes.

Even though, if you want the information (lines and size), I can change the
policy and send the information to you. Let me know if you want it.

> 

Re: [Perfparse-users] Cannot run db-tool update [was: nagios restarting]

[Ben C. <Be...@cl...>]

I note the error is:

Error, can't open configuration file: "//usr/local/etc/perfparse.cfg"

The file you are after is:

/usr/local/nagios/etc/perfparse.cfg

Are you are configuring using: --prefix=/usr/local/nagios ??

This should work. :(

Can you try deleting the program 'perfparse-db-tool' and doing a 
complete recompile, as stated in the README?

Does this regenerate this program?   If you run it, does it work?

Ben







Wilson Pires Jr wrote:

>>Remember as well that by default PP will install the file:
>>/usr/local/nagios/etc/perfparse.cfg.example
>>You need to rename this:
>>/usr/local/nagios/etc/perfparse.cfg
>>And add your own settings.
>>Ben.
>>
> 
> 
> [Wilson Pires Jr] 
> I've recompiled and reinstalled, as suggested by Paulo, and renamed and set
> perfparse.cfg.example and perfparse.sh.example. But the problem remains. I
> can't run the db update:
> 
> [root@genesis bin]# ./perfparse-db-tool --update
> Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"
> 
> The files perfparse-db-tool and perfparse.cfg are owned by root, and
> perfparse.sh is owned by nagios. Is this correct?
> 
> /usr/local/nagios/bin
> -rwxr-xr-x    1 root     root       250813 Aug 27 10:24 perfparse
> -rwxr-xr-x    1 root     root         1661 Jul 28 10:42 perfparse_daemon.sh
> -rwxr-xr-x    1 root     root       262873 Aug 27 10:24 perfparse-db-purge
> -rwxr-xr-x    1 root     root       253547 Aug 27 10:24 perfparse-db-tool
> -rwxr-xr-x    1 nagios   nagios     252518 Jul 19 16:59 perfparse-install-db
> -rwxr-xr-x    1 nagios   nagios     259533 Jul 19 16:59 perfparse-purge-db
> -rwxr-xr-x    1 nagios   nagios       1326 Aug 27 10:32 perfparse.sh
> 
> /usr/local/nagios/etc
> [root@genesis etc]# ls -la perfparse.cfg*
> -rw-r--r--    1 root     root         1303 Aug 27 10:58 perfparse.cfg
> -rw-r--r--    1 root     root         1303 Aug 27 10:24
> perfparse.cfg.example
> 
> As you can see I've tried to run the update as root. What is my mistake? Now
> I can't see the pp web page:
> 
> Error message: 
> malformed header from script. Bad header=<pre>: perfgraph.cgi
> 
> Regarding the nagios restarting and stopping checks problems, they seems to
> be solved. I've changed the use_retained_program_state from 0 to 1 and my
> nagios is checking around 16 hours :-)))
> 
> 
> 
>>Paulo Afonso Graner Fessel wrote:
>>
>>
>>>Recompile perfparse according to the instructions:
>>>
>>>./configure \
>>>            --prefix=/usr/local/nagios \
>>>            --with-imagedir=/usr/local/nagios/share/images/ \
>>>            --with-cgidir=/usr/local/nagios/sbin \
>>>            --with-http_image_path=/nagios/images
>>>
>>>(Of course, I'm assuming that you've got nagios in /usr/local/nagios.)
>>>
>>>This way, perfparse.cfg will be installed at /usr/local/nagios/etc.
>>>
>>>
>>>>>You should upgrade to 0.99.09. It may or may not help with
>>>>
>>>>this issue,
>>>>
>>>>>but there are a couple of other bugfixes/enhancements
>>>>
>>>>available in the
>>>>
>>>>>latest version. And don't forget to run
>>>>>'/<path_to>/nagios/bin/perfparse-db-tool --update' after
>>>>
>>>>each upgrade...
>>>>
>>>>[Wilson Pires Jr]
>>>>I'm upgrading, but I can't run the upgrade:
>>>>Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"
>>>>I'm logged as root. The perfparse.cfg owner is root. What
>>>>mistake am I doing?
>>>>
>>>>
> 
> 

RES: [Possible SPAM] - [Perfparse-users] check_nt 1.24 doesn't see format strings when using COUNTER - Found word(s) inkjet cartridges in the Text body

[Paulo A. G. F. <pau...@pr...>]

James,

Read my answers below.

Paulo Afonso Graner Fessel
Administrador de Ambiente e Sistemas UNIX
pau...@pr...
OWT
Fone: +55 (11) 3038-6464
Fax: +55 (11) 3038-6508
http://www.primesys.com.br
=20
=20
=20
=20

> -----Mensagem original-----
> De: per...@li...=20
> [mailto:per...@li...] Em nome=20
> de Ferrill, James
> Enviada em: quinta-feira, 26 de agosto de 2004 22:02
> Para: per...@li...
> Assunto: [Possible SPAM] - [Perfparse-users] check_nt 1.24=20
> doesn't see format strings when using COUNTER - Found word(s)=20
> inkjet cartridges in the Text body
>=20
> > I've been trying to collect some counter data and it=20
> doesn't seem to=20
> > work quite right using the latest check_nt from CVS (1.24):
> >=20
> > nexismdev04:/usr/local/nagios/libexec# ./check_nt -H=20
> 172.29.19.28 -p=20
> > 1248 -v COUNTER -l "\\Memory\\Available Bytes"
> > 270553088
> >=20
> > nexismdev04:/usr/local/nagios/libexec# ./check_nt -H=20
> 172.29.19.28 -p=20
> > 1248 -v COUNTER -l "\\Memory\\Available Bytes","Free memory"
> > No unit counter specified
> >=20
> > nexismdev04:/usr/local/nagios/libexec# ./check_nt -H=20
> 172.29.19.28 -p=20
> > 1248 -v COUNTER -l "\\Memory\\Available Bytes","Free memory %.2f"
> > Free memory %.2f =3D 271278080.00 %|'Free memory=20
> > %.2f'=3D271278080.000000%;0.000000;;
> >=20
> > nexismdev04:/usr/local/nagios/libexec# ./check_nt -H=20
> 172.29.19.28 -p=20
> > 1248 -v COUNTER -l "\\Paging File(_Total)\\%% Usage","%.f=20
> %% paging file used."
> > %.f %% paging file used. =3D 0.00 %|'%.f %% paging file=20
> > used.'=3D0.000000%;0.000000;;
> >=20
> > Is this a bug or am I doing it wrong?

Well, I've modified check_nt to show performance data with maximum,
minimum and warning/critical thresholds. With these changes, the
functionality of specifying the formatting string at the output has
really been scrapped. This happened because the description field should
exist for PerfParse in order to be graphed - and using the description
field already provided for check_nt in CHECK_COUNTER seemed to be the
most sensible idea.

On the other hand, I couldn't include the formatting field as perfdata
information is processed by specific functions (perfdata and fperfdata
in plugins/utils.c) where a formatting string can't be used to inform
data. So, I thought like Bill Gates and concluded that "two decimal
places should be sufficient for anybody". If someone has a better
solution, please submit to nagios-plugin-devel list.

Until then, you should invoke the plugin like this:

[root@nagioslab plugins]#./check_nt -H 10.4.8.210 -v COUNTER -l
"\\Paging File(_Total)\\% Usage","Total Paging File Usage"
Total Paging File Usage =3D 12.50 %|'Total Paging File
Usage'=3D12.503050%;0.000000;0.000000;
[root@nagioslab plugins]# ./check_nt -H 10.4.8.210 -v COUNTER -l
"\\Memory\\Available Bytes","Free memory","Bytes"
Free memory =3D 135479296.00 Bytes|'Free
memory'=3D135479296.000000Bytes;0.000000;0.000000;

[]'s
Paulo

[Perfparse-users] Cannot run db-tool update [was: nagios restarting]

[Wilson P. J. <wp....@te...>]

> 
> Remember as well that by default PP will install the file:
> /usr/local/nagios/etc/perfparse.cfg.example
> You need to rename this:
> /usr/local/nagios/etc/perfparse.cfg
> And add your own settings.
> Ben.
> 

[Wilson Pires Jr] 
I've recompiled and reinstalled, as suggested by Paulo, and renamed and set
perfparse.cfg.example and perfparse.sh.example. But the problem remains. I
can't run the db update:

[root@genesis bin]# ./perfparse-db-tool --update
Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"

The files perfparse-db-tool and perfparse.cfg are owned by root, and
perfparse.sh is owned by nagios. Is this correct?

/usr/local/nagios/bin
-rwxr-xr-x    1 root     root       250813 Aug 27 10:24 perfparse
-rwxr-xr-x    1 root     root         1661 Jul 28 10:42 perfparse_daemon.sh
-rwxr-xr-x    1 root     root       262873 Aug 27 10:24 perfparse-db-purge
-rwxr-xr-x    1 root     root       253547 Aug 27 10:24 perfparse-db-tool
-rwxr-xr-x    1 nagios   nagios     252518 Jul 19 16:59 perfparse-install-db
-rwxr-xr-x    1 nagios   nagios     259533 Jul 19 16:59 perfparse-purge-db
-rwxr-xr-x    1 nagios   nagios       1326 Aug 27 10:32 perfparse.sh

/usr/local/nagios/etc
[root@genesis etc]# ls -la perfparse.cfg*
-rw-r--r--    1 root     root         1303 Aug 27 10:58 perfparse.cfg
-rw-r--r--    1 root     root         1303 Aug 27 10:24
perfparse.cfg.example

As you can see I've tried to run the update as root. What is my mistake? Now
I can't see the pp web page:

Error message: 
malformed header from script. Bad header=<pre>: perfgraph.cgi

Regarding the nagios restarting and stopping checks problems, they seems to
be solved. I've changed the use_retained_program_state from 0 to 1 and my
nagios is checking around 16 hours :-)))


> Paulo Afonso Graner Fessel wrote:
> 
> > Recompile perfparse according to the instructions:
> >
> > ./configure \
> >             --prefix=/usr/local/nagios \
> >             --with-imagedir=/usr/local/nagios/share/images/ \
> >             --with-cgidir=/usr/local/nagios/sbin \
> >             --with-http_image_path=/nagios/images
> >
> > (Of course, I'm assuming that you've got nagios in /usr/local/nagios.)
> >
> > This way, perfparse.cfg will be installed at /usr/local/nagios/etc.
> >
> >>>You should upgrade to 0.99.09. It may or may not help with
> >>this issue,
> >>>but there are a couple of other bugfixes/enhancements
> >>available in the
> >>>latest version. And don't forget to run
> >>>'/<path_to>/nagios/bin/perfparse-db-tool --update' after
> >>each upgrade...
> >>
> >>[Wilson Pires Jr]
> >>I'm upgrading, but I can't run the upgrade:
> >>Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"
> >>I'm logged as root. The perfparse.cfg owner is root. What
> >>mistake am I doing?
> >>
> >>>

RE: [Perfparse-users] nagios restarting

[Yves M. <yme...@li...>]

> The problem I see restarting nagios every 10 minutes (in my case with p=
p),
> is that nagios log grows too much, since I get around 700 services and =
hosts
> alerts saying "OK". (I monitor 100 hosts and 600 services).

Garry said that with a lot of hosts and services, you sometimes need to f=
lush the logs
(and rotate them or compress them or anything...).
I agree with him.
I'm working on something that will allow to send the data without the nee=
d to restart
nagios every 10 minutes. But I suggest that you do it every 24h anyways. =
It can also fix
nagios problems when you compiled the embedded perl interpreter in nagios=
, and refresh
the state of the services... but this is beyond our subject :)

Here is some suggestion before we release the new version with such a fea=
ture (not soon):
1/ Use perfparse every 10 minutes without --delete* options. This will se=
nd the perf data.
2/ Use perfparse every 24 hours *with* the --delete option. This will emp=
ty the perf log
(and send the perf data).

I'm interested in how many lines you get in such a file in 24h, the size =
of the file,
and the size when you compress it with gzip -9.
I can see what priorities to set on my developments :)

Yves (main contributor on perfparse)


--=20
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- GTKtalog    - http://www.nongnu.org/gtktalog/                    -

Re: [Perfparse-users] perfparse mysql: access denied

[Ben C. <Be...@cl...>]

Have a go at this:

GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
REFERENCES ON nagiosperf.* TO nagiosperf@localhost IDENTIFIED BY 'password';

Or

GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
REFERENCES ON nagiosperf.* TO nagiosperf@"127.0.0.1" IDENTIFIED BY 
'password';

Or

GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
REFERENCES ON nagiosperf.* TO nagiosperf@"192.168.1.%" IDENTIFIED BY 
'password';

(Where 192.168.1.% represents your lan, change accordingly.)

Or all of them together.

Ben


Julien TOUCHE wrote:

> 
> i've setup nagios 1.2 and perfparse (latest) on a whitebox3/x86. nagios is
> working well but perfparse seems to have a problem with mysql.
> mysql4 is installed from mysql.com srpm.
> 
> user created & perfparse.conf checked:
> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
> REFERENCES ON nagiosperf.* TO nagiosperf@whitebox IDENTIFIED BY 'password';
> 
> but
> # /opt/nagios/bin/perfparse -r
> /opt/nagios/bin/perfparse:
> Error: Could not connect to MySQL database 'nagiosperf' on host
> '127.0.0.1' using username 'nagiosperf' and password 'n:
> Access denied for user: 'nagiosperf@whitebox' (Using password: YES)
> 
> i suppose perfparse always displays nagios as password. problem is with
> mysql, i connect without problem and with the real password which is in
> conf file.
> 
> is there any way to get more details on mysql connection ?
> 
> thanks
> Regards
> 
>         Julien
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
> 

Re: RES: [Perfparse-users] nagios restarting

[Ben C. <Be...@cl...>]

Remember as well that by default PP will install the file:

/usr/local/nagios/etc/perfparse.cfg.example

You need to rename this:

/usr/local/nagios/etc/perfparse.cfg

And add your own settings.

Ben.


Paulo Afonso Graner Fessel wrote:

> Recompile perfparse according to the instructions:
>=20
> ./configure \
>             --prefix=3D/usr/local/nagios \
>             --with-imagedir=3D/usr/local/nagios/share/images/ \
>             --with-cgidir=3D/usr/local/nagios/sbin \
>             --with-http_image_path=3D/nagios/images
>=20
> (Of course, I'm assuming that you've got nagios in /usr/local/nagios.)
>=20
> This way, perfparse.cfg will be installed at /usr/local/nagios/etc.
>=20
> []'s
> Paul=E3o
>=20
> Paulo Afonso Graner Fessel
> Administrador de Ambiente e Sistemas UNIX
> pau...@pr...
> OWT
> Fone: +55 (11) 3038-6464
> Fax: +55 (11) 3038-6508
> http://www.primesys.com.br
> =20
> =20
> =20
> =20
>=20
>=20
>>-----Mensagem original-----
>>De: per...@li...=20
>>[mailto:per...@li...] Em nome=20
>>de Wilson Pires Jr
>>Enviada em: quinta-feira, 26 de agosto de 2004 16:56
>>Para: 'Cook, Garry'; per...@li...
>>Assunto: RE: [Perfparse-users] nagios restarting
>>
>>
>>
>>>I didn't see this original message on the PerfParse User's=20
>>
>>mailing list.
>>
>>>Did this thread begin somewhere else, or am I missing some messages?
>>
>>[Wilson Pires Jr]
>>Garry, the original message was posted on PP User's mailing list.
>>
>>
>>>per...@li... wrote:
>>>
>>>>>Hi all.
>>>>>
>>>>>I've observed my nagios restart every perfparse.sh run. I use
>>>>>perfparse-0.99.07
>>>
>>>You should upgrade to 0.99.09. It may or may not help with=20
>>
>>this issue,=20
>>
>>>but there are a couple of other bugfixes/enhancements=20
>>
>>available in the=20
>>
>>>latest version. And don't forget to run=20
>>>'/<path_to>/nagios/bin/perfparse-db-tool --update' after=20
>>
>>each upgrade...
>>
>>[Wilson Pires Jr]
>>I'm upgrading, but I can't run the upgrade:
>>Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"
>>I'm logged as root. The perfparse.cfg owner is root. What=20
>>mistake am I doing?
>>
>>
>>>>>[26-08-2004 12:35:00] Nagios 1.2 starting... (PID=3D12443)
>>>>>[26-08-2004 12:35:00] Caught SIGHUP, restarting...
>>>>>
>>>>>Is this ok? If so, why is needed nagios restarting?
>>>>
>>>>If you are using --delete* option, yes, perfparse sends=20
>>
>>some SIGHUP=20
>>
>>>>signal to nagios to ask for restart and use a new serviceperf.log=20
>>>>file.
>>>>Otherwise, nothing to see with perfparse.
>>>
>>>I've seen some postings (on Nagios Users or Devel lists)=20
>>
>>about Nagios=20
>>
>>>restarting when sent a HUP, whereas it should only re-read=20
>>
>>it's config=20
>>
>>>files. I don't remember exactly, but I think the original=20
>>
>>posters may=20
>>
>>>have been using Nagios 2.0 and/or Fedora Linux Distro. Are=20
>>
>>you using=20
>>
>>>either of these? What versions of Nagios/Linux are you using?
>>>
>>
>>[Wilson Pires Jr]
>>I run:
>>nagios 1.2
>>redhat 9
>>plugin 1.4a
>>
>>
>>>>>I'm trying to figure out why my nagios stops working after few=20
>>>>>hours and I'd like to know if this "nagios restarting" has some=20
>>>>>relation to "nagios stopping".
>>>>
>>>>perfparse does not ask nagios to stop, but only to start=20
>>
>>writing to=20
>>
>>>>a new serviceperf.log file, which also mean restarting, but not=20
>>>>stopping.
>>>>In your log, strange that nagios starts and restarts at the same=20
>>>>time. SIGHUP caught by change at that time ?
>>>
>>>If Nagios fails to HUP properly, it could be leaving you with more=20
>>>than one Nagios process running. This can sometimes cause odd=20
>>>behavior, like checks not being run and/or notifications=20
>>
>>not being sent.
>>
>>>Is Nagios actually shutting down? Or is it running but not=20
>>
>>performing=20
>>
>>>actions as expected?
>>>
>>
>>[Wilson Pires Jr]
>>As you said below nagios remains running, bur stops performing checks.
>>
>>
>>>>>When nagios stops its checks, it always has a zombie process.
>>>>
>>>>How long do they live ? (just asking for if others can help :)
>>>>
>>>>Yves
>>>>
>>>>
>>>>>Regards,
>>>>>
>>>>>Wilson
>>>
>>>It looks like you've already answered the question that I=20
>>
>>asked above.
>>
>>>So, Nagios is running but not performing checks, correct?=20
>>
>>This is most=20
>>
>>>likely related to the zombie/second running Nagios process.=20
>>
>>This may=20
>>
>>>be due to the HUP sent by PerfParse, but not exactly caused=20
>>
>>by it. A=20
>>
>>>HUP sent to Nagios by PP, command line, or some other=20
>>
>>process should=20
>>
>>>be interpreted correctly and not cause this problem. If it's not=20
>>>working correctly, I believe that the problem is related to Nagios=20
>>>itself. If you can provide the version information that I=20
>>
>>asked above=20
>>
>>>(Nagios/Linux), I can look back through the archives and see what=20
>>>information I can find. Or, you could do this if you are on Nagios=20
>>>and/or Nagios Devel lists.
>>>
>>
>>[Wilson Pires Jr]
>>Ok. The versions are above (nagios 1.2, rh9). I've used=20
>>nagios-1-x-cvs trying to correct the problem, but it persists.
>>If you can, I ask your tips since I don't know what HUP or=20
>>SIGHUP exactly does.
>>
>>
>>>Garry W. Cook, CCNA
>>>Network Infrastructure Manager
>>>MACTEC, Inc. - http://www.mactec.com/
>>>303.308.6228 (Office) - 720.220.1862 (Mobile)
>>>
>>>
>>>-------------------------------------------------------
>>>SF.Net email is sponsored by Shop4tech.com-Lowest price on=20
>>
>>Blank Media=20
>>
>>>100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for=20
>>
>>only $33 Save=20
>>
>>>50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>>>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>>>_______________________________________________
>>>Perfparse-users mailing list
>>>Per...@li...
>>>https://lists.sourceforge.net/lists/listinfo/perfparse-users
>>
>>
>>
>>
>>
>>-------------------------------------------------------
>>SF.Net email is sponsored by Shop4tech.com-Lowest price on=20
>>Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic=20
>>DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free=20
>>Shipping and Free Gift.
>>http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>>_______________________________________________
>>Perfparse-users mailing list
>>Per...@li...
>>https://lists.sourceforge.net/lists/listinfo/perfparse-users
>>
>=20
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>=20

Re: [Perfparse-users] re: deletion policys

[Ben C. <Be...@cl...>]

James,

I need some information from your MySQL.  Can you start the MySQL shell 
(mysql -u nagios -pnagios -D nagios) and enter:

mysql> select * from perfdata_delete_policy;

This should produce at least this:

+-------------+---------------+
| policy_name | delete_policy |
+-------------+---------------+
| Always      |            30 |
| Bin Default |            30 |
+-------------+---------------+

Which will have different values in the second column.

Let me know and we can go from there.

Ben



James Ochs wrote:

> I'm still having this issue.  Does anyone know what the foreign key that 
> it is referring to is?  Or how to find out?   Here's the latest output:
> 
> 
> 
> [jochs@mon-01 bin]$
> [jochs@mon-01 bin]$ ./perfparse-db-tool --update
> [jochs@mon-01 bin]$ ./perfparse-db-purge -r
> "UPDATE perfdata_service_metric SET bin_delete_policy_name = 'Bin 
> Default' WHERE bin_delete_policy_type = 'template' AND 
> bin_delete_policy_name IS NULL" failed:
> 
> Cannot add or update a child row: a foreign key constraint fails
> [jochs@mon-01 bin]$ ./perfparse-db-purge --show_config
> DB_User =        "nagios"
> DB_Name =        "nagios"
> DB_Pass =        "n4g10s"
> DB_Host =        "127.0.0.1"
> Drop_File =      "/tmp/perfparse.drop"
> Service_Log =    "/usr/local/nagios/var/serviceperf.log"
> Host_Log =       "/usr/local/nagios/var/hostperf.log"
> Dummy_Hostname = "dummy"
> Delete_Service_Log =         "No"
> Delete_Host_Log =            "No"
> Nagios_Lock =    "/usr/local/nagios/var/nagios.lock"
> Lock_File =      "/var/lock/perfparse.lock"
> Be_Silent =      "no"
> Do_Report =      "no"
> Accept_Odd_Chars_in_Label =      "no"
> Default_user_permissions_Policy = "rw"
> Default_user_permissions_Host_groups = "rw"
> [jochs@mon-01 bin]$
> 
> -----Original Message-----
> From: Tim Brazil [mailto:br...@se...]
> Sent: Wednesday, August 25, 2004 2:43 PM
> To: James Ochs
> Cc: per...@li...
> Subject: Re: [Perfparse-users] re: deletion policys
> 
> Hi James
> 
> The only other thing I did was changed to the newer sample version
> perfparse.cfg.
> 
> Here are some thoughts...
> Did you see any "upgrade" output from ./perfparse-db-tool --update when
> you ran it indicating something actually happened?
> Is the binary from  perfparse-db-tool the new one that was built with
> 0.99.09.
> I initially didn't "configure" correctly which "make install"ed
> perfparse-db-tool  to the wrong directory (/usr/local/bin) which left
> the older version of perfparse-db-tool  in place under 
> /usr/local/nagios/bin
> 
> Tim
> 
> James Ochs wrote:
> 
>  > Upgrading to 0.99.09 didn't fix this problem for me.  Nor did running
>  > perfparse-db-tool --update.
>  >
>  > James
>  >
>  > -----Original Message-----
>  > From: Tim Brazil [mailto:br...@se...]
>  > Sent: Wednesday, August 25, 2004 1:39 PM
>  > Cc: per...@li...
>  > Subject: Re: [Perfparse-users] re: deletion policys
>  >
>  > Thanks Garry
>  > I updated to 0.99.09, ran ./perfparse-db-tool --update and it fixed my
>  > problem.
>  >
>  > Tim
>  >
>  > Cook, Garry wrote:
>  >
>  > >per...@li... wrote:
>  > >
>  > >
>  > >>I have been watching this post becasue I too am experiencing this
>  > >>problem.  It's been about 1 month since I've started collection
>  > >>performance statistics and I'd like to do some cleanup. I
>  > >>cannot create
>  > >>deletion policies due to the "Cannot add or update a child row: a
>  > >>foreign key constraint fails"  error.
>  > >>Any ideas on how to rectify this. I also ran the ./perfparse-db-tool
>  > >>--update to see whether it would correct the problem. It
>  > >>didn't change
>  > >>anything. I have Version 0.99.05. Schema Version 0.12
>  > >>
>  > >>Thanks in advance
>  > >>Tim
>  > >>  
>  > >>
>  > >
>  > >I believe that this bug was fixed in Version 0.99.08, but it might have
>  > >been 0.99.09. Either way, you should definitely be using the latest
>  > >stable version -> 0.99.09.
>  > >I thought that I saw someone else post about this issue and say that 
> the
>  > >version upgrade did not fix it for them. However, they did not mention
>  > >if they ran 'perfparse-db-tool --update' after upgrading PerfParse.
>  > >
>  > >Everyone needs to realize something very important:
>  > >With new versions, there are changes to the PerfParse code and there 
> are
>  > >sometimes changes made to the MySQL DB as well. You need to use the
>  > >perfparse-db-tool to update your DB with each upgrade. This tool 
> will be
>  > >installed in your '<path_to>/nagios/bin/' directory, run it with the
>  > >'--update' argument to ensure that DB changes are made properly.
>  > >
>  > >Garry W. Cook, CCNA
>  > >Network Infrastructure Manager
>  > >MACTEC, Inc. - http://www.mactec.com/
>  > >303.308.6228 (Office) - 720.220.1862 (Mobile)
>  > >
>  > >
>  > >-------------------------------------------------------
>  > >SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>  > >100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>  > >Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>  > >http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>  > >_______________________________________________
>  > >Perfparse-users mailing list
>  > >Per...@li...
>  > >https://lists.sourceforge.net/lists/listinfo/perfparse-users
>  > >
>  > >
>  >
>  >
>  >
>  > -------------------------------------------------------
>  > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
>  > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
>  > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
>  > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
>  > _______________________________________________
>  > Perfparse-users mailing list
>  > Per...@li...
>  > https://lists.sourceforge.net/lists/listinfo/perfparse-users
>  >
> 

[Perfparse-users] check_nt 1.24 doesn't see format strings when using COUNTER

[Ferrill, J. <jam...@NE...>]

> I've been trying to collect some counter data and it doesn't seem to work
> quite right using the latest check_nt from CVS (1.24):
> 
> nexismdev04:/usr/local/nagios/libexec# ./check_nt -H 172.29.19.28 -p 1248
> -v COUNTER -l "\\Memory\\Available Bytes"
> 270553088
> 
> nexismdev04:/usr/local/nagios/libexec# ./check_nt -H 172.29.19.28 -p 1248
> -v COUNTER -l "\\Memory\\Available Bytes","Free memory"
> No unit counter specified
> 
> nexismdev04:/usr/local/nagios/libexec# ./check_nt -H 172.29.19.28 -p 1248
> -v COUNTER -l "\\Memory\\Available Bytes","Free memory %.2f"
> Free memory %.2f = 271278080.00 %|'Free memory
> %.2f'=271278080.000000%;0.000000;;
> 
> nexismdev04:/usr/local/nagios/libexec# ./check_nt -H 172.29.19.28 -p 1248
> -v COUNTER -l "\\Paging File(_Total)\\%% Usage","%.f %% paging file used."
> %.f %% paging file used. = 0.00 %|'%.f %% paging file
> used.'=0.000000%;0.000000;;
> 
> Is this a bug or am I doing it wrong?
> 
> Thanks.
> 
> James Ferrill
> IT Analyst II
> NextiraOne
> Phone: 713-307-4029
> Email: jam...@ne...
> 
> 

RE: [Perfparse-users] perfparse mysql: access denied

[Cook, G. <GW...@ma...>]

Run 'perfparse --help' to see all of the options. Then try adding the
user/pass/db/host on the command line and see if that works.

Next, change the db password to 'nagios' in the perfparse.cfg and see if
that works. If so, then the password is not being read from the config
for some reason and the default 'nagios' pass is being used.

Also, if there are any funny characters in your password (!,%,$,etc.) in
the perfparse.cfg, try escaping them with a backslash.

Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)

per...@li... wrote:
> i've setup nagios 1.2 and perfparse (latest) on a
> whitebox3/x86. nagios is
> working well but perfparse seems to have a problem with mysql.
> mysql4 is installed from mysql.com srpm.
>=20
> user created & perfparse.conf checked:
> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
> REFERENCES ON nagiosperf.* TO nagiosperf@whitebox IDENTIFIED
> BY 'password';
>=20
> but
> # /opt/nagios/bin/perfparse -r
> /opt/nagios/bin/perfparse:
> Error: Could not connect to MySQL database 'nagiosperf' on host
> '127.0.0.1' using username 'nagiosperf' and password 'n:
> Access denied for user: 'nagiosperf@whitebox' (Using password: YES)
>=20
> i suppose perfparse always displays nagios as password.
> problem is with
> mysql, i connect without problem and with the real password
> which is in
> conf file.
>=20
> is there any way to get more details on mysql connection ?
>=20
> thanks
> Regards
>=20
> 		Julien


Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)

[Perfparse-users] perfparse mysql: access denied

[Julien T. <jul...@ly...>]

i've setup nagios 1.2 and perfparse (latest) on a whitebox3/x86. nagios is
working well but perfparse seems to have a problem with mysql.
mysql4 is installed from mysql.com srpm.

user created & perfparse.conf checked:
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP,
REFERENCES ON nagiosperf.* TO nagiosperf@whitebox IDENTIFIED BY 'password';

but
# /opt/nagios/bin/perfparse -r
/opt/nagios/bin/perfparse:
Error: Could not connect to MySQL database 'nagiosperf' on host
'127.0.0.1' using username 'nagiosperf' and password 'n:
Access denied for user: 'nagiosperf@whitebox' (Using password: YES)

i suppose perfparse always displays nagios as password. problem is with
mysql, i connect without problem and with the real password which is in
conf file.

is there any way to get more details on mysql connection ?

thanks
Regards

		Julien

RE: [Perfparse-users] nagios restarting

[Wilson P. J. <wp....@te...>]

Now, I've upgraded pp to 0.99.09, but don't updated the db. So when I =
try to
access the pp web page I get:

Server error!
The server encountered an internal error and was unable to complete your
request.=20
Error message:=20
malformed header from script. Bad header=3D<pre>: perfgraph.cgi=20
If you think this is a server error, please contact the webmaster=20
Error 500
10.109.0.16=20
Thu 26 Aug 2004 06:09:18 PM BRT=20
Apache/2.0.40 (Red Hat Linux)

Is this problem caused by db don't be updated?

Wilson

> -----Original Message-----
> From: Wilson Pires Jr [mailto:wp....@te...]
> Sent: quinta-feira, 26 de agosto de 2004 18:03
> To: 'Paulo Afonso Graner Fessel'; 'Cook, Garry'; 'perfparse-
> us...@li...'
> Subject: RE: [Perfparse-users] nagios restarting
>=20
> It was configured according to the instructions, but I still can't run =
the
> db update ... :(
>=20
> > -----Original Message-----
> > From: Paulo Afonso Graner Fessel =
[mailto:pau...@pr...]
> > Sent: quinta-feira, 26 de agosto de 2004 17:06
> > To: Wilson Pires Jr; Cook, Garry; =
per...@li...
> > Subject: RES: [Perfparse-users] nagios restarting
> >
> > Recompile perfparse according to the instructions:
> >
> > ./configure \
> >             --prefix=3D/usr/local/nagios \
> >             --with-imagedir=3D/usr/local/nagios/share/images/ \
> >             --with-cgidir=3D/usr/local/nagios/sbin \
> >             --with-http_image_path=3D/nagios/images
> >
> > (Of course, I'm assuming that you've got nagios in =
/usr/local/nagios.)
> >
> > This way, perfparse.cfg will be installed at /usr/local/nagios/etc.
> >
> > []'s
> > Paul=E3o
> >
> > Paulo Afonso Graner Fessel
> > Administrador de Ambiente e Sistemas UNIX
> > pau...@pr...
> > OWT
> > Fone: +55 (11) 3038-6464
> > Fax: +55 (11) 3038-6508
> > http://www.primesys.com.br
> >
> >
> >
> >
> >
> > > -----Mensagem original-----
> > > De: per...@li...
> > > [mailto:per...@li...] Em nome
> > > de Wilson Pires Jr
> > > Enviada em: quinta-feira, 26 de agosto de 2004 16:56
> > > Para: 'Cook, Garry'; per...@li...
> > > Assunto: RE: [Perfparse-users] nagios restarting
> > >
> > >
> > > > I didn't see this original message on the PerfParse User's
> > > mailing list.
> > > > Did this thread begin somewhere else, or am I missing some =
messages?
> > >
> > > [Wilson Pires Jr]
> > > Garry, the original message was posted on PP User's mailing list.
> > >
> > > >
> > > > per...@li... wrote:
> > > > >> Hi all.
> > > > >>
> > > > >> I've observed my nagios restart every perfparse.sh run. I use
> > > > >> perfparse-0.99.07
> > > >
> > > > You should upgrade to 0.99.09. It may or may not help with
> > > this issue,
> > > > but there are a couple of other bugfixes/enhancements
> > > available in the
> > > > latest version. And don't forget to run
> > > > '/<path_to>/nagios/bin/perfparse-db-tool --update' after
> > > each upgrade...
> > > >
> > >
> > > [Wilson Pires Jr]
> > > I'm upgrading, but I can't run the upgrade:
> > > Error, can't open configuation file: =
"//usr/local/etc/perfparse.cfg"
> > > I'm logged as root. The perfparse.cfg owner is root. What
> > > mistake am I doing?
> > >
> > > >
> > > > >> [26-08-2004 12:35:00] Nagios 1.2 starting... (PID=3D12443)
> > > > >> [26-08-2004 12:35:00] Caught SIGHUP, restarting...
> > > > >>
> > > > >> Is this ok? If so, why is needed nagios restarting?
> > > > >
> > > > > If you are using --delete* option, yes, perfparse sends
> > > some SIGHUP
> > > > > signal to nagios to ask for restart and use a new =
serviceperf.log
> > > > > file.
> > > > > Otherwise, nothing to see with perfparse.
> > > >
> > > > I've seen some postings (on Nagios Users or Devel lists)
> > > about Nagios
> > > > restarting when sent a HUP, whereas it should only re-read
> > > it's config
> > > > files. I don't remember exactly, but I think the original
> > > posters may
> > > > have been using Nagios 2.0 and/or Fedora Linux Distro. Are
> > > you using
> > > > either of these? What versions of Nagios/Linux are you using?
> > > >
> > >
> > > [Wilson Pires Jr]
> > > I run:
> > > nagios 1.2
> > > redhat 9
> > > plugin 1.4a
> > >
> > > >
> > > > >> I'm trying to figure out why my nagios stops working after =
few
> > > > >> hours and I'd like to know if this "nagios restarting" has =
some
> > > > >> relation to "nagios stopping".
> > > > >
> > > > > perfparse does not ask nagios to stop, but only to start
> > > writing to
> > > > > a new serviceperf.log file, which also mean restarting, but =
not
> > > > > stopping.
> > > > > In your log, strange that nagios starts and restarts at the =
same
> > > > > time. SIGHUP caught by change at that time ?
> > > >
> > > > If Nagios fails to HUP properly, it could be leaving you with =
more
> > > > than one Nagios process running. This can sometimes cause odd
> > > > behavior, like checks not being run and/or notifications
> > > not being sent.
> > > > Is Nagios actually shutting down? Or is it running but not
> > > performing
> > > > actions as expected?
> > > >
> > >
> > > [Wilson Pires Jr]
> > > As you said below nagios remains running, bur stops performing =
checks.
> > >
> > > >
> > > > >> When nagios stops its checks, it always has a zombie process.
> > > > >
> > > > > How long do they live ? (just asking for if others can help :)
> > > > >
> > > > > Yves
> > > > >
> > > > >>
> > > > >> Regards,
> > > > >>
> > > > >> Wilson
> > > >
> > > > It looks like you've already answered the question that I
> > > asked above.
> > > > So, Nagios is running but not performing checks, correct?
> > > This is most
> > > > likely related to the zombie/second running Nagios process.
> > > This may
> > > > be due to the HUP sent by PerfParse, but not exactly caused
> > > by it. A
> > > > HUP sent to Nagios by PP, command line, or some other
> > > process should
> > > > be interpreted correctly and not cause this problem. If it's not
> > > > working correctly, I believe that the problem is related to =
Nagios
> > > > itself. If you can provide the version information that I
> > > asked above
> > > > (Nagios/Linux), I can look back through the archives and see =
what
> > > > information I can find. Or, you could do this if you are on =
Nagios
> > > > and/or Nagios Devel lists.
> > > >
> > >
> > > [Wilson Pires Jr]
> > > Ok. The versions are above (nagios 1.2, rh9). I've used
> > > nagios-1-x-cvs trying to correct the problem, but it persists.
> > > If you can, I ask your tips since I don't know what HUP or
> > > SIGHUP exactly does.
> > >
> > > > Garry W. Cook, CCNA
> > > > Network Infrastructure Manager
> > > > MACTEC, Inc. - http://www.mactec.com/
> > > > 303.308.6228 (Office) - 720.220.1862 (Mobile)
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > SF.Net email is sponsored by Shop4tech.com-Lowest price on
> > > Blank Media
> > > > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for
> > > only $33 Save
> > > > 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> > > > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > > > _______________________________________________
> > > > Perfparse-users mailing list
> > > > Per...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/perfparse-users
> > >
> > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > SF.Net email is sponsored by Shop4tech.com-Lowest price on
> > > Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic
> > > DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free
> > > Shipping and Free Gift.
> > > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > > _______________________________________________
> > > Perfparse-users mailing list
> > > Per...@li...
> > > https://lists.sourceforge.net/lists/listinfo/perfparse-users
> > >

RE: [Perfparse-users] nagios restarting

[Wilson P. J. <wp....@te...>]

It was configured according to the instructions, but I still can't run =
the
db update ... :(

> -----Original Message-----
> From: Paulo Afonso Graner Fessel [mailto:pau...@pr...]
> Sent: quinta-feira, 26 de agosto de 2004 17:06
> To: Wilson Pires Jr; Cook, Garry; =
per...@li...
> Subject: RES: [Perfparse-users] nagios restarting
>=20
> Recompile perfparse according to the instructions:
>=20
> ./configure \
>             --prefix=3D/usr/local/nagios \
>             --with-imagedir=3D/usr/local/nagios/share/images/ \
>             --with-cgidir=3D/usr/local/nagios/sbin \
>             --with-http_image_path=3D/nagios/images
>=20
> (Of course, I'm assuming that you've got nagios in /usr/local/nagios.)
>=20
> This way, perfparse.cfg will be installed at /usr/local/nagios/etc.
>=20
> []'s
> Paul=E3o
>=20
> Paulo Afonso Graner Fessel
> Administrador de Ambiente e Sistemas UNIX
> pau...@pr...
> OWT
> Fone: +55 (11) 3038-6464
> Fax: +55 (11) 3038-6508
> http://www.primesys.com.br
>=20
>=20
>=20
>=20
>=20
> > -----Mensagem original-----
> > De: per...@li...
> > [mailto:per...@li...] Em nome
> > de Wilson Pires Jr
> > Enviada em: quinta-feira, 26 de agosto de 2004 16:56
> > Para: 'Cook, Garry'; per...@li...
> > Assunto: RE: [Perfparse-users] nagios restarting
> >
> >
> > > I didn't see this original message on the PerfParse User's
> > mailing list.
> > > Did this thread begin somewhere else, or am I missing some =
messages?
> >
> > [Wilson Pires Jr]
> > Garry, the original message was posted on PP User's mailing list.
> >
> > >
> > > per...@li... wrote:
> > > >> Hi all.
> > > >>
> > > >> I've observed my nagios restart every perfparse.sh run. I use
> > > >> perfparse-0.99.07
> > >
> > > You should upgrade to 0.99.09. It may or may not help with
> > this issue,
> > > but there are a couple of other bugfixes/enhancements
> > available in the
> > > latest version. And don't forget to run
> > > '/<path_to>/nagios/bin/perfparse-db-tool --update' after
> > each upgrade...
> > >
> >
> > [Wilson Pires Jr]
> > I'm upgrading, but I can't run the upgrade:
> > Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"
> > I'm logged as root. The perfparse.cfg owner is root. What
> > mistake am I doing?
> >
> > >
> > > >> [26-08-2004 12:35:00] Nagios 1.2 starting... (PID=3D12443)
> > > >> [26-08-2004 12:35:00] Caught SIGHUP, restarting...
> > > >>
> > > >> Is this ok? If so, why is needed nagios restarting?
> > > >
> > > > If you are using --delete* option, yes, perfparse sends
> > some SIGHUP
> > > > signal to nagios to ask for restart and use a new =
serviceperf.log
> > > > file.
> > > > Otherwise, nothing to see with perfparse.
> > >
> > > I've seen some postings (on Nagios Users or Devel lists)
> > about Nagios
> > > restarting when sent a HUP, whereas it should only re-read
> > it's config
> > > files. I don't remember exactly, but I think the original
> > posters may
> > > have been using Nagios 2.0 and/or Fedora Linux Distro. Are
> > you using
> > > either of these? What versions of Nagios/Linux are you using?
> > >
> >
> > [Wilson Pires Jr]
> > I run:
> > nagios 1.2
> > redhat 9
> > plugin 1.4a
> >
> > >
> > > >> I'm trying to figure out why my nagios stops working after few
> > > >> hours and I'd like to know if this "nagios restarting" has some
> > > >> relation to "nagios stopping".
> > > >
> > > > perfparse does not ask nagios to stop, but only to start
> > writing to
> > > > a new serviceperf.log file, which also mean restarting, but not
> > > > stopping.
> > > > In your log, strange that nagios starts and restarts at the same
> > > > time. SIGHUP caught by change at that time ?
> > >
> > > If Nagios fails to HUP properly, it could be leaving you with more
> > > than one Nagios process running. This can sometimes cause odd
> > > behavior, like checks not being run and/or notifications
> > not being sent.
> > > Is Nagios actually shutting down? Or is it running but not
> > performing
> > > actions as expected?
> > >
> >
> > [Wilson Pires Jr]
> > As you said below nagios remains running, bur stops performing =
checks.
> >
> > >
> > > >> When nagios stops its checks, it always has a zombie process.
> > > >
> > > > How long do they live ? (just asking for if others can help :)
> > > >
> > > > Yves
> > > >
> > > >>
> > > >> Regards,
> > > >>
> > > >> Wilson
> > >
> > > It looks like you've already answered the question that I
> > asked above.
> > > So, Nagios is running but not performing checks, correct?
> > This is most
> > > likely related to the zombie/second running Nagios process.
> > This may
> > > be due to the HUP sent by PerfParse, but not exactly caused
> > by it. A
> > > HUP sent to Nagios by PP, command line, or some other
> > process should
> > > be interpreted correctly and not cause this problem. If it's not
> > > working correctly, I believe that the problem is related to Nagios
> > > itself. If you can provide the version information that I
> > asked above
> > > (Nagios/Linux), I can look back through the archives and see what
> > > information I can find. Or, you could do this if you are on Nagios
> > > and/or Nagios Devel lists.
> > >
> >
> > [Wilson Pires Jr]
> > Ok. The versions are above (nagios 1.2, rh9). I've used
> > nagios-1-x-cvs trying to correct the problem, but it persists.
> > If you can, I ask your tips since I don't know what HUP or
> > SIGHUP exactly does.
> >
> > > Garry W. Cook, CCNA
> > > Network Infrastructure Manager
> > > MACTEC, Inc. - http://www.mactec.com/
> > > 303.308.6228 (Office) - 720.220.1862 (Mobile)
> > >
> > >
> > > -------------------------------------------------------
> > > SF.Net email is sponsored by Shop4tech.com-Lowest price on
> > Blank Media
> > > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for
> > only $33 Save
> > > 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> > > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > > _______________________________________________
> > > Perfparse-users mailing list
> > > Per...@li...
> > > https://lists.sourceforge.net/lists/listinfo/perfparse-users
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > SF.Net email is sponsored by Shop4tech.com-Lowest price on
> > Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic
> > DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free
> > Shipping and Free Gift.
> > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > _______________________________________________
> > Perfparse-users mailing list
> > Per...@li...
> > https://lists.sourceforge.net/lists/listinfo/perfparse-users
> >

RES: [Perfparse-users] nagios restarting

[Paulo A. G. F. <pau...@pr...>]

Recompile perfparse according to the instructions:

./configure \
            --prefix=3D/usr/local/nagios \
            --with-imagedir=3D/usr/local/nagios/share/images/ \
            --with-cgidir=3D/usr/local/nagios/sbin \
            --with-http_image_path=3D/nagios/images

(Of course, I'm assuming that you've got nagios in /usr/local/nagios.)

This way, perfparse.cfg will be installed at /usr/local/nagios/etc.

[]'s
Paul=E3o

Paulo Afonso Graner Fessel
Administrador de Ambiente e Sistemas UNIX
pau...@pr...
OWT
Fone: +55 (11) 3038-6464
Fax: +55 (11) 3038-6508
http://www.primesys.com.br
=20
=20
=20
=20

> -----Mensagem original-----
> De: per...@li...=20
> [mailto:per...@li...] Em nome=20
> de Wilson Pires Jr
> Enviada em: quinta-feira, 26 de agosto de 2004 16:56
> Para: 'Cook, Garry'; per...@li...
> Assunto: RE: [Perfparse-users] nagios restarting
>=20
>=20
> > I didn't see this original message on the PerfParse User's=20
> mailing list.
> > Did this thread begin somewhere else, or am I missing some messages?
>=20
> [Wilson Pires Jr]
> Garry, the original message was posted on PP User's mailing list.
>=20
> >=20
> > per...@li... wrote:
> > >> Hi all.
> > >>
> > >> I've observed my nagios restart every perfparse.sh run. I use
> > >> perfparse-0.99.07
> >=20
> > You should upgrade to 0.99.09. It may or may not help with=20
> this issue,=20
> > but there are a couple of other bugfixes/enhancements=20
> available in the=20
> > latest version. And don't forget to run=20
> > '/<path_to>/nagios/bin/perfparse-db-tool --update' after=20
> each upgrade...
> >=20
>=20
> [Wilson Pires Jr]
> I'm upgrading, but I can't run the upgrade:
> Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"
> I'm logged as root. The perfparse.cfg owner is root. What=20
> mistake am I doing?
>=20
> >=20
> > >> [26-08-2004 12:35:00] Nagios 1.2 starting... (PID=3D12443)
> > >> [26-08-2004 12:35:00] Caught SIGHUP, restarting...
> > >>
> > >> Is this ok? If so, why is needed nagios restarting?
> > >
> > > If you are using --delete* option, yes, perfparse sends=20
> some SIGHUP=20
> > > signal to nagios to ask for restart and use a new serviceperf.log=20
> > > file.
> > > Otherwise, nothing to see with perfparse.
> >=20
> > I've seen some postings (on Nagios Users or Devel lists)=20
> about Nagios=20
> > restarting when sent a HUP, whereas it should only re-read=20
> it's config=20
> > files. I don't remember exactly, but I think the original=20
> posters may=20
> > have been using Nagios 2.0 and/or Fedora Linux Distro. Are=20
> you using=20
> > either of these? What versions of Nagios/Linux are you using?
> >=20
>=20
> [Wilson Pires Jr]
> I run:
> nagios 1.2
> redhat 9
> plugin 1.4a
>=20
> >=20
> > >> I'm trying to figure out why my nagios stops working after few=20
> > >> hours and I'd like to know if this "nagios restarting" has some=20
> > >> relation to "nagios stopping".
> > >
> > > perfparse does not ask nagios to stop, but only to start=20
> writing to=20
> > > a new serviceperf.log file, which also mean restarting, but not=20
> > > stopping.
> > > In your log, strange that nagios starts and restarts at the same=20
> > > time. SIGHUP caught by change at that time ?
> >=20
> > If Nagios fails to HUP properly, it could be leaving you with more=20
> > than one Nagios process running. This can sometimes cause odd=20
> > behavior, like checks not being run and/or notifications=20
> not being sent.
> > Is Nagios actually shutting down? Or is it running but not=20
> performing=20
> > actions as expected?
> >=20
>=20
> [Wilson Pires Jr]
> As you said below nagios remains running, bur stops performing checks.
>=20
> >=20
> > >> When nagios stops its checks, it always has a zombie process.
> > >
> > > How long do they live ? (just asking for if others can help :)
> > >
> > > Yves
> > >
> > >>
> > >> Regards,
> > >>
> > >> Wilson
> >=20
> > It looks like you've already answered the question that I=20
> asked above.
> > So, Nagios is running but not performing checks, correct?=20
> This is most=20
> > likely related to the zombie/second running Nagios process.=20
> This may=20
> > be due to the HUP sent by PerfParse, but not exactly caused=20
> by it. A=20
> > HUP sent to Nagios by PP, command line, or some other=20
> process should=20
> > be interpreted correctly and not cause this problem. If it's not=20
> > working correctly, I believe that the problem is related to Nagios=20
> > itself. If you can provide the version information that I=20
> asked above=20
> > (Nagios/Linux), I can look back through the archives and see what=20
> > information I can find. Or, you could do this if you are on Nagios=20
> > and/or Nagios Devel lists.
> >=20
>=20
> [Wilson Pires Jr]
> Ok. The versions are above (nagios 1.2, rh9). I've used=20
> nagios-1-x-cvs trying to correct the problem, but it persists.
> If you can, I ask your tips since I don't know what HUP or=20
> SIGHUP exactly does.
>=20
> > Garry W. Cook, CCNA
> > Network Infrastructure Manager
> > MACTEC, Inc. - http://www.mactec.com/
> > 303.308.6228 (Office) - 720.220.1862 (Mobile)
> >=20
> >=20
> > -------------------------------------------------------
> > SF.Net email is sponsored by Shop4tech.com-Lowest price on=20
> Blank Media=20
> > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for=20
> only $33 Save=20
> > 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > _______________________________________________
> > Perfparse-users mailing list
> > Per...@li...
> > https://lists.sourceforge.net/lists/listinfo/perfparse-users
>=20
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on=20
> Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic=20
> DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free=20
> Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>=20

RES: [Possible SPAM] - RE: [Perfparse-users] nagios restarting - Found word(s) inkjet cartridges in the Text body

[Paulo A. G. F. <pau...@pr...>]

Wilson:

As far as I could tell in my system, excluding the --delete option just
keeps serviceperf.log indefinitely, until you run perfparse
--delete-service-log manually.

OTOH, on a system like yours, with a reasonable number of
hosts/services, the serviceperf.log file will grow really big, and
sometime it will be neccessary delete (or compress) it and recreate.=20

About your problems with nagios defuncts, e-mail me in pvt and we can
discuss the issue. I had it before and it's not related to PerfParse.

[]'s
Paulo

Paulo Afonso Graner Fessel
Administrador de Ambiente e Sistemas UNIX
pau...@pr...
OWT
Fone: +55 (11) 3038-6464
Fax: +55 (11) 3038-6508
http://www.primesys.com.br
=20
=20
=20
=20

> -----Mensagem original-----
> De: per...@li...=20
> [mailto:per...@li...] Em nome=20
> de Wilson Pires Jr
> Enviada em: quinta-feira, 26 de agosto de 2004 15:18
> Para: 'Yves Mettier'; per...@li...
> Assunto: [Possible SPAM] - RE: [Perfparse-users] nagios=20
> restarting - Found word(s) inkjet cartridges in the Text body
>=20
> >> Hi all.
> >>
> >> I've observed my nagios restart every perfparse.sh run. I use
> >> perfparse-0.99.07
> >>
> >> [26-08-2004 12:35:00] Nagios 1.2 starting... (PID=3D12443)
> >> [26-08-2004 12:35:00] Caught SIGHUP, restarting...
> >>
> >> Is this ok? If so, why is needed nagios restarting?
>=20
> > If you are using --delete* option, yes, perfparse sends some SIGHUP=20
> > signal to nagios to ask for restart and use a new=20
> serviceperf.log file.
> Otherwise, > nothing to see with perfparse.
>=20
> Yes. I use --delete (default into perfparse.sh). Is there any=20
> advantage or disadvantage using this option?
>=20
> The problem I see restarting nagios every 10 minutes (in my=20
> case with pp), is that nagios log grows too much, since I get=20
> around 700 services and hosts alerts saying "OK". (I monitor=20
> 100 hosts and 600 services).
>=20
> >> I'm trying to figure out why my nagios stops working after=20
> few hours=20
> >> and I'd like to know if this "nagios restarting" has some=20
> relation to=20
> >> "nagios stopping".
>=20
> > perfparse does not ask nagios to stop, but only to start=20
> writing to a=20
> > new serviceperf.log file, which also mean restarting, but=20
> not stopping.
> > In your log, strange that nagios starts and restarts at the=20
> same time.=20
> > SIGHUP caught by change at that time ?
>=20
> Every 10 minutes I get the same situation:
>=20
> [26-08-2004 14:40:11] SERVICE ALERT:=20
> bbrdcsrv1;RADIUS;OK;HARD;1; Radius.exe:
> Running
> [26-08-2004 14:40:11] SERVICE ALERT:=20
> bbrdcsrv1;Drive_C;OK;HARD;1;C::\ -
> total: 2.93 Gb - used: 1.07 Gb (36%) - free 1.87 Gb (64%)
> [26-08-2004 14:40:11] HOST ALERT: bbrdcsrv1;UP;HARD;1;(Host=20
> assumed to be
> up)
> [26-08-2004 14:40:11] SERVICE ALERT:=20
> bbr002363sis;HTTP;OK;HARD;1;HTTP OK
> HTTP/1.1 200 OK - 3970 bytes in 0.316 seconds
> [26-08-2004 14:40:11] HOST ALERT:=20
> bbr002363sis;UP;HARD;1;(Host assumed to be
> up)
> [26-08-2004 14:40:01] Nagios 1.2 starting... (PID=3D12443)
> [26-08-2004 14:40:01] Caught SIGHUP, restarting...
> [26-08-2004 14:39:41] SERVICE ALERT:=20
> bbrsrdir1;Drive_E;WARNING;SOFT;5;E::\ -
> total: 19.53 Gb - used: 19.00 Gb (97%) - free 0.53 Gb (3%)
> [26-08-2004 14:39:41] SERVICE ALERT:=20
> spossra;PING;CRITICAL;SOFT;1;PING CRITICAL - Packet loss =3D=20
> 0%, RTA =3D 20.24 ms
> [26-08-2004 14:39:31] SERVICE ALERT:
> rjo1601a;CPU5m-Cisco;WARNING;SOFT;3;SNMP WARNING - *32*
>=20
> As you can see "Caught SIGHUP, restarting..." and "Nagios 1.2=20
> restarting..."
> at the same time. And then, nagios starts to log the 700 "OK".
>=20
>=20
> >> When nagios stops its checks, it always has a zombie process.
>=20
> > How long do they live ? (just asking for if others can help :)
>=20
> nagios runs from 2 to 6 hours, then stops checking:
>=20
> Process Status Information
> Process Status:   WARNING  =20
> Check Command Output:  Nagios problem: located 14 processes,=20
> status log updated 260136 seconds ago =20
>=20
> So, with ps -aux I see a nagios <defunct> process. If I don't=20
> killall -9 nagios, the defunct process remain for days and=20
> nagios doesn't check anything.
>=20
> I don't know how to trouble this situation. Could anybody help me?
>=20
> > Yves
>=20
> >>
> >> Regards,
> >>
> >> Wilson
> >>
> >>
> >
> >
> > -------------------------------------------------------
> > SF.Net email is sponsored by Shop4tech.com-Lowest price on=20
> Blank Media=20
> > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for=20
> only $33 Save=20
> > 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> > _______________________________________________
> > Perfparse-users mailing list
> > Per...@li...
> > https://lists.sourceforge.net/lists/listinfo/perfparse-users
> >
> >
>=20
>=20
> --=20
> - Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
> - GPG key     - http://ymettier.free.fr/gpg.txt                    -
> - Maitretarot - http://www.nongnu.org/maitretarot/                 -
> - GTKtalog    - http://www.nongnu.org/gtktalog/                    -
>=20
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on=20
> Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic=20
> DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free=20
> Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>=20
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on=20
> Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic=20
> DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free=20
> Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>=20

RE: [Perfparse-users] nagios restarting

[Wilson P. J. <wp....@te...>]

> I didn't see this original message on the PerfParse User's mailing list.
> Did this thread begin somewhere else, or am I missing some messages?

[Wilson Pires Jr] 
Garry, the original message was posted on PP User's mailing list.

> 
> per...@li... wrote:
> >> Hi all.
> >>
> >> I've observed my nagios restart every perfparse.sh run. I use
> >> perfparse-0.99.07
> 
> You should upgrade to 0.99.09. It may or may not help with this issue,
> but there are a couple of other bugfixes/enhancements available in the
> latest version. And don't forget to run
> '/<path_to>/nagios/bin/perfparse-db-tool --update' after each upgrade...
> 

[Wilson Pires Jr] 
I'm upgrading, but I can't run the upgrade:
Error, can't open configuation file: "//usr/local/etc/perfparse.cfg"
I'm logged as root. The perfparse.cfg owner is root. What mistake am I
doing?

> 
> >> [26-08-2004 12:35:00] Nagios 1.2 starting... (PID=12443)
> >> [26-08-2004 12:35:00] Caught SIGHUP, restarting...
> >>
> >> Is this ok? If so, why is needed nagios restarting?
> >
> > If you are using --delete* option, yes, perfparse sends some SIGHUP
> > signal to nagios to ask for restart and use a new serviceperf.log
> > file.
> > Otherwise, nothing to see with perfparse.
> 
> I've seen some postings (on Nagios Users or Devel lists) about Nagios
> restarting when sent a HUP, whereas it should only re-read it's config
> files. I don't remember exactly, but I think the original posters may
> have been using Nagios 2.0 and/or Fedora Linux Distro. Are you using
> either of these? What versions of Nagios/Linux are you using?
> 

[Wilson Pires Jr] 
I run:
nagios 1.2
redhat 9
plugin 1.4a

> 
> >> I'm trying to figure out why my nagios stops working after few hours
> >> and I'd like to know if this "nagios restarting" has some relation
> >> to "nagios stopping".
> >
> > perfparse does not ask nagios to stop, but only to start
> > writing to a new
> > serviceperf.log file, which also mean restarting, but not stopping.
> > In your log, strange that nagios starts and restarts at the
> > same time. SIGHUP caught by
> > change at that time ?
> 
> If Nagios fails to HUP properly, it could be leaving you with more than
> one Nagios process running. This can sometimes cause odd behavior, like
> checks not being run and/or notifications not being sent.
> Is Nagios actually shutting down? Or is it running but not performing
> actions as expected?
> 

[Wilson Pires Jr] 
As you said below nagios remains running, bur stops performing checks.

> 
> >> When nagios stops its checks, it always has a zombie process.
> >
> > How long do they live ? (just asking for if others can help :)
> >
> > Yves
> >
> >>
> >> Regards,
> >>
> >> Wilson
> 
> It looks like you've already answered the question that I asked above.
> So, Nagios is running but not performing checks, correct? This is most
> likely related to the zombie/second running Nagios process. This may be
> due to the HUP sent by PerfParse, but not exactly caused by it. A HUP
> sent to Nagios by PP, command line, or some other process should be
> interpreted correctly and not cause this problem. If it's not working
> correctly, I believe that the problem is related to Nagios itself. If
> you can provide the version information that I asked above
> (Nagios/Linux), I can look back through the archives and see what
> information I can find. Or, you could do this if you are on Nagios
> and/or Nagios Devel lists.
> 

[Wilson Pires Jr] 
Ok. The versions are above (nagios 1.2, rh9). I've used nagios-1-x-cvs
trying to correct the problem, but it persists.
If you can, I ask your tips since I don't know what HUP or SIGHUP exactly
does.

> Garry W. Cook, CCNA
> Network Infrastructure Manager
> MACTEC, Inc. - http://www.mactec.com/
> 303.308.6228 (Office) - 720.220.1862 (Mobile)
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users

RE: [Perfparse-users] nagios restarting

[Wilson P. J. <wp....@te...>]

>> Hi all.
>>
>> I've observed my nagios restart every perfparse.sh run. I use
>> perfparse-0.99.07
>>
>> [26-08-2004 12:35:00] Nagios 1.2 starting... (PID=12443)
>> [26-08-2004 12:35:00] Caught SIGHUP, restarting...
>>
>> Is this ok? If so, why is needed nagios restarting?

> If you are using --delete* option, yes, perfparse sends some SIGHUP signal
> to nagios to ask for restart and use a new serviceperf.log file.
Otherwise, > nothing to see with perfparse.

Yes. I use --delete (default into perfparse.sh). Is there any advantage or
disadvantage using this option?

The problem I see restarting nagios every 10 minutes (in my case with pp),
is that nagios log grows too much, since I get around 700 services and hosts
alerts saying "OK". (I monitor 100 hosts and 600 services).

>> I'm trying to figure out why my nagios stops working after few hours and
>> I'd like to know if this "nagios restarting" has some relation to "nagios
>> stopping".

> perfparse does not ask nagios to stop, but only to start writing to a new
> serviceperf.log file, which also mean restarting, but not stopping.
> In your log, strange that nagios starts and restarts at the same time. 
> SIGHUP caught by change at that time ?

Every 10 minutes I get the same situation:

[26-08-2004 14:40:11] SERVICE ALERT: bbrdcsrv1;RADIUS;OK;HARD;1; Radius.exe:
Running
[26-08-2004 14:40:11] SERVICE ALERT: bbrdcsrv1;Drive_C;OK;HARD;1;C::\ -
total: 2.93 Gb - used: 1.07 Gb (36%) - free 1.87 Gb (64%)
[26-08-2004 14:40:11] HOST ALERT: bbrdcsrv1;UP;HARD;1;(Host assumed to be
up)
[26-08-2004 14:40:11] SERVICE ALERT: bbr002363sis;HTTP;OK;HARD;1;HTTP OK
HTTP/1.1 200 OK - 3970 bytes in 0.316 seconds
[26-08-2004 14:40:11] HOST ALERT: bbr002363sis;UP;HARD;1;(Host assumed to be
up)
[26-08-2004 14:40:01] Nagios 1.2 starting... (PID=12443)
[26-08-2004 14:40:01] Caught SIGHUP, restarting...
[26-08-2004 14:39:41] SERVICE ALERT: bbrsrdir1;Drive_E;WARNING;SOFT;5;E::\ -
total: 19.53 Gb - used: 19.00 Gb (97%) - free 0.53 Gb (3%)
[26-08-2004 14:39:41] SERVICE ALERT: spossra;PING;CRITICAL;SOFT;1;PING
CRITICAL - Packet loss = 0%, RTA = 20.24 ms
[26-08-2004 14:39:31] SERVICE ALERT:
rjo1601a;CPU5m-Cisco;WARNING;SOFT;3;SNMP WARNING - *32*

As you can see "Caught SIGHUP, restarting..." and "Nagios 1.2 restarting..."
at the same time. And then, nagios starts to log the 700 "OK".


>> When nagios stops its checks, it always has a zombie process.

> How long do they live ? (just asking for if others can help :)

nagios runs from 2 to 6 hours, then stops checking:

Process Status Information
Process Status:   WARNING   
Check Command Output:  Nagios problem: located 14 processes, status log
updated 260136 seconds ago  

So, with ps -aux I see a nagios <defunct> process. If I don't killall -9
nagios, the defunct process remain for days and nagios doesn't check
anything.

I don't know how to trouble this situation. Could anybody help me?

> Yves

>>
>> Regards,
>>
>> Wilson
>>
>>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>
>


-- 
- Homepage    - http://ymettier.free.fr - http://www.logicacmg.com -
- GPG key     - http://ymettier.free.fr/gpg.txt                    -
- Maitretarot - http://www.nongnu.org/maitretarot/                 -
- GTKtalog    - http://www.nongnu.org/gtktalog/                    -





-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
Perfparse-users mailing list
Per...@li...
https://lists.sourceforge.net/lists/listinfo/perfparse-users

RE: [Perfparse-users] re: deletion policys

[James O. <jo...@re...>]

I'm still having this issue.  Does anyone know what the foreign key that it
is referring to is?  Or how to find out?   Here's the latest output:



[jochs@mon-01 bin]$ 
[jochs@mon-01 bin]$ ./perfparse-db-tool --update
[jochs@mon-01 bin]$ ./perfparse-db-purge -r 
"UPDATE perfdata_service_metric SET bin_delete_policy_name = 'Bin Default'
WHERE bin_delete_policy_type = 'template' AND bin_delete_policy_name IS
NULL" failed:
Cannot add or update a child row: a foreign key constraint fails
[jochs@mon-01 bin]$ ./perfparse-db-purge --show_config
DB_User =        "nagios"
DB_Name =        "nagios"
DB_Pass =        "n4g10s"
DB_Host =        "127.0.0.1"
Drop_File =      "/tmp/perfparse.drop"
Service_Log =    "/usr/local/nagios/var/serviceperf.log"
Host_Log =       "/usr/local/nagios/var/hostperf.log"
Dummy_Hostname = "dummy"
Delete_Service_Log =         "No"
Delete_Host_Log =            "No"
Nagios_Lock =    "/usr/local/nagios/var/nagios.lock"
Lock_File =      "/var/lock/perfparse.lock"
Be_Silent =      "no"
Do_Report =      "no"
Accept_Odd_Chars_in_Label =      "no"
Default_user_permissions_Policy = "rw"
Default_user_permissions_Host_groups = "rw"
[jochs@mon-01 bin]$

-----Original Message-----
From: Tim Brazil [mailto:br...@se...] 
Sent: Wednesday, August 25, 2004 2:43 PM
To: James Ochs
Cc: per...@li...
Subject: Re: [Perfparse-users] re: deletion policys

Hi James

The only other thing I did was changed to the newer sample version 
perfparse.cfg.

Here are some thoughts...
Did you see any "upgrade" output from ./perfparse-db-tool --update when 
you ran it indicating something actually happened?
Is the binary from  perfparse-db-tool the new one that was built with 
0.99.09.
I initially didn't "configure" correctly which "make install"ed 
perfparse-db-tool  to the wrong directory (/usr/local/bin) which left 
the older version of perfparse-db-tool  in place under /usr/local/nagios/bin

Tim

James Ochs wrote:

> Upgrading to 0.99.09 didn't fix this problem for me.  Nor did running 
> perfparse-db-tool --update.
>
> James
>
> -----Original Message-----
> From: Tim Brazil [mailto:br...@se...]
> Sent: Wednesday, August 25, 2004 1:39 PM
> Cc: per...@li...
> Subject: Re: [Perfparse-users] re: deletion policys
>
> Thanks Garry
> I updated to 0.99.09, ran ./perfparse-db-tool --update and it fixed my
> problem.
>
> Tim
>
> Cook, Garry wrote:
>
> >per...@li... wrote:
> > 
> >
> >>I have been watching this post becasue I too am experiencing this
> >>problem.  It's been about 1 month since I've started collection
> >>performance statistics and I'd like to do some cleanup. I
> >>cannot create
> >>deletion policies due to the "Cannot add or update a child row: a
> >>foreign key constraint fails"  error.
> >>Any ideas on how to rectify this. I also ran the ./perfparse-db-tool
> >>--update to see whether it would correct the problem. It
> >>didn't change
> >>anything. I have Version 0.99.05. Schema Version 0.12
> >>
> >>Thanks in advance
> >>Tim
> >>   
> >>
> >
> >I believe that this bug was fixed in Version 0.99.08, but it might have
> >been 0.99.09. Either way, you should definitely be using the latest
> >stable version -> 0.99.09.
> >I thought that I saw someone else post about this issue and say that the
> >version upgrade did not fix it for them. However, they did not mention
> >if they ran 'perfparse-db-tool --update' after upgrading PerfParse.
> >
> >Everyone needs to realize something very important:
> >With new versions, there are changes to the PerfParse code and there are
> >sometimes changes made to the MySQL DB as well. You need to use the
> >perfparse-db-tool to update your DB with each upgrade. This tool will be
> >installed in your '<path_to>/nagios/bin/' directory, run it with the
> >'--update' argument to ensure that DB changes are made properly.
> >
> >Garry W. Cook, CCNA
> >Network Infrastructure Manager
> >MACTEC, Inc. - http://www.mactec.com/
> >303.308.6228 (Office) - 720.220.1862 (Mobile)
> >
> >
> >-------------------------------------------------------
> >SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> >100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> >Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> >http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> >_______________________________________________
> >Perfparse-users mailing list
> >Per...@li...
> >https://lists.sourceforge.net/lists/listinfo/perfparse-users
> > 
> >
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>

[Perfparse-users] Undocumented Nagios Feature

[Cook, G. <GW...@ma...>]

I've come across an undocumented (at least I have not seen it anywhere)
Nagios feature in a thread on the Nagios Users mailing list.
Running Nagios with the '-m' argument will show you some information
about how Nagios was compiled/configured, including Performance Data and
whether or not it is compiled with the file based method or default.

I should add this to the web site docs, it could be useful for
troubleshooting PP.

From the thread that I've seen, this feature does not appear to be
available in Nagios 2.0. :(

Example Output:

/usr/local/nagios/etc: sudo ../bin/nagios -m nagios.cfg =20

Nagios 1.2
Copyright (c) 1999-2004 Ethan Galstad (na...@na...)
Last Modified: 02-02-2004
License: GPL

External Data I/O
-----------------
Object Data:      TEMPLATE
Status Data:      DEFAULT
Retention Data:   DEFAULT
Comment Data:     DEFAULT
Downtime Data:    DEFAULT
Performance Data: FILE

Options
-------
* Embedded Perl compiler (With caching)=20

Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)=20

RE: [Perfparse-users] nagios restarting

[Cook, G. <GW...@ma...>]

I didn't see this original message on the PerfParse User's mailing list.
Did this thread begin somewhere else, or am I missing some messages?

per...@li... wrote:
>> Hi all.
>>=20
>> I've observed my nagios restart every perfparse.sh run. I use
>> perfparse-0.99.07=20

You should upgrade to 0.99.09. It may or may not help with this issue,
but there are a couple of other bugfixes/enhancements available in the
latest version. And don't forget to run
'/<path_to>/nagios/bin/perfparse-db-tool --update' after each upgrade...


>> [26-08-2004 12:35:00] Nagios 1.2 starting... (PID=3D12443)
>> [26-08-2004 12:35:00] Caught SIGHUP, restarting...
>>=20
>> Is this ok? If so, why is needed nagios restarting?
>=20
> If you are using --delete* option, yes, perfparse sends some SIGHUP
> signal to nagios to ask for restart and use a new serviceperf.log
> file.=20
> Otherwise, nothing to see with perfparse.

I've seen some postings (on Nagios Users or Devel lists) about Nagios
restarting when sent a HUP, whereas it should only re-read it's config
files. I don't remember exactly, but I think the original posters may
have been using Nagios 2.0 and/or Fedora Linux Distro. Are you using
either of these? What versions of Nagios/Linux are you using?


>> I'm trying to figure out why my nagios stops working after few hours
>> and I'd like to know if this "nagios restarting" has some relation
>> to "nagios stopping".
>
> perfparse does not ask nagios to stop, but only to start
> writing to a new
> serviceperf.log file, which also mean restarting, but not stopping.
> In your log, strange that nagios starts and restarts at the
> same time. SIGHUP caught by
> change at that time ?

If Nagios fails to HUP properly, it could be leaving you with more than
one Nagios process running. This can sometimes cause odd behavior, like
checks not being run and/or notifications not being sent.
Is Nagios actually shutting down? Or is it running but not performing
actions as expected?


>> When nagios stops its checks, it always has a zombie process.
>=20
> How long do they live ? (just asking for if others can help :)
>=20
> Yves
>=20
>>=20
>> Regards,
>>=20
>> Wilson

It looks like you've already answered the question that I asked above.
So, Nagios is running but not performing checks, correct? This is most
likely related to the zombie/second running Nagios process. This may be
due to the HUP sent by PerfParse, but not exactly caused by it. A HUP
sent to Nagios by PP, command line, or some other process should be
interpreted correctly and not cause this problem. If it's not working
correctly, I believe that the problem is related to Nagios itself. If
you can provide the version information that I asked above
(Nagios/Linux), I can look back through the archives and see what
information I can find. Or, you could do this if you are on Nagios
and/or Nagios Devel lists.

Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)