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

Christian Christian <evil@g-house.de>, 287792@bugs.debian.org
Fri, 31 Dec 2004 23:03:36 +0100

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

i can confirm this here: no config-file was altered, but after an
"apt-get dist-upgrade" today nagios-mysql is not working any more.
however, nagios itself was not upgraded, but mysql was, so *maybe*
mysql is to blame here...will/have to investigate, but a little help
would be nice.

/var/log/nagios/nagios.log gives:

Error: Could not insert/update status record for program in table
'programstatus' of database 'nagios'

but mysql.log grants access to my nagios-user here and is showing 
"INSERT INTO programstatus" messages over and over (as usual?)

sorry for the noise, but here we go, from mysql.log:

27 Query       INSERT INTO programstatus


-- 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/wwwsuid: true
* nagios/configapache: Apache