RE: [Perfparse-users] Error after install runing perfparse -r

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

per...@li... wrote:
> Hi,
>=20
> I found this error after installing perfparse-0.99.08 with
> data from plugins 1.4.0alpha1.
> To make this work I added a new column "nagios_status" to
> perfdata_service_raw and the application
> wors. Is this OK ? or do I have any other problem with the plugins?
>=20
>=20
> [root@lbox bin]# ./perfparse -r
> Filename: /usr/local/nagios/var/serviceperf.log
> 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
> ('3COM_3300','PING',FROM_UNIXTIME(1091825121),'PING OK -
> Packet loss =3D 0%, RTA =3D 1.96 ms',0)"
> failed:
> Unknown column 'nagios_status' in 'field list'
>=20
> Reinaldo T.
>=20

After install, did you run the 'perfparse-db-tool' with the '--update'
parameter? If not, you should do so. This updates the MySQL db between
versions, when db changes have been made.

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