Re: [Perfparse-users] FIFO issues

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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