[Pkg-nagios-devel] Bug#303422: nagios: Error: Could not lock status data tables in database ''

[Chris Teachworth]

Package: nagios-mysql
Version: 2:1.3-cvs.20050116-4
Severity: important


The following error is writtent to /var/log/syslog and /var/log messages once
every minute:

Error: Could not lock status data tables in database '' 

My guess is that the  nagios-mysql plugin is not pulling the xsddb_database value
from the /etc/nagios/cgi.cfg file. I believe this error message is printed in
the source file nagios-1.3-vus.20050116/xdata/xsddb.c

I followed all of the instructions in README.Debian and README.mysql from the
/usr/share/doc/nagios-mysql dir and verfied that the user I'm specifying in
/etc/nagios/cgi.cfg for the xsddb_database has SELECT, INSERT, UPDATE, DELETE,
and LOCK privileges on the nagios database.

I haven't upgraded from a previous version of either nagios or mysql.

This is what the relevent section of my cgi.cfg file looks like:
xsddb_host=localhost
#xsddb_port=someport
xsddb_database=nagios
xsddb_username=nagios
xsddb_password=somepassword 

Thanks for any help,
	Chris Teachworth

-- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.9-xenU
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages nagios-mysql depends on:
ii  libc6               2.3.2.ds1-18         GNU C Library: Shared libraries an
ii  libgd2-noxpm        2.0.33-1.1           GD Graphics Library version 2 (wit
ii  libjpeg62           6b-9                 The Independent JPEG Group's JPEG 
ii  libmysqlclient12    4.0.23-7             mysql database client library
ii  libpng12-0          1.2.8rel-1           PNG library - runtime
ii  nagios-common       2:1.3-cvs.20050116-4 A host/service/network monitoring 
ii  zlib1g              1:1.2.2-3            compression library - runtime

-- no debconf information