Package: ndoutils-nagios3-mysql Version: 1.4b9-1.1 Severity: important
When upgrading from lenny to squeeze, the database schema does not get upgraded if the database resides on a remote host. The package insists on upgrading the localhost. As can be seen from the data below, the debconf database holds uk-swa-db01 as the name of the database server. However, the following output of dpkg-reconfigure shows that this is not the host the upgrade wants to connect to: dpkg-reconfigure ndoutils-nagios3-mysql Stopping ndoutils: ndoutils. dbconfig-common: writing config to /etc/dbconfig-common/ndoutils-mysql.conf granting access to database nagios for nag...@uk-swa-mon.aminocom.com: failed. error encountered creating user: mysql said: ERROR 1044 (42000) at line 1: Access denied for user 'root'@'10.171.24.40' to database 'nagios' dbconfig-common: ndoutils-mysql configure: aborted. dbconfig-common: flushing administrative password This completely breaks the upgrade since after the upgrade an additional column named long_output (see ticket 607925, archived) is now required, and most INSERTs for service checks anbd host checks now fail. It requires a user with significant skill to extract the schema changes from the local database (if there is one to start with) and duplicate them in the remote database. I would hav re-opened bug 607925, but was unable to. -- System Information: Debian Release: 6.0.2 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.32-5-686-bigmem (SMP w/2 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages ndoutils-nagios3-mysql depends on: ii dbconfig-common 1.8.46+squeeze.0 common framework for packaging dat ii debconf [debconf-2.0] 1.5.36.1 Debian configuration management sy ii libc6 2.11.2-10 Embedded GNU C Library: Shared lib ii libmysqlclient16 5.1.49-3 MySQL database client library ii mysql-client 5.1.49-3 MySQL database client (metapackage ii mysql-client-5.1 [mysql 5.1.49-3 MySQL database client binaries ii nagios3 3.2.1-2 A host/service/network monitoring ii ndoutils-common 1.4b9-1.1 NDOUtils common files ii ucf 3.0025+nmu1 Update Configuration File: preserv Versions of packages ndoutils-nagios3-mysql recommends: ii mysql-server 5.1.49-3 MySQL database server (metapackage ii mysql-server-5.1 [mysql-serve 5.1.49-3 MySQL database server binaries and Versions of packages ndoutils-nagios3-mysql suggests: pn ndoutils-doc <none> (no description available) -- Configuration Files: /etc/default/ndoutils changed: ENABLE_NDOUTILS=1 DAEMON_OPTS="-c /etc/nagios3/ndo2db.cfg" -- debconf information: ndoutils-mysql/password-confirm: (password omitted) ndoutils-mysql/mysql/admin-pass: (password omitted) ndoutils-mysql/mysql/app-pass: (password omitted) ndoutils-mysql/app-password-confirm: (password omitted) * ndoutils-mysql/install-error: retry (skip questions) * ndoutils-mysql/mysql/admin-user: nagios ndoutils-mysql/remote/newhost: uk-swa-db01 * ndoutils-mysql/remote/host: uk-swa-db01 ndoutils-mysql/database-type: mysql ndoutils-mysql/remove-error: abort * ndoutils-mysql/remote/port: 3306 * ndoutils-mysql/db/app-user: nagios * ndoutils-mysql/dbconfig-install: true ndoutils-mysql/dbconfig-upgrade: true ndoutils-mysql/internal/reconfiguring: false ndoutils-mysql/upgrade-error: abort ndoutils-mysql/internal/skip-preseed: false ndoutils-mysql/upgrade-backup: true ndoutils-mysql/missing-db-package-error: abort * ndoutils-mysql/mysql/method: tcp/ip ndoutils-mysql/dbconfig-remove: * ndoutils-mysql/db/dbname: nagios ndoutils-mysql/passwords-do-not-match: ndoutils-mysql/purge: false ndoutils-mysql/dbconfig-reinstall: false -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org