Menu
▾
▴
perfparse-users
|
From: Eric G. <er...@in...> - 2008-05-01 20:04:28
|
good morning, perfparse people. i'm setting up perfparse 0.105.6 with nagios 3.0.1 on a centOS 5 machine. it is not working. i'm using the "pipe to perfparse" method as described in the install guide. nothing's getting in to the database, and it seems to be FIFO related. observe: [root@nagios01a var]# /usr/local/nagios/bin/perfparse-log2mysql -e error.txt [root@nagios01a var]# cat error.txt cat: error.txt: No such file or directory [root@nagios01a var]# cat error.txt.20080501.log 2008/05/01 12:59:55 [perfparse-log2any.c:157 24175 ] FIFO not authorized as the perf data input source ...now, my googling has shown that this is generally caused by either an error in perfparse.cfg, or incorrect permissions in /usr/local/nagios/var/perfdata-service.log. here's the relevent line in perfparse.cfg: Service_Log = "|/usr/local/nagios/var/perfdata-service.log" ...which i'm pretty confident is correct, and here's the permissions: # ls -l /usr/local/nagios/var/perfdata-service.log -rw-r--r-- 1 nagios nagios 198 May 1 13:03 /usr/local/nagios/var/perfdata-service.log i've been messing with this for days, recompiled like five times, and i'm at the end of my rope. help? |
|
From: Florian G. <fl...@bi...> - 2008-05-02 05:16:20
|
Hi, the pipe method only works with the perfparse daemon (perfparsed) running as a background process. It cares about cleaning the pipe from outstanding data. If you want to use cron and perfparse-log2mysql to get the data into mysql periodically then you have to use a regular file. The file seems to be a regular file too, because a pipe has 0 Bytes and a "p" in the permission strings. Example: prw-r----- 1 nagios nagios 0 Mar 1 10:49 serviceperf.log http://perfparse.de/tiki-index.php?page=Minimal%20environment%20nagios%202.9%20and%20perfparsed%20reading%20from%20a%20pipe is a example how to configure perfparsed and the pipe method. Flo Eric Gottesman schrieb: > good morning, perfparse people. > > i'm setting up perfparse 0.105.6 with nagios 3.0.1 on a centOS 5 machine. > > it is not working. > > i'm using the "pipe to perfparse" method as described in the install guide. > > nothing's getting in to the database, and it seems to be FIFO related. > observe: > > [root@nagios01a var]# /usr/local/nagios/bin/perfparse-log2mysql -e error.txt > [root@nagios01a var]# cat error.txt > cat: error.txt: No such file or directory > [root@nagios01a var]# cat error.txt.20080501.log > 2008/05/01 12:59:55 [perfparse-log2any.c:157 24175 ] FIFO not > authorized as the perf data input source > > > ...now, my googling has shown that this is generally caused by either an > error in perfparse.cfg, or incorrect permissions in > /usr/local/nagios/var/perfdata-service.log. here's the relevent line in > perfparse.cfg: > > Service_Log = "|/usr/local/nagios/var/perfdata-service.log" > > ...which i'm pretty confident is correct, and here's the permissions: > > # ls -l /usr/local/nagios/var/perfdata-service.log > -rw-r--r-- 1 nagios nagios 198 May 1 13:03 > /usr/local/nagios/var/perfdata-service.log > > i've been messing with this for days, recompiled like five times, and > i'm at the end of my rope. help? > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > > > ------------------------------------------------------------------------ > > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users |
|
From: Eric G. <er...@in...> - 2008-05-02 19:13:31
|
Thanks!!! My predecessor unfortunately left me with some contrary information (and somehow appears to have made it work on a previous machine in the way that he described...) but this seems to have fixed it. I'm now using perfparsed and the database is filling up... HOWEVER! The web interface still isn't working. I made the modifications to side.html as suggested, I click the button and it brings me to a perfparse page, but no hosts show up. I manually inserted my hostgroups in to perfdata_host_group and updated perfdata_host to reflect the correct hostgroups (they were blank for whatever reason, although the hosts populated as expected,) and I now have hostgroups available in the "Select Host Group" dropdown, but no hosts appear. Furthermore, if I hit one of the sorting buttons (the up/down arrows,) I get the following: An error occured with the SQL: "SELECT perfdata_host.host_name, perfdata_service.service_description, perfdata_service_metric.metric, perfdata_service_metric.unit, perfdata_service_bin.value, perfdata_service_bin.state, perfdata_service_bin.ctime FROM perfdata_host, perfdata_service, perfdata_service_metric, perfdata_service_bin WHERE perfdata_host.host_name = perfdata_service.host_name AND perfdata_service_metric.host_name = perfdata_service.host_name AND perfdata_service_metric.service_description = perfdata_service.service_description AND perfdata_service_bin.id = perfdata_service_metric.last_perfdata_bin AND group_name = 'BIZI' ORDER BY _ DESC" Failure Message: "Unknown column '_' in 'order clause'" Some of the other options at the main menu work better, or at least differently. If I go to "Raw plugin data," I see all of my hosts and the appropriate checks, but the plugin output column just says $OUTPUT$ for all of them. Any ideas? -----Original Message----- From: Florian Gleixner [mailto:fl...@bi...] Sent: Thursday, May 01, 2008 10:16 PM To: Eric Gottesman Cc: per...@li... Subject: Re: [Perfparse-users] FIFO issues Hi, the pipe method only works with the perfparse daemon (perfparsed) running as a background process. It cares about cleaning the pipe from outstanding data. If you want to use cron and perfparse-log2mysql to get the data into mysql periodically then you have to use a regular file. The file seems to be a regular file too, because a pipe has 0 Bytes and a "p" in the permission strings. Example: prw-r----- 1 nagios nagios 0 Mar 1 10:49 serviceperf.log http://perfparse.de/tiki-index.php?page=Minimal%20environment%20nagios%2 02.9%20and%20perfparsed%20reading%20from%20a%20pipe is a example how to configure perfparsed and the pipe method. Flo Eric Gottesman schrieb: > good morning, perfparse people. > > i'm setting up perfparse 0.105.6 with nagios 3.0.1 on a centOS 5 machine. > > it is not working. > > i'm using the "pipe to perfparse" method as described in the install guide. > > nothing's getting in to the database, and it seems to be FIFO related. > observe: > > [root@nagios01a var]# /usr/local/nagios/bin/perfparse-log2mysql -e > error.txt [root@nagios01a var]# cat error.txt > cat: error.txt: No such file or directory [root@nagios01a var]# cat > error.txt.20080501.log > 2008/05/01 12:59:55 [perfparse-log2any.c:157 24175 ] FIFO not > authorized as the perf data input source > > > ...now, my googling has shown that this is generally caused by either > an error in perfparse.cfg, or incorrect permissions in > /usr/local/nagios/var/perfdata-service.log. here's the relevent line > in > perfparse.cfg: > > Service_Log = "|/usr/local/nagios/var/perfdata-service.log" > > ...which i'm pretty confident is correct, and here's the permissions: > > # ls -l /usr/local/nagios/var/perfdata-service.log > -rw-r--r-- 1 nagios nagios 198 May 1 13:03 > /usr/local/nagios/var/perfdata-service.log > > i've been messing with this for days, recompiled like five times, and > i'm at the end of my rope. help? > > > ---------------------------------------------------------------------- > -- > > ---------------------------------------------------------------------- > --- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com > /javaone > > > ---------------------------------------------------------------------- > -- > > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users |
|
From: Florian G. <fl...@re...> - 2008-05-02 19:33:54
|
Eric Gottesman wrote: > Failure Message: > > "Unknown column '_' in 'order clause'" > Maybe a bug. But you use a old Version of Perfparse. Use 0.106.1 or if you dare, try the cvs snapshots. > > > Some of the other options at the main menu work better, or at least > differently. If I go to "Raw plugin data," I see all of my hosts and the > appropriate checks, but the plugin output column just says $OUTPUT$ for > all of them. > > Any ideas? > Nagios changed the internal Macro definitions. Before Nagios 2.X it was called $OUTPUT. Now it is called $SERVICEOUTPUT i think. Check your process_perfdata command. http://perfparse.de/tiki-view_forum_thread.php?comments_parentId=57&forumId=1&highlight=OUTPUT Flo > > > > -----Original Message----- > From: Florian Gleixner [mailto:fl...@bi...] > Sent: Thursday, May 01, 2008 10:16 PM > To: Eric Gottesman > Cc: per...@li... > Subject: Re: [Perfparse-users] FIFO issues > > Hi, > > the pipe method only works with the perfparse daemon (perfparsed) > running as a background process. It cares about cleaning the pipe from > outstanding data. If you want to use cron and perfparse-log2mysql to get > the data into mysql periodically then you have to use a regular file. > The file seems to be a regular file too, because a pipe has 0 Bytes and > a "p" in the permission strings. Example: > prw-r----- 1 nagios nagios 0 Mar 1 10:49 serviceperf.log > > http://perfparse.de/tiki-index.php?page=Minimal%20environment%20nagios%2 > 02.9%20and%20perfparsed%20reading%20from%20a%20pipe > > is a example how to configure perfparsed and the pipe method. > > Flo > > Eric Gottesman schrieb: >> good morning, perfparse people. >> >> i'm setting up perfparse 0.105.6 with nagios 3.0.1 on a centOS 5 > machine. >> >> it is not working. >> >> i'm using the "pipe to perfparse" method as described in the install > guide. >> >> nothing's getting in to the database, and it seems to be FIFO related. > >> observe: >> >> [root@nagios01a var]# /usr/local/nagios/bin/perfparse-log2mysql -e >> error.txt [root@nagios01a var]# cat error.txt >> cat: error.txt: No such file or directory [root@nagios01a var]# cat >> error.txt.20080501.log >> 2008/05/01 12:59:55 [perfparse-log2any.c:157 24175 ] FIFO not >> authorized as the perf data input source >> >> >> ...now, my googling has shown that this is generally caused by either >> an error in perfparse.cfg, or incorrect permissions in >> /usr/local/nagios/var/perfdata-service.log. here's the relevent line >> in >> perfparse.cfg: >> >> Service_Log = "|/usr/local/nagios/var/perfdata-service.log" >> >> ...which i'm pretty confident is correct, and here's the permissions: >> >> # ls -l /usr/local/nagios/var/perfdata-service.log >> -rw-r--r-- 1 nagios nagios 198 May 1 13:03 >> /usr/local/nagios/var/perfdata-service.log >> >> i've been messing with this for days, recompiled like five times, and >> i'm at the end of my rope. help? >> >> >> ---------------------------------------------------------------------- >> -- >> >> ---------------------------------------------------------------------- >> --- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference >> Don't miss this year's exciting event. There's still time to save > $100. >> Use priority code J8TL2D2. >> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com >> /javaone >> >> >> ---------------------------------------------------------------------- >> -- >> >> _______________________________________________ >> Perfparse-users mailing list >> Per...@li... >> https://lists.sourceforge.net/lists/listinfo/perfparse-users > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users |
|
From: Eric G. <er...@in...> - 2008-05-03 01:32:07
|
I upgraded to .106.1, nothing has changed. The $SERVICEOUTPUT$ thing worked though, thanks. So now, I'm still seeing nothing in my host list. I tried running the query from my original message in mysql manually without the order by, and nothing came up! Here's the query: SELECT perfdata_host.host_name, perfdata_service.service_description, perfdata_service_metric.metric, perfdata_service_metric.unit, perfdata_service_bin.value, perfdata_service_bin.state, perfdata_service_bin.ctime FROM perfdata_host, perfdata_service, perfdata_service_metric, perfdata_service_bin WHERE perfdata_host.host_name = perfdata_service.host_name AND perfdata_service_metric.host_name = perfdata_service.host_name AND perfdata_service_metric.service_description = perfdata_service.service_description AND perfdata_service_bin.id = perfdata_service_metric.last_perfdata_bin; The database is definitely populating, but a couple of those tables are still empty- specifically perfdata_service_metric and perfdata_service_bin. There's also a really weird thing where in the "edit host group lists" page, the remove button is broken and shows up as follows: &host_name=[hostname]">Remove I found where it's not happening in the code. The following snippet is not executing in cgi_host_groups.c: snprintf(sDelete, 255, "<a href=\"%s?edit_host_list=1&delete=1&group_name=%s", sProgName, url_encode(sGroupName)); My guess at this point is that I'm missing a package or two and it didn't check properly, but I'm not sure. Any more ideas? -----Original Message----- From: Florian Gleixner [mailto:fl...@re...] Sent: Friday, May 02, 2008 12:33 PM To: Eric Gottesman Cc: Florian Gleixner; per...@li... Subject: Re: [Perfparse-users] FIFO issues Eric Gottesman wrote: > Failure Message: > > "Unknown column '_' in 'order clause'" > Maybe a bug. But you use a old Version of Perfparse. Use 0.106.1 or if you dare, try the cvs snapshots. > > > Some of the other options at the main menu work better, or at least > differently. If I go to "Raw plugin data," I see all of my hosts and > the appropriate checks, but the plugin output column just says > $OUTPUT$ for all of them. > > Any ideas? > Nagios changed the internal Macro definitions. Before Nagios 2.X it was called $OUTPUT. Now it is called $SERVICEOUTPUT i think. Check your process_perfdata command. http://perfparse.de/tiki-view_forum_thread.php?comments_parentId=57&foru mId=1&highlight=OUTPUT Flo > > > > -----Original Message----- > From: Florian Gleixner [mailto:fl...@bi...] > Sent: Thursday, May 01, 2008 10:16 PM > To: Eric Gottesman > Cc: per...@li... > Subject: Re: [Perfparse-users] FIFO issues > > Hi, > > the pipe method only works with the perfparse daemon (perfparsed) > running as a background process. It cares about cleaning the pipe from > outstanding data. If you want to use cron and perfparse-log2mysql to > get the data into mysql periodically then you have to use a regular file. > The file seems to be a regular file too, because a pipe has 0 Bytes > and a "p" in the permission strings. Example: > prw-r----- 1 nagios nagios 0 Mar 1 10:49 serviceperf.log > > http://perfparse.de/tiki-index.php?page=Minimal%20environment%20nagios > %2 02.9%20and%20perfparsed%20reading%20from%20a%20pipe > > is a example how to configure perfparsed and the pipe method. > > Flo > > Eric Gottesman schrieb: >> good morning, perfparse people. >> >> i'm setting up perfparse 0.105.6 with nagios 3.0.1 on a centOS 5 > machine. >> >> it is not working. >> >> i'm using the "pipe to perfparse" method as described in the install > guide. >> >> nothing's getting in to the database, and it seems to be FIFO related. > >> observe: >> >> [root@nagios01a var]# /usr/local/nagios/bin/perfparse-log2mysql -e >> error.txt [root@nagios01a var]# cat error.txt >> cat: error.txt: No such file or directory [root@nagios01a var]# cat >> error.txt.20080501.log >> 2008/05/01 12:59:55 [perfparse-log2any.c:157 24175 ] FIFO not >> authorized as the perf data input source >> >> >> ...now, my googling has shown that this is generally caused by either >> an error in perfparse.cfg, or incorrect permissions in >> /usr/local/nagios/var/perfdata-service.log. here's the relevent line >> in >> perfparse.cfg: >> >> Service_Log = "|/usr/local/nagios/var/perfdata-service.log" >> >> ...which i'm pretty confident is correct, and here's the permissions: >> >> # ls -l /usr/local/nagios/var/perfdata-service.log >> -rw-r--r-- 1 nagios nagios 198 May 1 13:03 >> /usr/local/nagios/var/perfdata-service.log >> >> i've been messing with this for days, recompiled like five times, and >> i'm at the end of my rope. help? >> >> >> --------------------------------------------------------------------- >> - >> -- >> >> --------------------------------------------------------------------- >> - >> --- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference >> Don't miss this year's exciting event. There's still time to save > $100. >> Use priority code J8TL2D2. >> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.co >> m >> /javaone >> >> >> --------------------------------------------------------------------- >> - >> -- >> >> _______________________________________________ >> Perfparse-users mailing list >> Per...@li... >> https://lists.sourceforge.net/lists/listinfo/perfparse-users > > ---------------------------------------------------------------------- > --- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com > /javaone _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users |
|
From: Florian G. <fl...@re...> - 2008-05-03 06:50:13
|
If only the raw data table populates and not the perfdata_service_bin or perfdarta_service_metric, then perfparse cannot parse the performance string or nagios does not deliver performance data or the plugins does not output performance data. Check plugin output and nagios setting. Flo Eric Gottesman wrote: > I upgraded to .106.1, nothing has changed. The $SERVICEOUTPUT$ thing > worked though, thanks. > > So now, I'm still seeing nothing in my host list. I tried running the > query from my original message in mysql manually without the order by, > and nothing came up! Here's the query: > > > SELECT perfdata_host.host_name, perfdata_service.service_description, > perfdata_service_metric.metric, perfdata_service_metric.unit, > perfdata_service_bin.value, perfdata_service_bin.state, > perfdata_service_bin.ctime FROM perfdata_host, perfdata_service, > perfdata_service_metric, perfdata_service_bin WHERE > perfdata_host.host_name = perfdata_service.host_name AND > perfdata_service_metric.host_name = perfdata_service.host_name AND > perfdata_service_metric.service_description = > perfdata_service.service_description AND perfdata_service_bin.id = > perfdata_service_metric.last_perfdata_bin; > > > The database is definitely populating, but a couple of those tables are > still empty- specifically perfdata_service_metric and > perfdata_service_bin. There's also a really weird thing where in the > "edit host group lists" page, the remove button is broken and shows up > as follows: > > &host_name=[hostname]">Remove > > I found where it's not happening in the code. The following snippet is > not executing in cgi_host_groups.c: > > snprintf(sDelete, 255, "<a > href=\"%s?edit_host_list=1&delete=1&group_name=%s", sProgName, > url_encode(sGroupName)); > > > My guess at this point is that I'm missing a package or two and it > didn't check properly, but I'm not sure. Any more ideas? > > > -----Original Message----- > From: Florian Gleixner [mailto:fl...@re...] > Sent: Friday, May 02, 2008 12:33 PM > To: Eric Gottesman > Cc: Florian Gleixner; per...@li... > Subject: Re: [Perfparse-users] FIFO issues > > Eric Gottesman wrote: > >> Failure Message: >> >> "Unknown column '_' in 'order clause'" >> > > Maybe a bug. But you use a old Version of Perfparse. Use 0.106.1 or if > you dare, try the cvs snapshots. > >> >> Some of the other options at the main menu work better, or at least >> differently. If I go to "Raw plugin data," I see all of my hosts and >> the appropriate checks, but the plugin output column just says >> $OUTPUT$ for all of them. >> >> Any ideas? >> > > Nagios changed the internal Macro definitions. Before Nagios 2.X it was > called $OUTPUT. Now it is called $SERVICEOUTPUT i think. Check your > process_perfdata command. > > http://perfparse.de/tiki-view_forum_thread.php?comments_parentId=57&foru > mId=1&highlight=OUTPUT > > Flo > >> >> >> -----Original Message----- >> From: Florian Gleixner [mailto:fl...@bi...] >> Sent: Thursday, May 01, 2008 10:16 PM >> To: Eric Gottesman >> Cc: per...@li... >> Subject: Re: [Perfparse-users] FIFO issues >> >> Hi, >> >> the pipe method only works with the perfparse daemon (perfparsed) >> running as a background process. It cares about cleaning the pipe from > >> outstanding data. If you want to use cron and perfparse-log2mysql to >> get the data into mysql periodically then you have to use a regular > file. >> The file seems to be a regular file too, because a pipe has 0 Bytes >> and a "p" in the permission strings. Example: >> prw-r----- 1 nagios nagios 0 Mar 1 10:49 serviceperf.log >> >> http://perfparse.de/tiki-index.php?page=Minimal%20environment%20nagios >> %2 02.9%20and%20perfparsed%20reading%20from%20a%20pipe >> >> is a example how to configure perfparsed and the pipe method. >> >> Flo >> >> Eric Gottesman schrieb: >>> good morning, perfparse people. >>> >>> i'm setting up perfparse 0.105.6 with nagios 3.0.1 on a centOS 5 >> machine. >>> >>> it is not working. >>> >>> i'm using the "pipe to perfparse" method as described in the install >> guide. >>> >>> nothing's getting in to the database, and it seems to be FIFO > related. >>> observe: >>> >>> [root@nagios01a var]# /usr/local/nagios/bin/perfparse-log2mysql -e >>> error.txt [root@nagios01a var]# cat error.txt >>> cat: error.txt: No such file or directory [root@nagios01a var]# cat >>> error.txt.20080501.log >>> 2008/05/01 12:59:55 [perfparse-log2any.c:157 24175 ] FIFO not >>> authorized as the perf data input source >>> >>> >>> ...now, my googling has shown that this is generally caused by either > >>> an error in perfparse.cfg, or incorrect permissions in >>> /usr/local/nagios/var/perfdata-service.log. here's the relevent line >>> in >>> perfparse.cfg: >>> >>> Service_Log = "|/usr/local/nagios/var/perfdata-service.log" >>> >>> ...which i'm pretty confident is correct, and here's the permissions: >>> >>> # ls -l /usr/local/nagios/var/perfdata-service.log >>> -rw-r--r-- 1 nagios nagios 198 May 1 13:03 >>> /usr/local/nagios/var/perfdata-service.log >>> >>> i've been messing with this for days, recompiled like five times, and > >>> i'm at the end of my rope. help? >>> >>> >>> --------------------------------------------------------------------- >>> - >>> -- >>> >>> --------------------------------------------------------------------- >>> - >>> --- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > >>> Don't miss this year's exciting event. There's still time to save >> $100. >>> Use priority code J8TL2D2. >>> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.co >>> m >>> /javaone >>> >>> >>> --------------------------------------------------------------------- >>> - >>> -- >>> >>> _______________________________________________ >>> Perfparse-users mailing list >>> Per...@li... >>> https://lists.sourceforge.net/lists/listinfo/perfparse-users >> ---------------------------------------------------------------------- >> --- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference >> Don't miss this year's exciting event. There's still time to save > $100. >> Use priority code J8TL2D2. >> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com >> /javaone _______________________________________________ >> Perfparse-users mailing list >> Per...@li... >> https://lists.sourceforge.net/lists/listinfo/perfparse-users > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X