Menu
▾
▴
[Perfparse-users] PERFPARSE -R not allowing INSERT
|
From: Christopher D. C. <ch...@dh...> - 2004-08-02 14:54:36
|
Yves,=20
=20
I am running the current 0.99.08 version. Their was syntax error in the
xpdfile_service_perfdata in the nagios.cfg file. But now when I run I am
getting the following error:
=20
[root@dh24 bin]# ./perfparse -r
Filename: /usr/local/nagios/var/service-perfdata.out
File open at line 0 and ready to parse:
00:00:01 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 ('time=3D
6.8331091457291','dh04',FROM_UNIXTIME(d response time),'HTTP',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 'response
time),'HTTP',0)' at line 1
=20
SERVICE-PERFDATA.OUT
=20
1091456077 dh01 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 1.01 ms 1091456084 dh03
HTTP OK 1 HARD 7 0 HTTP ok: HTTP/1.1 200 OK
- 6.459 second response time time=3D 6.4591091456091 dh04 HTTP
OK 1 HARD 8 0 HTTP ok: HTTP/1.1 200 OK -
8.057 second response time time=3D 8.0571091456097 dh06 PING OK
1 HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D =
1.04
ms 1091456104 dh07 SMTP OK 1 HARD 2
0 SMTP OK - 1 second response time 1091456110 dh08
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 1.02 ms 1091456117 dh20 PING OK 1
HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D 0.23 ms
1091456124 dh21 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 0.21 ms 1091456130 dh23
FTP OK 1 HARD 0 0 FTP OK - 0.020 second
response time on port 21 [220 ProFTPD 1.2.8 Server (DH Innovations FTP
Server) [dh23]] time=3D 0.0201091456137 dh23 PING OK 1
HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D 0.19 ms
1091456143 dh24 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 0.09 ms 1091456150 dh26
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 0.19 ms 1091456157 dhch02 PING OK 1
HARD 5 0 PING OK - Packet loss =3D 0%, RTA =3D 1.28 ms
1091456163 dhch04 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 0.24 ms 1091456170 =
dhisw2
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 1.80 ms 1091456176 fburke_lpt PING OK
1 HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D =
49.63
ms 1091456183 gate-burkes PING OK 1 HARD
4 0 PING OK - Packet loss =3D 0%, RTA =3D 51.80 ms
1091456190 gate-gdi PING OK 1 HARD 4
0 PING OK - Packet loss =3D 0%, RTA =3D 30.72 ms 1091456196
mgruber-wks PING OK 1 HARD 4 0 PING OK
- Packet loss =3D 0%, RTA =3D 18.26 ms 1091456203 =
nc.rr.com-gdi
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 29.51 ms 1091456209 samwise PING OK 1
HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D 50.71 ms
1091456216 burke-5 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 51.01 ms 1091456229 dh02
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 0.98 ms 1091456236 dh03 PING OK 1
HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D 0.94 ms
1091456243 dh04 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 0.94 ms 1091456249 dh07
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 0.96 ms 1091456256 dh08 DNS OK 1
HARD 0 0 DNS ok - 0 seconds response time, Address(es)
is/are 216.109.118.73 1091456262 dh20 HTTP OK 1
HARD 1 0 HTTP ok: HTTP/1.1 200 OK - 0.669 second
response time time=3D 0.6691091456269 dh21 HTTP OK 1
HARD 0 0 HTTP ok: HTTP/1.1 200 OK - 0.324 second
response time time=3D 0.3241091456276 dh22 PING OK 1
HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D 0.26 ms
1091456282 dh23 HTTP OK 1 HARD 1 0
HTTP ok: HTTP/1.1 200 OK - 0.699 second response time time=3D
0.6991091456284 dh07 SMTP OK 1 HARD 1 0
SMTP OK - 1 second response time 1091456289 dh24 LOAD
UNKNOWN 3 HARD 0 0 Warning threshold must be float
or float triplet! 1091456295 dh25 PING OK 1
HARD 5 0 PING OK - Packet loss =3D 0%, RTA =3D 0.23 ms
1091456302 dhch01 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 0.71 ms 1091456309 =
dhch03
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 0.70 ms 1091456315 dhisw1 PING OK 1
HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D 3.01 ms
1091456322 dhisw3 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 2.05 ms 1091456328 gate
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 1.64 ms 1091456335 gate-dmz PING OK
1 HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D =
1.46
ms 1091456342 gate-lan PING OK 1 HARD
4 0 PING OK - Packet loss =3D 0%, RTA =3D 1.63 ms
1091456348 nc.rr.com-dhi PING OK 1 HARD 4
0 PING OK - Packet loss =3D 0%, RTA =3D 1.50 ms 1091456355
opus PING OK 1 HARD 4 0 PING OK - Packet
loss =3D 0%, RTA =3D 92.72 ms 1091456364 bellsouth.net-burkes
PING OK 1 HARD 5 0 PING OK - Packet loss =
=3D
0%, RTA =3D 49.99 ms 1091456371 dh01 DNS OK 1
HARD 0 0 DNS ok - 0 seconds response time, Address(es)
is/are 216.109.118.77 1091456377 dh01 PING OK 1
HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D 1.00 ms
1091456384 dh03 HTTP OK 1 HARD 6 0
HTTP ok: HTTP/1.1 200 OK - 6.635 second response time time=3D
6.6351091456391 dh04 HTTP OK 1 HARD 8 0
HTTP ok: HTTP/1.1 200 OK - 8.093 second response time time=3D
8.0931091456397 dh06 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 1.18 ms 1091456410 dh08
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 1.04 ms 1091456417 dh20 PING OK 1
HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D 0.23 ms
1091456424 dh21 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 0.20 ms 1091456430 dh23
FTP OK 1 HARD 0 0 FTP OK - 0.020 second
response time on port 21 [220 ProFTPD 1.2.8 Server (DH Innovations FTP
Server) [dh23]] time=3D 0.0201091456437 dh23 PING OK 1
HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D 1.42 ms
1091456443 dh24 PING OK 1 HARD 4 0
PING OK - Packet loss =3D 0%, RTA =3D 0.07 ms 1091456450 dh26
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 0.22 ms 1091456457 dhch02 PING OK 1
HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D 1.57 ms
1091456464 dh07 SMTP OK 1 HARD 1 0
SMTP OK - 1 second response time 1091456463 dhch04 PING
OK 1 HARD 4 0 PING OK - Packet loss =3D 0%, =
RTA
=3D 0.25 ms 1091456470 dhisw2 PING OK 1 HARD
4 0 PING OK - Packet loss =3D 0%, RTA =3D 1.83 ms
1091456476 fburke_lpt PING OK 1 HARD 4
0 PING OK - Packet loss =3D 0%, RTA =3D 50.30 ms 1091456483
gate-burkes PING OK 1 HARD 4 0 PING OK
- Packet loss =3D 0%, RTA =3D 52.04 ms 1091456490 gate-gdi
PING OK 1 HARD 4 0 PING OK - Packet loss =
=3D
0%, RTA =3D 20.08 ms 1091456496 mgruber-wks PING OK
1 HARD 4 0 PING OK - Packet loss =3D 0%, RTA =3D =
17.07
ms 1091456503 nc.rr.com-gdi PING OK 1 HARD
4 0 PING OK - Packet loss =3D
=20
Thoughts?
=20
Chris
=20
Christopher D. Chandler Managing Partner
Office: 919-481-9876
Mobile: 919-274-7684 =20
=20
ch...@dh... <mailto:ch...@dh...>=20
=20
DH Innovations, LLC
Post Office Box 5335 | Cary, North Carolina 27512
=20
|
