Package: ndoutils-nagios3-mysql Version: 1.4b7-11 Severity: minor Hello all,
in /usr/share/dbconfig-common/data/ndoutils-mysql/install/mysql the table `nagios_configfiles` is created with a unique key `instance_id` over (`instance_id`,`configfile_type`,`configfile_path`). However, in /etc/nagios3/nagios.cfg, the variable "cfg_dir" can be set multiple times. In fact, is is even set multiple times in the default configuration as shipped in the nagios3-common package. In turn, that table won't represent the true state of the config file as on every nagios restart the insert of the second (and higher) instance of "cfg_dir" will fail with | ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_configfilevariables SET instance_id='1', configfile_id='102', varname='cfg_dir', varvalue='/etc/nagios3/conf\.d'' Methinks that key doesn't really need to be unique, but I'm unsure whether that would have any unforeseen consequences, so I'll leave this up to the maintainer and/or upstream to decide. Cheers, Flo -- System Information: Debian Release: 5.0.4 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.26-2-686 (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages ndoutils-nagios3-mysql depends on: ii dbconfig-common 1.8.39 common framework for packaging dat ii debconf [debconf- 1.5.24 Debian configuration management sy ii libc6 2.7-18lenny2 GNU C Library: Shared libraries ii libmysqlclient15o 5.0.51a-24+lenny2+spu1 MySQL database client library ii mysql-client-5.0 5.0.51a-24+lenny2+spu1 MySQL database client binaries ii nagios3 3.0.6-4~lenny2 A host/service/network monitoring ii ndoutils-common 1.4b7-11 This provides the NDOUtils for Nag ii ucf 3.0016 Update Configuration File: preserv Versions of packages ndoutils-nagios3-mysql recommends: ii mysql-server 5.0.51a-24+lenny2+spu1 MySQL database server (metapackage ii mysql-server-5.0 5.0.51a-24+lenny2+spu1 MySQL database server binaries Versions of packages ndoutils-nagios3-mysql suggests: pn ndoutils-doc <none> (no description available) -- debconf information: ndoutils-mysql/remote/host: ndoutils-mysql/database-type: mysql ndoutils-mysql/remove-error: abort ndoutils-mysql/internal/reconfiguring: false ndoutils-mysql/upgrade-error: abort ndoutils-mysql/internal/skip-preseed: false * ndoutils-mysql/mysql/method: unix socket * ndoutils-mysql/db/dbname: ndoutils ndoutils-mysql/install-error: abort * ndoutils-mysql/mysql/admin-user: root ndoutils-mysql/remote/newhost: ndoutils-mysql/remote/port: * ndoutils-mysql/db/app-user: ndoutils * ndoutils-mysql/dbconfig-install: true ndoutils-mysql/dbconfig-upgrade: true ndoutils-mysql/upgrade-backup: true ndoutils-mysql/missing-db-package-error: abort ndoutils-mysql/dbconfig-remove: ndoutils-mysql/passwords-do-not-match: ndoutils-mysql/purge: false ndoutils-mysql/dbconfig-reinstall: false
signature.asc
Description: Digital signature
