RE: [Perfparse-users] Still getting SQL Error running perfparse -r

[Cook, G. <GW...@ma...>]

Christopher D. Chandler wrote:
> Filename: /usr/local/nagios/var/service-perfdata.out
> File open at line 0 and ready to parse:
> 00:00:02 l 0 read 0 @ 0.0 l/sec.  Met 0 @ nan Met/l.  Drop 0. "INSERT
> INTO perfdata_service_raw (host_name, service_description, ctime,
> txt_data, nagios_status) VALUES
> ('1091466041','samwise',FROM_UNIXTIME(RTA =3D 22.68 ms),'PING',0)"
> 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 'ms),'PING',0)' at line 1

I've seen this error before and I believe that it indicates a blank like
in the serviceperf.log file. Probably near the top of the file. Can you
edit this and remove any blank lines, then try again?

Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)