I keep getting this error after installing nagvis<div><br class="webkit-block-placeholder"></div><div>The installation went well but when I browse to the nagvis webpage I get this error</div><div><br class="webkit-block-placeholder"> </div><div><span class="Apple-style-span" style="font-family: Verdana; font-size: 16px; "><table class="messageBox" cellpadding="2" cellspacing="2" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; text-decoration: none; color: black; font-size: 12pt; width: 600px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; background-color: rgb(204, 204, 204); "> <tbody><tr><th style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; text-decoration: none; color: black; height: 22px; background-color: rgb(204, 204, 204); font-size: 15pt; font-weight: bold; text-align: center; "> nagiosNotRunning: NDOMy: Nagios not running (Backend ndomy_1)</th></tr><tr><td colspan="2" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; text-decoration: none; color: black; height: 200px; background-color: rgb(238, 238, 238); font-size: 12pt; font-weight: bold; text-align: center; "> NDO reports that Nagios is not running</td></tr></tbody></table></span></div><div><br class="webkit-block-placeholder"></div><div>When I check my logs, this is the error I get.</div><div><br class="webkit-block-placeholder"> </div><div><br class="webkit-block-placeholder"></div><div><div>[root@dev etc]# tail /var/log/messages </div><div>Jan 24 14:24:51 dev nagios: Event broker module '/usr/local/nagios/bin/ndomod.o' deinitialized successfully. </div><div>Jan 24 14:24:51 dev ndo2db: Successfully disconnected from MySQL database</div><div>Jan 24 14:24:51 dev nagios: Nagios 2.9 starting... (PID=3113)</div><div>Jan 24 14:24:51 dev nagios: LOG VERSION: 2.0 </div><div> Jan 24 14:24:51 dev nagios: ndomod: NDOMOD 1.4b7 (10-31-2007) Copyright (c) 2005-2007 Ethan Galstad (<a href="mailto:nagios@nagios.org">nagios@nagios.org</a>)</div><div>Jan 24 14:24:51 dev ndo2db: Successfully connected to MySQL database </div><div>Jan 24 14:24:51 dev nagios: ndomod: Successfully connected to data sink. 0 queued items to flush.</div><div>Jan 24 14:24:51 dev nagios: Event broker module '/usr/local/nagios/bin/ndomod.o' initialized successfully. </div><div>Jan 24 14:24:51 dev nagios: Finished daemonizing... (New PID=3116) </div><div>Jan 24 14:24:51 dev ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='4', varname='cfg_file', varvalue='/usr/local/nagios/etc/localhost\.cfg'' </div><div><br class="webkit-block-placeholder"></div><div><br class="webkit-block-placeholder"></div><div>Any idea on how I can fix this. I am running centos 5.0</div><br><div class="gmail_quote">On Nov 26, 2007 11:20 AM, Giles Coochey < <a href="mailto:gcoochey@sapphire.gi">gcoochey@sapphire.gi</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"> <div lang="EN-GB" link="blue" vlink="blue"> <div> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">If you post in plain text, it's much easier for me not to top post.</span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">This is likely something to do with your socket file.</span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">Check the socket file in ndo2db configuration file, mine is in:</span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">/opt/nagios/var/ndo.sock</span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">It is referenced in ndo2db.cfg with this line:</span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">socket_name=/opt/nagios/var/ndo.sock</span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">if socket exists, it may have been created with insufficient permissions, or the directory mask was bad, remove the file, check permissions and restart ndo.</span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">Thanks</span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">Giles</span></font></p> <p><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font></p> <div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt"> <div> <div align="center" style="text-align:center"><font size="3" face="Times New Roman"><span lang="EN-US" style="font-size:12.0pt"> <hr size="2" width="100%" align="center"> </span></font></div> <p><b><font size="2" face="Tahoma"><span lang="EN-US" style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font size="2" face="Tahoma"><span lang="EN-US" style="font-size:10.0pt;font-family:Tahoma"> <a href="mailto:nagios-users-bounces@lists.sourceforge.net" target="_blank">nagios-users-bounces@lists.sourceforge.net</a> [mailto:<a href="mailto:nagios-users-bounces@lists.sourceforge.net" target="_blank">nagios-users-bounces@lists.sourceforge.net</a>] <b><span style="font-weight:bold">On Behalf Of </span></b>Alex Dehaini<br> <b><span style="font-weight:bold">Sent:</span></b> 26 November 2007 12:10<div><div></div><div class="Wj3C7c"><br> <b><span style="font-weight:bold">To:</span></b> <a href="mailto:nagios-users@lists.sourceforge.net" target="_blank">nagios-users@lists.sourceforge.net</a><br> <b><span style="font-weight:bold">Subject:</span></b> Re: [Nagios-users] Integrating nagvis</div></div></span></font><span lang="EN-US"></span></p> </div><div><div></div><div class="Wj3C7c"> <p><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p> <p style="margin-bottom:12.0pt"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Here is the error I get from my logs<br> <br> <b><span style="font-weight:bold">Nov 26 11:00:01 development nagios: ndomod: Still unable to connect to data sink. 0 items lost, 1655 queued items to flush.<br> <br> </span></b>When I browse to the nagvis home page, I get this error. <br> <br> <b><span style="font-weight:bold">Warning</span></b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b><span style="font-weight:bold">/usr/local/nagios/share/nagvis/nagvis/includes/classes/class.GlobalBackend-ndomy.php</span></b> on line <b><span style="font-weight:bold">58<br> <br> nagiosNotRunning: NDOMy: Nagios not running (Backend ndomy_1) <br> <br> NDO reports that Nagios is not running<br> <br> </span></b>Any clue what is wrong?</span></font></p> <div> <p><font size="3" face="Times New Roman"><span style="font-size:12.0pt">On Nov 26, 2007 11:01 AM, Giles Coochey <<a href="mailto:gcoochey@sapphire.gi" target="_blank">gcoochey@sapphire.gi</a>> wrote: </span></font></p> <div> <p style="margin-bottom:12.0pt"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><br> <br> > -----Original Message-----<br> > From: <a href="mailto:nagios-users-bounces@lists.sourceforge.net" target="_blank">nagios-users-bounces@lists.sourceforge.net</a> [mailto:<a href="mailto:nagios-users-" target="_blank">nagios-users-</a><br> > <a href="mailto:bounces@lists.sourceforge.net" target="_blank">bounces@lists.sourceforge.net</a>] On Behalf Of Giorgio Zarrelli <br> > Sent: 26 November 2007 11:58<br> > To: <a href="mailto:nagios-users@lists.sourceforge.net" target="_blank">nagios-users@lists.sourceforge.net</a><br> > Subject: Re: [Nagios-users] Integrating nagvis<br> ><br> > Hi,<br> > <br> > I used:<br> ><br> > nagios-3.0b6<br> > nagvis-1.2b2<br> ><br> > What's the problem with the backend? Which operating system?<br> ></span></font></p> </div> <p><font size="3" face="Times New Roman"><span style="font-size:12.0pt">I'm using Nagios 2.9, NdoUtils 1.4.7b7 and NagVis 1.1.2<br> <br> Not any problems, I just followed the README's and posted minor issues<br> with descriptions as to the particular problems on the list to resolve<br> all my problems.</span></font></p> <div> <div> <p><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><br> -------------------------------------------------------------------------<br> This SF.net email is sponsored by: Microsoft<br> Defy all challenges. Microsoft(R) Visual Studio 2005.<br> <a href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/" target="_blank">http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a><br> _______________________________________________<br> Nagios-users mailing list<br> <a href="mailto:Nagios-users@lists.sourceforge.net" target="_blank">Nagios-users@lists.sourceforge.net </a><br> <a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a><br> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. <br> ::: Messages without supporting info will risk being sent to /dev/null</span></font></p> </div> </div> </div> <p><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><br> <br clear="all"> <br> -- <br> Alex Dehaini<br> Developer<br> Site - <a href="http://www.alexdehaini.com" target="_blank">www.alexdehaini.com </a><br> Email - <a href="mailto:alexdehaini@gmail.com" target="_blank">alexdehaini@gmail.com</a> </span></font></p> </div></div></div> </div> </div> </blockquote></div><br><br clear="all"><br>-- <br>Alex Dehaini<br>Developer<br>Site - <a href="http://www.alexdehaini.com">www.alexdehaini.com</a><br>Email - <a href="mailto:alexdehaini@gmail.com">alexdehaini@gmail.com</a> </div>