<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> Andreas Ericsson wrote: <blockquote cite="mid:471638FB.6040302@op5.se" type="cite"> <pre wrap="">Andreas Kasenides wrote: </pre> <blockquote type="cite"> <pre wrap="">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? </pre> </blockquote> <pre wrap=""> Probably because the column has the "UNIQUE" property. I don't know for sure though, as I don't use ndoutils. </pre> </blockquote> 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: ======================= <pre>-- -- Table structure for table `nagios_configfilevariables` --</pre> <pre>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';</pre> </body> </html>