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

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

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..
>=20
>  ./perfparse -U monty -Psome_pass -D nagios -H
> 10.128.18.202

Try this instead:
./perfparse -U monty -P some_pass -D nagios -H 10.128.18.202

Add a space between the -P parameter and your password.

> 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#=20
>=20
>=20
> Statistics.
> Sample Points: 0
> Minimum: 	0.000000 	Average: 	0.000000
> Maximum: 	0.000000 	Standard Dev: 	0.000000
>=20
>=20
>> 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.
>>=20
>> 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.


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