ndo-utils not populating hostgroups

[Hoot, Joseph]

OK.  For some reason, ndo2db is giving errors in my /var/log/messages
file: 

Jun 30 08:14:02 mon01 ndo2db: Successfully connected to MySQL database
Jun 30 08:14:27 mon01 ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagio
s_configfilevariables SET instance_id='1', configfile_id='7',
varname='cfg_file'
, varvalue='/netmon/nagios/etc/timeperiods\.cfg''
Jun 30 08:14:27 mon01 ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagio
s_configfilevariables SET instance_id='1', configfile_id='7',
varname='cfg_file'
, varvalue='/netmon/nagios/etc/templates\.cfg''
Jun 30 08:14:27 mon01 ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagio
s_configfilevariables SET instance_id='1', configfile_id='7',
varname='cfg_file'
, varvalue='/netmon/nagios/etc/commands\.cfg''
Jun 30 08:14:27 mon01 ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagio
s_configfilevariables SET instance_id='1', configfile_id='7',
varname='cfg_dir',
 varvalue='/netmon/nagios/etc/suf''
Jun 30 08:14:27 mon01 ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagio
s_configfilevariables SET instance_id='1', configfile_id='7',
varname='cfg_dir',
 varvalue='/netmon/nagios/etc/buc''


Nagios has been running fine with those variables for about 2 years now.
And it reads them properly.  Does anyone know why ndo2db might be dieing
on these?  Those ".../etc/buc"  and ".../etc/suf"  (there are a lot more
too) directories contain all of my information for hostgroups,
servicegroups and other things.

-----Original Message-----
From: nagios-users-bounces at lists.sourceforge.net
[mailto:nagios-users-bounces at lists.sourceforge.net] On Behalf Of Marc
Powell
Sent: Friday, June 27, 2008 3:42 PM
To: Nagios User list
Subject: Re: [Nagios-users] ndo-utils not populating hostgroups


On Jun 27, 2008, at 1:35 PM, Hoot, Joseph wrote:

> The documentation for ndoutils talks about the debugging.  I turned  
> it on, but don't see any information getting fed into it.  I thought  
> maybe it was a permission issue, so I set it to nagios:nagios  
> instead of root.

Check /var/log/messages.

> 1)      Does anyone have any suggestions for selecting from the  
> ndo2db mysql tables to see if its actually populating properly?

select * from nagios_hostgroups
select * from nagios_hostgroup_members

select * from nagios_servicegroup
select * from nagios_servicegroup_members

(presumes that's where nagvis is getting that info, I don't use it).

> 2)      Is there any way to see what sql inserts are going to  
> ndo2db, if any?  Would the ndo2db command be logging anywhere?   
> Should this be the ndo.debug file?

ndo2db.cfg --

debug_level=-1
debug_verbosity=1
debug_file=/usr/local/nagios/var/ndo2db.debug

[nagios at noctools var]$ ls -al ndo2db.debug
-rw-r--r--    1 nagios   nagios     127703 Jun 27 14:40 ndo2db.debug

[nagios at noctools var]$ tail -2 ndo2db.debug
[1214595618.386557] [002.0] [pid=22404] INSERT INTO  
nagios_externalcommands SET instance_id='1', command_type='30',  
entry_time=FROM_UNIXTIME(1214595618),  
command_name='PROCESS_SERVICE_CHECK_RESULT',  
command_args='redacted;PING;0;OK - 172\.29\.102\.93: rta 12\.2 ms,  
lost 0%'
[1214595618.387127] [002.0] [pid=22404] INSERT INTO  
nagios_externalcommands SET instance_id='1', command_type='30',  
entry_time=FROM_UNIXTIME(1214595618),  
command_name='PROCESS_SERVICE_CHECK_RESULT', command_args='redacted;5  
MIN CPU UTIL;0;5 Minute CPU Utilization: OK - 0'


> 3)      Any other suggestions on troubleshooting this?

Not here...

--
Marc


------------------------------------------------------------------------
-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
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

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
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