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 |