NDOutils and cfg_dir
Andreas Kasenides
Andreas.Kasenides at cs.ucy.ac.cy
Thu Oct 18 07:59:58 CEST 2007
Andreas Ericsson wrote:
> Andreas Kasenides wrote:
>
>> I seem to remember reading something about this some time back,
>> but my search did not turn anything so here it goes:
>>
>> I am using Nagios 2.7, ndoutils 1.4b6 and it seems that when I use
>> several cfg_dir in my nagios.cfg the corresponding table in the DB
>> (_configvariables) will only retain one record for a cfg_dir (varname =
>> cfg_dir), the last one.
>> The exact same thing happens with cfg_file variables.
>>
>> As far as I can tell this behaviour was the same in ndoutils 1.4b2.
>> Any idea why?
>>
>
> Probably because the column has the "UNIQUE" property. I don't know
> for sure though, as I don't use ndoutils.
>
>
Oh yes indeed! Thanks a zillion!
Here is a small "patch" for db/mysql.sql of the offending table that
fixes it where
I removed the varname attribute from UNIQUE KEY line.
Thanks again.
Andreas:
=======================
--
-- Table structure for table `nagios_configfilevariables`
--
CREATE TABLE `nagios_configfilevariables` (
`configfilevariable_id` int(11) NOT NULL auto_increment,
`instance_id` smallint(6) NOT NULL default '0',
`configfile_id` int(11) NOT NULL default '0',
`varname` varchar(64) NOT NULL default '',
`varvalue` varchar(255) NOT NULL default '',
PRIMARY KEY (`configfilevariable_id`),
UNIQUE KEY `instance_id` (`instance_id`,`configfile_id`)
) ENGINE=InnoDB COMMENT='Configuration file variables';
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20071018/8f678d3e/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
-------------- next part --------------
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel
More information about the Developers
mailing list