Page 1 of 1

[Nagios-devel] ndoutils problem, ndo2db: Error: mysql_query() failed

Posted: Thu Nov 16, 2006 9:36 am
by Guest
This is a multi-part message in MIME format.

------_=_NextPart_001_01C709A5.A5D9FAC8
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I am running nagios 2.5. I am trying to get nagios to use mysql
database through ndoutils-1.3.1.

I got the following error when I start nagios.=20

=20

Nov 16 12:17:10 linuxbox ndo2db: Error: mysql_query() failed for 'INSERT
INTO logentries SET instance_id=3D'0',
logentry_time=3DFROM_UNIXTIME(1163697421),
entry_time=3DFROM_UNIXTIME(1163697421), entry_time_usec=3D'729271',
logentry_type=3D'262144', logentry_data=3D'INITIAL SERVICE STATE:
router;PING;OK;HARD;1;PING OK - Packet loss =3D 0%, RTA =3D 6\.35 ms',
realtime_data=3D'1', inferred_data_extracted=3D'1''

=20

I seem to have everything configured correctly and have tried use
mysql-5.0 as well as mysql-4.1.20 as I heard this works with nodutils.

I get the same error no matter what version of mysql I run.

Please advise,

-Eric

=20

=20


------_=_NextPart_001_01C709A5.A5D9FAC8
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable











st1\:*{behavior:url(#default#ieooui) }












Hi,

I am running nagios 2.5.  I am trying to get =
nagios to use
mysql database through ndoutils-1.3.1.

I got the following error when I start nagios. =


 

Nov 16 12:17:10 linuxbox ndo2db: Error: mysql_query() =
failed
for 'INSERT INTO logentries SET instance_id=3D'0',
logentry_time=3DFROM_UNIXTIME(1163697421), =
entry_time=3DFROM_UNIXTIME(1163697421),
entry_time_usec=3D'729271', logentry_type=3D'262144', =
logentry_data=3D'INITIAL =
SERVICE STATE:
router;PING;OK;HARD;1;PING OK - Packet loss =3D 0%, RTA =3D 6\.35 ms',
realtime_data=3D'1', =
inferred_data_extracted=3D'1''

 

<span =
style=3D'font-size

...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]