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.
>
>
>
>
>
>
|
