[Pkg-nagios-devel] Bug#303422: marked as done (nagios: Error: Could not lock status data tables in database '')
Debian Bug Tracking System
owner@bugs.debian.org
Thu, 07 Apr 2005 21:48:11 -0700
Your message dated Fri, 8 Apr 2005 00:39:22 -0400
with message-id <20050408043922.GA2363@seanius.net>
and subject line Bug#303422: [Pkg-nagios-devel] Bug#303422: nagios: Error: Could not lock status data tables in database ''
has caused the attached Bug report 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 I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 6 Apr 2005 15:43:21 +0000
>From cteachworth@gmail.com Wed Apr 06 08:43:21 2005
Return-path: <cteachworth@gmail.com>
Received: from (ami-hq-noc) [209.112.199.246]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1DJCga-0006WZ-00; Wed, 06 Apr 2005 08:43:20 -0700
Received: by ami-hq-noc (Postfix, from userid 1000)
id 08FF4A4054; Wed, 6 Apr 2005 07:41:44 -0800 (AKDT)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Chris Teachworth <cteachworth@gmail.com>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: nagios: Error: Could not lock status data tables in database ''
X-Mailer: reportbug 3.8
Date: Wed, 06 Apr 2005 07:41:44 -0800
Message-Id: <20050406154144.08FF4A4054@ami-hq-noc>
Delivered-To: submit@bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
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
---------------------------------------
Received: (at 303422-done) by bugs.debian.org; 8 Apr 2005 04:39:53 +0000
>From seanius@seanius.net Thu Apr 07 21:39:53 2005
Return-path: <seanius@seanius.net>
Received: from dsl092-235-113.phl1.dsl.speakeasy.net (sativa.seanius.net) [66.92.235.113]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1DJlHd-0005CC-00; Thu, 07 Apr 2005 21:39:53 -0700
Received: by sativa.seanius.net (Postfix, from userid 1000)
id 80C7B15834; Fri, 8 Apr 2005 00:39:22 -0400 (EDT)
Date: Fri, 8 Apr 2005 00:39:22 -0400
From: sean finney <seanius@debian.org>
To: Chris Teachworth <cteachworth@gmail.com>,
303422-done@bugs.debian.org
Subject: Re: Bug#303422: [Pkg-nagios-devel] Bug#303422: nagios: Error: Could not lock status data tables in database ''
Message-ID: <20050408043922.GA2363@seanius.net>
References: <20050406154144.08FF4A4054@ami-hq-noc> <20050406234441.GA19274@seanius.net> <e60e40cd05040711262e24d30e@mail.gmail.com> <20050408013707.GA750@seanius.net> <e60e40cd05040720415571a180@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="ZGiS0Q5IWpPtfppv"
Content-Disposition: inline
In-Reply-To: <e60e40cd05040720415571a180@mail.gmail.com>
User-Agent: Mutt/1.5.5.1+cvs20040105i
Delivered-To: 303422-done@bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
--ZGiS0Q5IWpPtfppv
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
hey,
On Thu, Apr 07, 2005 at 07:41:53PM -0800, Chris Teachworth wrote:
> Man... talk about making things more complicated than they need to
> be... when will I ever learn?
>=20
> That was is it, there was a process hung up from a couple of days ago.
> Sorry for wasting your time like that.
aha. believe it or not, i had the same problem about two weeks ago.
i had a particular check sending me an email every minute, even though
the host was fine. no matter what i turned off or disabled, i kept
getting the same messages. turns out there was a hung process.
anyway, i'm going to go ahead and close this bug. =20
sean
--=20
--ZGiS0Q5IWpPtfppv
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFCVgr6ynjLPm522B0RAkM9AJ9mWiCZxzt7ZgRgvdUVw9sNTzuZ3QCfdD3x
2whGIvjfpfhlZC3Ua1uvGdA=
=kWHE
-----END PGP SIGNATURE-----
--ZGiS0Q5IWpPtfppv--