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