ndo-utils not populating hostgroups

[Marc Powell]

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