ndoutils startup error for config files

[Keith Fischer]

I have started testing Nagios 3.0 along with ndoutils 1.4b7 and have
some errors when ndo2db-3x starts.  This is my first installation of
ndoutils so I do not have much experience with it or do I have any of
the older versions installed.

Here is what I get in the syslog:
Mar 14 16:10:14 az50cimlnx02 nagios: Local time is Fri Mar 14 16:10:14 MST 2008
Mar 14 16:10:14 az50cimlnx02 nagios: LOG VERSION: 2.0
Mar 14 16:10:14 az50cimlnx02 nagios: ndomod: NDOMOD 1.4b7 (10-31-2007)
Copyright (c) 2005-2007 Ethan Galstad (nagios at nagios.org)
Mar 14 16:10:14 az50cimlnx02 nagios: ndomod: Could not open data sink!
 I'll keep trying, but some output may get lost...
Mar 14 16:10:14 az50cimlnx02 nagios: Event broker module
'/cim/nagios/bin/ndomod-3x.o' initialized successfully.
Mar 14 16:10:14 az50cimlnx02 nagios: Finished daemonizing... (New PID=6242)
Mar 14 16:10:30 az50cimlnx02 nagios: ndomod: Still unable to connect
to data sink.  0 items lost, 382 queued items to flush.
Mar 14 16:10:46 az50cimlnx02 nagios: ndomod: Successfully connected to
data sink.  458 queued items to flush.
Mar 14 16:10:46 az50cimlnx02 nagios: ndomod: Successfully flushed 458
queued items to data sink.
Mar 14 16:10:46 az50cimlnx02 ndo2db-3x: Successfully connected to MySQL database
Mar 14 16:10:50 az50cimlnx02 ndo2db-3x: Error: mysql_query() failed
for 'INSERT INTO nagios_configfilevariables SET instance_id='1',
configfile_id='5', varname='cfg_file',
varvalue='/cim/nagios/etc/misccommands\.cfg''

It looks like what is happening is that when ndo inserts the
configfilevalues into the table it does not create a unique key for
each of the nagios.cfg cfg_file or cfg_dir entries.

I have only one entry in the configfiles table:
6  	1  	0  	/cim/nagios/etc/nagios.cfg

I have only one entry in the configfilevariables for a varname of cfg_file
402  	1  	6  	cfg_file  	/cim/nagios/etc/checkcommands.cfg

and only one for a varname of cfg_dir
403  	1  	6  	cfg_dir  	/cim/nagios/etc/hostext

Both of these entries are the "first of their kind" in the nagios.cfg
file.  All the other cfg_file or cfg_dir entries result in an error.

This seems to be an issue with how dbhandlers.c does the inserts.  The
code in the ndo2db_handle_configfilevariables function does not handle
multiple configfilevariables with the same name.  These inserts are
prevented by the unique index on configfilevariables called
instance_id(instance_id,configfile_id,varname).  There is no increment
of the configfile_id or an insert into the configfiles for each new
cfg_file encountered.

If someone can provide me with some more information about the
database structure of configfiles and configfilevariables I might be
able to come up with a solution.

Keith

-------------------------------------------------------------------------
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/