ndo2db: Error: mysql_query() failed

[Ronaldo A. Bueno Filho]

Did you change everything? I mean, when using TCP socket, eu have to use IP
address, etc... Did you correct the ndo files?

Also,check the librarys as I told before. Generate the intallation files
from the source files and check if there is any missing lib. If yes, install
it and run the installation again.

Regards,

--
Ronaldo A. Bueno Filho


--------- Mensagem Original --------
De: Jorge Peña <cotarelo2 at hotmail.com>
Para: Ronaldo A. Bueno Filho <ronaldobf at linkway.com.br>,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 23:21

> 
> 
> 
> 
> ..hmmessage P
> {
> margin:0px;
> padding:0px
> }
> body.hmmessage
> {
> FONT-SIZE: 10pt;
> FONT-FAMILY:Tahoma
> }
> 
> 
> 
> 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 &amp; 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&amp;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.> Ahora llévate lo mejor de MSN y Windows Live,  en tu móvil
> 
> 
> 



--
Essa mensagem foi verificada contra vírus e conteúdo malicioso pelo Lisa Antivírus.


-------------------------------------------------------------------------
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