From: Kemp, D. <Dar...@xe...> - 2004-07-20 16:12:38
|
Anyone have any idea why my unixtime is returning a D? =20 I'm still poking around, but it seems rather strange :-) =20 bash-2.03# ./perfparse -r Filename: /usr/local/nagios/var/serviceperf.log File open at line 0 and ready to parse: 00:00:00 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) VALUES ('4.065000','0.820000',FROM_UNIXTIME(D),'PING OK - Packet loss =3D 0%, RTA =3D 32.00 ms')" failed: Unknown column 'D' in 'field list' bash-2.03# =20 =20 -dkk |