Re: [Perfparse-users] FIFO issues

[Eric G. <er...@in...>]

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