I have already done that and re-compiled nagios. The problem is how ndo2db is putting info into mysql, that is where the issue comes from.<div> </div><div><div>Jan 24 14:33:04 dev ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='7', varname='cfg_file', varvalue='/usr/local/nagios/etc/localhost\.cfg'' </div><div> </div> <div class="gmail_quote">On Jan 24, 2008 2:40 PM, Giles Coochey <<a href="mailto:gcoochey@sapphire.gi">gcoochey@sapphire.gi</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"> <a href="http://www.nagvis.org/docs/general/often_reported_errors#nagiosnotrunning" target="_blank">http://www.nagvis.org/docs/general/often_reported_errors#nagiosnotrunning</a> ________________________________________ From: Alex Dehaini [mailto:<a href="mailto:alexdehaini@gmail.com">alexdehaini@gmail.com</a>] Sent: 24 January 2008 15:34 To: Giles Coochey; <a href="mailto:nagios-users@lists.sourceforge.net">nagios-users@lists.sourceforge.net </a> Subject: nagvis error nagvis <div><div></div><div class="Wj3C7c"> I keep getting this error after installing nagvis The installation went well but when I browse to the nagvis webpage I get this error nagiosNotRunning: NDOMy: Nagios not running (Backend ndomy_1) NDO reports that Nagios is not running When I check my logs, this is the error I get. [root@dev etc]# tail /var/log/messages Jan 24 14:24:51 dev nagios: Event broker module '/usr/local/nagios/bin/ndomod.o' deinitialized successfully. Jan 24 14:24:51 dev ndo2db: Successfully disconnected from MySQL database Jan 24 14:24:51 dev nagios: Nagios 2.9 starting... (PID=3113) Jan 24 14:24:51 dev nagios: LOG VERSION: 2.0 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>) Jan 24 14:24:51 dev ndo2db: Successfully connected to MySQL database Jan 24 14:24:51 dev nagios: ndomod: Successfully connected to data sink. 0 queued items to flush. Jan 24 14:24:51 dev nagios: Event broker module '/usr/local/nagios/bin/ndomod.o' initialized successfully. Jan 24 14:24:51 dev nagios: Finished daemonizing... (New PID=3116) 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'' Any idea on how I can fix this. I am running centos 5.0 On Nov 26, 2007 11:20 AM, Giles Coochey < <a href="mailto:gcoochey@sapphire.gi">gcoochey@sapphire.gi</a>> wrote: If you post in plain text, it's much easier for me not to top post. This is likely something to do with your socket file. Check the socket file in ndo2db configuration file, mine is in: /opt/nagios/var/ndo.sock It is referenced in ndo2db.cfg with this line: socket_name=/opt/nagios/var/ndo.sock 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. Thanks Giles ________________________________________ From: <a href="mailto:nagios-users-bounces@lists.sourceforge.net">nagios-users-bounces@lists.sourceforge.net</a> [mailto:<a href="mailto:nagios-users-bounces@lists.sourceforge.net"> nagios-users-bounces@lists.sourceforge.net</a>] On Behalf Of Alex Dehaini Sent: 26 November 2007 12:10 To: <a href="mailto:nagios-users@lists.sourceforge.net">nagios-users@lists.sourceforge.net</a> Subject: Re: [Nagios-users] Integrating nagvis Here is the error I get from my logs Nov 26 11:00:01 development nagios: ndomod: Still unable to connect to data sink. 0 items lost, 1655 queued items to flush. When I browse to the nagvis home page, I get this error. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/nagios/share/nagvis/nagvis/includes/classes/class.GlobalBackend-ndomy.php on line 58 nagiosNotRunning: NDOMy: Nagios not running (Backend ndomy_1) NDO reports that Nagios is not running Any clue what is wrong? On Nov 26, 2007 11:01 AM, Giles Coochey <<a href="mailto:gcoochey@sapphire.gi">gcoochey@sapphire.gi</a>> wrote: > -----Original Message----- > From: <a href="mailto:nagios-users-bounces@lists.sourceforge.net">nagios-users-bounces@lists.sourceforge.net</a> [mailto:<a href="mailto:nagios-users-">nagios-users-</a> > <a href="mailto:bounces@lists.sourceforge.net"> bounces@lists.sourceforge.net</a>] On Behalf Of Giorgio Zarrelli > Sent: 26 November 2007 11:58 > To: <a href="mailto:nagios-users@lists.sourceforge.net">nagios-users@lists.sourceforge.net</a> > Subject: Re: [Nagios-users] Integrating nagvis > > Hi, > > I used: > > nagios-3.0b6 > nagvis-1.2b2 > > What's the problem with the backend? Which operating system? > I'm using Nagios 2.9, NdoUtils 1.4.7b7 and NagVis 1.1.2 Not any problems, I just followed the README's and posted minor issues with descriptions as to the particular problems on the list to resolve all my problems. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. <a href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/" target="_blank">http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ </a> _______________________________________________ Nagios-users mailing list <a href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank"> https://lists.sourceforge.net/lists/listinfo/nagios-users</a> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null -- Alex Dehaini Developer Site - <a href="http://www.alexdehaini.com" target="_blank">www.alexdehaini.com</a> Email - <a href="mailto:alexdehaini@gmail.com">alexdehaini@gmail.com</a> -- Alex Dehaini Developer Site - <a href="http://www.alexdehaini.com" target="_blank">www.alexdehaini.com</a> Email - <a href="mailto:alexdehaini@gmail.com">alexdehaini@gmail.com</a> </div></div></blockquote> </div> -- Alex Dehaini Developer Site - <a href="http://www.alexdehaini.com">www.alexdehaini.com</a> Email - <a href="mailto:alexdehaini@gmail.com">alexdehaini@gmail.com</a> </div>