[Perfparse-users] Re: Antwort: Re: Antwort: Re: Perfparse 0.08 Compile-Error

[Ben C. <Be...@cl...>]

Thanks for the info on the links.

Worrying that PerfParse does not stop.  You can safely CRTL-C at any time.

Try killing perfparse.sh and perfparse, and running from the command 
line.  This will tell you what's going on:

$ perfparse --report
00:00:32 l 1739 read 938 @ 14.1 l/sec.  Met 496 @ 0.53 Met/l.  Drop 0.

This should end when all data had been added to the database.  You may 
have a very large amount of waiting data:

$ wc -l serviceperf.log

If this is the case, then it will take a while.  To enable Nagios to 
work better, you can use 'nice':

$ nice perfparse --report

This should allow Nagios to work without problem.  Obviously the next 
time it runs there will be a lot less data.

Ben



Norbert Wiedeke/GIS wrote:

> Hallo Ben,
> 
> now it seems, there a new Error !!!!
> 
> 
> For the compile-error I set two links
> 
> in /lib
> 
> ln   -s  libnss_files.so.2  libnss_files.so
> ln   -s  libdns_files.so.2  libdns_files.so
> 
> 
> 
> I started ./perfparse.sh. The Script runs and runs .......
> Nagios is now performing an Error for Zombies on all hosts.
> 
> Norbert.
> 
> 
> 
> 
> 
> 
> 
> Norbert.
> 
> 
> 
> 
> 
> 
>                                                                                                            
>                       Ben Clewett                                                                          
>                       <Be...@cl...         An:      Norbert Wiedeke/GIS                                
>                       .uk>                     <nor...@gi...>,                            
>                                                "'per...@li...'"                   
>                       14.06.04 14:31           <per...@li...>                     
>                                                Kopie:                                                      
>                                                Thema:   Re: Antwort: Re: Perfparse 0.08 Compile-Error      
>                                                                                                            
> 
> 
> 
> Norbert,
> 
> You have two empty lines at the top of your serviceperf.log.  If you
> remove these, PerfParse will work.  Please let me know.
> 
> Can you also tell me how you got it to compile, so that any other users
> with the same error can be helped?
> 
> Regards, Ben
> 
> Norbert Wiedeke/GIS wrote:
> 
>>Hallo,
>>
>>so, now I compiled and installed version 0.08.
>>
>>
>>perfparse.sh:
>>
>>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
>>
>>
>>
>>(See attached file: serviceperf.zip)
>>
>>
>>Norbert.
> 
> 
> 
> 
> 
>