[Pkg-nagios-devel] Bug#287792: nagios-mysql: cgi report Error: Could not read host and service status information!

[Christian]

Package: nagios-mysql
Version: 2:1.3-0+pre6
Followup-For: Bug #287792


downgrading to mysql-server_4.0.22-6 (and *only* the -server package, no
other downgrades needed) did fix the issue. i still fail to see the
cause of the non-working nagios, the only interesting changelog entry of
mysql-dfsg-4.0.23-1 is "New upstream release"...

however, i know *why* the "INSERT INTO programstatus" queries failed:
the field "last_log_rotation" in table "programstatus" was about to be
filled with "FROM_UNIXTIME(0)". cut'n'paste the query manually gives
"#1048 - Column 'last_log_rotation' cannot be null". the same query
(INSERT) is done now with mysql-4.0.22-6 again and it's working fine (no
error).

maybe this information could be forwared to the mysql-dfsg maintainer,
if it's worth anything.

thanks,
Christian.


-- System Information:
Debian Release: 3.1
  APT prefers unstable
  APT policy: (990, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.10-rc3-bk11
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages nagios-mysql depends on:
ii  libc6                       2.3.2.ds1-20 GNU C Library: Shared libraries an
ii  libgd2-xpm                  2.0.33-1.1   GD Graphics Library version 2
ii  libjpeg62                   6b-9         The Independent JPEG Group's JPEG 
ii  libmysqlclient10            3.23.56-2    LGPL-licensed client library for M
ii  libpng12-0                  1.2.8rel-1   PNG library - runtime
ii  nagios-common               2:1.3-0+pre6 A host/service/network monitoring 
ii  zlib1g                      1:1.2.2-4    compression library - runtime

-- debconf information:
  nagios/warnmovedcommands:
  nagios/warncoords:
* nagios/wwwsuid: true
  nagios/newapachecfg:
  nagios/upgradefromnetsaint:
* nagios/configapache: Apache
  nagios/warnupgrade_5_6: