Actually, I too get a similar error you yours, on starting NDO: Jan 23 17:08:09 hostname ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='1', varname='cfg_dir', varvalue='/opt/nagios/etc/cfg/hostgroup1''
And I have a working NagVis setup, so I am not sure whether that error is the actual cause of your problem. ________________________________________ From: Alex Dehaini [mailto:[EMAIL PROTECTED] Sent: 24 January 2008 15:43 To: Giles Coochey; [email protected] Subject: Re: nagvis error nagvis 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. 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'' On Jan 24, 2008 2:40 PM, Giles Coochey <[EMAIL PROTECTED]> wrote: http://www.nagvis.org/docs/general/often_reported_errors#nagiosnotrunning ________________________________________ From: Alex Dehaini [mailto:[EMAIL PROTECTED] Sent: 24 January 2008 15:34 To: Giles Coochey; [email protected] Subject: nagvis error nagvis 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. [EMAIL PROTECTED] 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 ([EMAIL PROTECTED]) 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 < [EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] On Behalf Of Alex Dehaini Sent: 26 November 2007 12:10 To: [email protected] 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 <[EMAIL PROTECTED]> wrote: > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:nagios-users- > [EMAIL PROTECTED] On Behalf Of Giorgio Zarrelli > Sent: 26 November 2007 11:58 > To: [email protected] > 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. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Nagios-users mailing list [email protected] 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 -- Alex Dehaini Developer Site - www.alexdehaini.com Email - [EMAIL PROTECTED] -- Alex Dehaini Developer Site - www.alexdehaini.com Email - [EMAIL PROTECTED] -- Alex Dehaini Developer Site - www.alexdehaini.com Email - [EMAIL PROTECTED] ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Nagios-users mailing list [email protected] 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
