ndo2db: Error: mysql_query() failed

[Jorge Peña]

I stoped nagios
I stoped NDO
I edited /usr/local/nagios/etc/ndo2db.cfg and changed the socket to tp
 
I started nagios
I started NDO
 
But now I have the message:
 
 
 
 nagios: ndomod: Still unable to connect to data sink.  0 items lost, 586 queued items to flush.> Date: Tue, 23 Sep 2008 00:32:16 -0300> To: cotarelo2 at hotmail.com; patrick.morris at hp.com; nagios-users at lists.sourceforge.net> From: ronaldobf at linkway.com.br> Subject: Re: [Nagios-users] ndo2db: Error: mysql_query() failed> > > I think I sent an e-mail before showing my solution regarding my own issue> with NDOUtils.> > I noticed that when compiling and generating the installation from the> source files, it was missing some libs. > Try to generate the files and compile it again. Check if you see any lib> statements with "no". > > In my case, I did not have at least 4 libs, including socket and TCP. I> installed it and it worked.> > If you are using socket connection, try to use TCP. Maybe it works.> > Regards,> > --> Ronaldo A. Bueno Filho> > > --------- Mensagem Original --------> De: Jorge Peña <cotarelo2 at hotmail.com>> Para: Morris, Patrick <patrick.morris at hp.com>,> nagios-users at lists.sourceforge.net <nagios-users at lists.sourceforge.net>> Assunto: Re: [Nagios-users] ndo2db: Error: mysql_query() failed> Data: 22/09/08 12:37> > > > > > > > > > > ..hmmessage P> > {> > margin:0px;> > padding:0px> > }> > body.hmmessage> > {> > FONT-SIZE: 10pt;> > FONT-FAMILY:Tahoma> > }> > > > > > > > Hello there.I installed again the database structure, it didn't work, I> don't know from where comes the / just before the .cfgFrom:> patrick.morris at hp.comTo: cotarelo2 at hotmail.com;> nagios-users at lists.sourceforge.netDate: Thu, 18 Sep 2008 16:25:51> +0000Subject: RE: [Nagios-users] ndo2db: Error: mysql_query() failed> > > > > > > > > > > > > > > > > > ..ExternalClass p.EC_MsoNormal, .ExternalClass li.EC_MsoNormal,> .ExternalClass div.EC_MsoNormal> > {margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New> Roman','serif';}> > ..ExternalClass p.EC_MsoSubtitle, .ExternalClass li.EC_MsoSubtitle,> .ExternalClass div.EC_MsoSubtitle> >> {margin-bottom:.0001pt;font-size:12.0pt;font-family:'Cambria','serif';color:#4F81BD;letter-spacing:.75pt;font-style:italic;}> > ..ExternalClass a:link, .ExternalClass span.EC_MsoHyperlink> > {color:blue;text-decoration:underline;}> > ..ExternalClass a:visited, .ExternalClass span.EC_MsoHyperlinkFollowed> > {color:purple;text-decoration:underline;}> > ..ExternalClass p> > {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:'Times New> Roman','serif';}> > ..ExternalClass p.EC_MsoListParagraph, .ExternalClass> li.EC_MsoListParagraph, .ExternalClass div.EC_MsoListParagraph> >> {margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times> New Roman','serif';}> > ..ExternalClass span.EC_EmailStyle18> > {font-family:'Calibri','sans-serif';color:#1F497D;}> > ..ExternalClass span.EC_SubtitleChar> >> {font-family:'Cambria','serif';color:#4F81BD;letter-spacing:.75pt;font-style:italic;}> > ..ExternalClass .EC_MsoChpDefault> > {font-size:10.0pt;}> > @page Section1> > {size:8.5in 11.0in;}> > ..ExternalClass div.EC_Section1> > {page:Section1;}> > ..ExternalClass ol> > {margin-bottom:0in;}> > ..ExternalClass ul> > {margin-bottom:0in;}> > > > > > > > > > > > > > > > > > > > > > > > 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.> > > > > > > > > > > > > > > > > > ¡Trónchate de risa con los mejores capítulos de South Park en MSN Vídeo!> > > > > > > > > > > > > > > > > > -------------------------------------------------------------------------> > 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=/> > > > > > > > > > > > > > > > > > _______________________________________________> > 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> > > > > > > > --> Essa mensagem foi verificada contra vírus e conteúdo malicioso pelo Lisa Antivírus.> 
_________________________________________________________________
¿Sigue el calor? Consulta MSN El tiempo
http://eltiempo.es.msn.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20080923/e7e1b653/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