[Perfparse-users] Error from PerfParse

[Ben C. <Ben...@ro...>]

Norbert,

I am glad you have got further with PerfParse.  May I ask what version 
you are using?

The error you have got is likely to mean that there is nothing, or an 
error in the first like of nagios/var/serviceperf.log

Can you please send me the first few lines of this file?

This will report a better error in later versions.

May I ask in future that you might want to address support requests to 
the mailing list per...@li....  You can sign up 
for this from the bottom of PerfParse project page:

http://sourceforge.net/projects/perfparse

This will help other users with similar errors to fix their own 
problems, and you may get a reply from another user who offers an 
alternate fix.

Kind regards,

Ben Clewett.


Norbert Wiedeke/GIS wrote:
> Hallo Ben,
> 
> now I have compiled and installed Nagios 1.2 with (./configure
> --with-file-perfdata)
> , the newest plugin's and so on.
> 
> 'check_disk' replies:
> 
> DISK OK - free space: / 484 MB (24%); /space 11154 MB (52%); /dev/shm 251
> MB (100%);| /=483MB;1700;1900;0;2000 /space=11153MB;18270;20420;0;21495
> /dev/shm=251MB;213;238;0;251
> 
> 
> Errors at the Start /usr/local/nagios/bin/perfparse.sh
> 
> "INSERT INTO perfdata_service_raw (host_name, service_description, ctime,
> txt_data) VALUES ('','',FROM_UNIXTIME(
> ),'')" failed:
> You have an error in your SQL syntax.  Check the manual that corresponds to
> your MySQL server version for the right syntax to use near '),'')' at line
> 2
> 
> 
> In Process Info:
> 
> "Performance Data Being Processed?    Yes"
> 
> 
> 
> Norbert.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>                                                                                                                  
>                       Ben Clewett                                                                                
>                       <Ben.Clewett@roadrun         An:      Norbert Wiedeke/GIS <nor...@gi...>  
>                       ner.uk.com>                  Kopie:                                                        
>                                                    Thema:   Re: Antwort: Re: Antwort: Re: Antwort: Re:           
>                       08.06.04 15:11               perfparse-0.07                                                
>                                                                                                                  
>                                                                                                                  
> 
> 
> 
> Norbert,
> 
> Sorry I got your name wrong :)
> 
> I think your nagios is not producing the performance data you need.  I
> have a check-list here which you might find helpful:
> 
> 
> 1. You are using the latest Nagios, 1.2.
> 
> 2. You are using the latest nagios plugins.  Only these produce
> performance data.  You can check this by running one, like 'check_disk'.
>   If you have performance data, this should reply:
> 
> DISK OK - free space: / 8089 MB (22%); /boot 35 MB (76%) |
> /=8089MB;33312;35163;0;37014 /boot=34MB;40;42;0;45
> 
> You can see the performance data beyond the '|'.
> 
> Download from:
> 
> http://nagiosplug.sourceforge.net/snapshot
> http://nagiosplug.sourceforge.net/snapshot/nagios-plugins-HEAD-200406080514.tar.gz
> 
> 
> 3. You have compiled nagios with the option to produce performance data.
>   Using the '--with-file-perfdata'.  Ie:
> 
> ./configure --with-file-perfdata
> 
> 4. Set the permissions on the servicelog file as:
>      -rw-rw-r-- nagios nagios
> ie:
> $ chmod 664 serviceperf.log
> $ chown nagios.nagios serviceperf.log
> 
> 5. Check 'nagios.cfg', ensure you have these lines somewhere:
> 
> process_performance_data=1
> xpdfile_host_perfdata_file=/usr/local/nagios/var/hostperf.log
> xpdfile_host_perfdata_template=$TIMET$\t$HOSTNAME$\t$OUTPUT$\t$PERFDATA$
> xpdfile_service_perfdata_file=/usr/local/nagios/var/serviceperf.log
> xpdfile_service_perfdata_template=$TIMET$\t$HOSTNAME$\t$SERVICEDESC
> $\t$OUTPUT$\t$PERFDATA$
> 
> 6. In services.cfg, ensure this line is in all services you want to
> monitor:  (Or the generic parent table.)
> 
> process_perf_data 1
> 
> 7. In Nagios 'Process Info' page. At the bottom of the Process
> Information box, ensure you have:
> 
> "Performance Data Being Processed?    Yes"
> 
> 
> Regards, Ben.
> 
> 
> 
> 
> 
>