Your message dated Sat, 15 Jan 2011 09:32:08 +0000
with message-id <e1pe2us-0007nx...@franck.debian.org>
and subject line Bug#607925: fixed in ndoutils 1.4b9-1.1
has caused the Debian Bug report #607925,
regarding ndoutils-nagios3-mysql: MySQL database schema is not updated when
upgrading to 1.4b9
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
607925: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=607925
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: ndoutils-nagios3-mysql
Version: 1.4b9-1
Severity: grave
Justification: renders package unusable
After upgrading a server from Lenny to Squeeze, ndo2db attempts to insert
records in its MySQL database started to fail -- in the /var/log/messages
we see (lines wrapped for readability purposes):
Dec 24 16:19:06 icarus ndo2db: Error: mysql_query() failed for 'INSERT
INTO nagios_servicestatus SET instance_id='1', service_object_id='444',
status_update_time=FROM_UNIXTIME(1293196746), output='PING OK - Packet
loss = 0%, RTA = 0\.31 ms', long_output='',
perfdata='rta=0\.306000ms;100\.000000;500\.000000;0\.000000
pl=0%;20;60;0', current_state='0', has_been_checked='1',
should_be_scheduled='1', current_check_attempt='1',
max_check_attempts='2', last_check=FROM_UNIXTIME(1293196740),
next_check=FROM_UNIXTIME(1293196800), check_type='0',
last_state_change=FROM_UNIXTIME(1292421071),
last_hard_state_change=FROM_UNIXTIME(1292420771), last_hard_state='0',
last_time_ok=FROM_UNIXTIME(1293196740),
last_time_warning=FROM_UNIXTIME(1292420651),
last_time_unknown=FROM_UNIXTIME(1290096021),
last_time_critical=FROM_UNIXTIME(1292421011), state_type='1',
last_notification=FROM_UNIXTIME(0), next_notification=FROM_UNIXTIME(0),
no_more_notifications='0', notifications_enabled='1',
problem_has_been_acknowledged='0', acknowledgeme
Dec 24 16:19:06 icarus ndo2db: mysql_error: 'Unknown column
'long_output' in 'field list''
In the upstream changelog for the 1.4b9 version, we see this line:
- Support for long performance data
which seems to correlate with the name of the missing column.
Further exploration shows that this really corresponds to the
integration of the patch http://tracker.nagios.org/view.php?id=18
which, among other things, modifies five tables adding one extra
column to each of them.
Ideally, this schema change should be handled automatically when
upgrading the package, or at least a bold note should be put into
NEWS.Debian so that the administrator is set aware of the problem.
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (990, 'testing'), (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-5-686 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.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 common framework for packaging dat
ii debconf [debconf-2.0] 1.5.36 Debian configuration management sy
ii libc6 2.11.2-7 Embedded GNU C Library: Shared lib
ii libmysqlclient16 5.1.49-3 MySQL database client library
ii mysql-client-5.1 [mysql-clie 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 NDOUtils common files
ii ucf 3.0025+nmu1 Update Configuration File: preserv
Versions of packages ndoutils-nagios3-mysql recommends:
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/install-error: abort
ndoutils-mysql/mysql/admin-user: root
ndoutils-mysql/remote/newhost:
ndoutils-mysql/remote/host:
ndoutils-mysql/database-type: mysql
ndoutils-mysql/remove-error: abort
ndoutils-mysql/remote/port:
ndoutils-mysql/db/app-user: ndoutils
* 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: unix socket
ndoutils-mysql/dbconfig-remove:
ndoutils-mysql/db/dbname: ndoutils
ndoutils-mysql/passwords-do-not-match:
ndoutils-mysql/purge: false
ndoutils-mysql/dbconfig-reinstall: false
--- End Message ---
--- Begin Message ---
Source: ndoutils
Source-Version: 1.4b9-1.1
We believe that the bug you reported is fixed in the latest version of
ndoutils, which is due to be installed in the Debian FTP archive:
ndoutils-common_1.4b9-1.1_amd64.deb
to main/n/ndoutils/ndoutils-common_1.4b9-1.1_amd64.deb
ndoutils-doc_1.4b9-1.1_all.deb
to main/n/ndoutils/ndoutils-doc_1.4b9-1.1_all.deb
ndoutils-nagios3-mysql_1.4b9-1.1_amd64.deb
to main/n/ndoutils/ndoutils-nagios3-mysql_1.4b9-1.1_amd64.deb
ndoutils_1.4b9-1.1.diff.gz
to main/n/ndoutils/ndoutils_1.4b9-1.1.diff.gz
ndoutils_1.4b9-1.1.dsc
to main/n/ndoutils/ndoutils_1.4b9-1.1.dsc
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 607...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Konstantin Khomoutov <flatw...@users.sourceforge.net> (supplier of updated
ndoutils package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.8
Date: Mon, 27 Dec 2010 12:41:15 +0300
Source: ndoutils
Binary: ndoutils-nagios3-mysql ndoutils-common ndoutils-doc
Architecture: source amd64 all
Version: 1.4b9-1.1
Distribution: unstable
Urgency: low
Maintainer: Hendrik Frenzel <hfren...@scunc.net>
Changed-By: Konstantin Khomoutov <flatw...@users.sourceforge.net>
Description:
ndoutils-common - NDOUtils common files
ndoutils-doc - Documentation for ndoutils
ndoutils-nagios3-mysql - This provides the NDOUtils for Nagios with MySQL
support
Closes: 607925
Changes:
ndoutils (1.4b9-1.1) unstable; urgency=low
.
* Non-maintainer upload.
* Make sure the MySQL database schema is updated on the package
upgrade (Closes: 607925) -- thanks to Drew Scott Daniels.
Checksums-Sha1:
9d0c2241c6aae6285d407b617e262f13c37dffda 1346 ndoutils_1.4b9-1.1.dsc
4ea849b5bd7590340ef92a331be100639c9ed019 11574 ndoutils_1.4b9-1.1.diff.gz
e8c8a3b0ad5cd2c9693bc28f4f32fe650834c28c 17250
ndoutils-common_1.4b9-1.1_amd64.deb
bdd947cecd00fafc0ea6edbce094a9734b5ff33c 94638
ndoutils-nagios3-mysql_1.4b9-1.1_amd64.deb
5d27092877bb09982cf5416d7c822bfa6c0e697c 724506 ndoutils-doc_1.4b9-1.1_all.deb
Checksums-Sha256:
f7e32c9fca9ea155094c2c511a8683ad88eec43208144cda8fc5164e2e8a8449 1346
ndoutils_1.4b9-1.1.dsc
5366df7774a1c491dfac0b3005c455285823c51ad5c5c80cfbffbbb6e2d34900 11574
ndoutils_1.4b9-1.1.diff.gz
75b90cdb33177822c17f96ca5f17b597b27780b8efed70a19852d5f6ffd0f481 17250
ndoutils-common_1.4b9-1.1_amd64.deb
e3c25c8da2d145ce3ac4d9b53d6970f05d2e6fd15d1fdd71a8dde22737a2c908 94638
ndoutils-nagios3-mysql_1.4b9-1.1_amd64.deb
9b5d2298485c387d9a2a6683e7ac42bc2d66f34ea5ae4c8f59b6ebadc9cd93ec 724506
ndoutils-doc_1.4b9-1.1_all.deb
Files:
37a9b49f29a065dec6a92adc68974b04 1346 net extra ndoutils_1.4b9-1.1.dsc
3a6aed596fc787233015d404c6d04eec 11574 net extra ndoutils_1.4b9-1.1.diff.gz
e8e7ae38f7441940bf7d973c1f8bec11 17250 net extra
ndoutils-common_1.4b9-1.1_amd64.deb
ed3e48995b37a045f47fa48ec8c3a7ae 94638 net extra
ndoutils-nagios3-mysql_1.4b9-1.1_amd64.deb
eadf7e5b5f18cc735782d17c1b1bbcb4 724506 doc extra
ndoutils-doc_1.4b9-1.1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iEYEARECAAYFAk0xXLYACgkQ01u8mbx9Agp0BwCgl17cXwSz2agw5qt3C6wPxsJc
gZsAn0/YDNW2jdRxrCokFWWZtcr2w0Pq
=10I5
-----END PGP SIGNATURE-----
--- End Message ---
