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 |