Re: [Perfparse-users] Re: [Nagios-users] PerfParse Help?

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

Jon,

This error would tend to indicate you have a blank like in the 
serviceperf.log file.  Probably at the top of this file.  Can you edit 
this and remove any blank lines?

(You can see the FROM_UNIXTIME() which should be FROM_UNIXTIME(1234567) 
which caused this specific error.  Some programming to enhance the 
robustness of PerfParse needs to be done here. :)

Regards, Ben.

Jon Lyons wrote:

> Thanks, tried that but still nothing, the Statistics
> info says 0 as well, I think its the SQL error
> statment, the data isn't getting updated..
> 
>  ./perfparse -U monty -Psome_pass -D nagios -H
> 10.128.18.202
> Filename: /usr/local/var/serviceperf.log
> "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 1
> 00:00:01 l 0 read 0 @ 0.0 l/sec.  Met 0 @ nan Met/l. 
> Drop 0. nagios-stats#
>  
> 
> Statistics.
> Sample Points: 0
> Minimum: 	0.000000 	Average: 	0.000000
> Maximum: 	0.000000 	Standard Dev: 	0.000000
> 
> 
> 
>>Change the 'Max Scale:' value in the web form to
>>something higher than
>>the number of interfaces (for the service above,
>>change '<auto>' to
>>'15'), then redraw the graph.
>>
>>I think that currently the graph is being drawn with
>>a max scale value
>>equal to the number of interfaces, so the data is
>>there, although you
>>cannot see it because it runs right along the top of
>>the graph. 
>>
> 
> 
> 
> 
> 		
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
> http://promotions.yahoo.com/new_mail
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
> Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
> Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
> REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>