ndo2db: Error: mysql_query() failed

[Jorge Peña]

So, you are right In did I have this log in the /var/syslog

 

Sep 18 15:38:01 test2 ndo2db: Error: mysql_query() failed for 'INSERT INTO
nagios_configfilevariables SET instance_id='1', configfile_id='83',
varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/contacts\.cfg''
Sep 18 15:38:01 test2 ndo2db: Error: mysql_query() failed for 'INSERT INTO
nagios_configfilevariables SET instance_id='1', configfile_id='83',
varname='cfg_file',
varvalue='/usr/local/nagios/etc/objects/timeperiods\.cfg''
Sep 18 15:38:01 test2 ndo2db: Error: mysql_query() failed for 'INSERT INTO
nagios_configfilevariables SET instance_id='1', configfile_id='83',
varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/templates\.cfg''
Sep 18 15:38:01 test2 ndo2db: Error: mysql_query() failed for 'INSERT INTO
nagios_configfilevariables SET instance_id='1', configfile_id='83',
varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/localhost\.cfg''

 

How could I fix it?

 

Deleting all the database and starting again?

 

Cheers,

Jorge

 

  _____  

De: Morris, Patrick [mailto:patrick.morris at hp.com] 
Enviado el: jueves, 18 de septiembre de 2008 18:26
Para: Jorge Peña; nagios-users at lists.sourceforge.net
Asunto: RE: [Nagios-users] ndo2db: Error: mysql_query() failed

 

Hi list,

After solving my last problem with NDOutils now everytime I restart Nagios I
have this nice messages in /var/log/syslog


Sep 18 15:38:01 test2 ndo2db: Error: mysql_query() failed for 'INSERT INTO
nagios_configfilevariables SET instance_id='1', configfile_id='83',
varname='cfg_file', varvalue='/usr/local/nagios/etc/objects/contacts\.cfg''
[snip]


I don't like it. How can I restart again the database to don't have it or
remove this query?

Several things can cause this. The most likely would be that either you did
not set up your databases using the correct schema for the version of
ndoutils you are using, or that your nagios_configfilevariables table has
been corrupted.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20080918/d05a4279/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null