[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
(last_update,program_start,nagios_pid,daemon_mode,last_command_check,last_log_rotation,enable_notifications,execute_service_checks,accept_passive_service_checks,enable_event_handlers,obsess_over_services,enable_flap_detection,enable_failure_prediction,process_performance_data)
VALUES
(FROM_UNIXTIME(1104530501),FROM_UNIXTIME(1104513731),'28353','0',FROM_UNIXTIME(1104530500),FROM_UNIXTIME(0),'1','1','0','1','0','0','1','0')
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: