[Pkg-nagios-devel] Bug#284599: marked as done (nagios-common: status file search in fs with nagios-mysql)
Debian Bug Tracking System
owner@bugs.debian.org
Thu, 09 Dec 2004 08:03:10 -0800
Your message dated Thu, 9 Dec 2004 10:49:58 -0500
with message-id <20041209154958.GB2960@seanius.net>
and subject line Bug#284599: [Pkg-nagios-devel] Bug#284599: nagios-common: status file search in fs with nagios-mysql
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; 7 Dec 2004 12:59:01 +0000
>From karoly.vegh@uta.at Tue Dec 07 04:59:01 2004
Return-path: <karoly.vegh@uta.at>
Received: from postkutsche.sys.uta.at [195.70.254.209]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1Cbevk-0001cr-00; Tue, 07 Dec 2004 04:59:00 -0800
Received: from atmailinet01.utalan.at (smtpmail.utalan.at [172.21.16.17])
by postkutsche.sys.uta.at (8.13.1/8.13.1) with ESMTP id iB7Cwwv6014463
for <submit@bugs.debian.org>; Tue, 7 Dec 2004 13:58:58 +0100
Received: from marvin (marvin.utalan.at [172.21.73.133]) by atmailinet01.utalan.at with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72)
id XH19GNG6; Tue, 7 Dec 2004 13:58:57 +0100
Received: from charlie by marvin with local (Exim 3.36 #1 (Debian))
id 1Cbevh-0002xR-00; Tue, 07 Dec 2004 13:58:57 +0100
Date: Tue, 7 Dec 2004 13:58:57 +0100
X-Sybari-Trust: 02a3e056 505eaae3 c6fc5f17 00000b3d
From: karoly.vegh@uta.at
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: nagios-common: status file search in fs with nagios-mysql
Message-ID: <20041207125857.GA11345@marvin>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2
Content-Disposition: inline
X-Reportbug-Version: 2.99.6
User-Agent: Mutt/1.5.6+20040907i
Delivered-To: submit@bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-6.4 required=4.0 tests=BAYES_00,HAS_PACKAGE,
NO_REAL_NAME autolearn=no version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
Package: nagios-common
Severity: important
I'm running debian sarge.
atsrvlx02-new:~# dpkg -l | fgrep -e nagios -e mysql
ii libdbd-mysql-p 2.9003-3 A Perl5 database interface to the MySQL data
ii libmysqlclient 3.23.56-2 LGPL-licensed client library for MySQL datab
ii libmysqlclient 3.23.56-2 LGPL-licensed client development files for M
ii libmysqlclient 4.0.21-7 mysql database client library
ii mysql-admin 1.0.12-1 GUI tool for intuitive MySQL administration
ii mysql-admin-co 1.0.12-1 Architecture independent files for MySQL Adm
ii mysql-client 4.0.21-7 mysql database client binaries
ii mysql-common 4.0.21-6 mysql database common files (e.g. /etc/mysql
ii mysql-doc 4.0.21-2 mysql database documentation
ii mysql-server 4.0.21-7 mysql database server binaries
ii nagios-common 1.3-0+pre4 A host/service/network monitoring and manage
ii nagios-mysql 1.3-0+pre4 A host/service/network monitoring and manage
ii nagios-plugins 1.3.1.0-12 Plugins for the nagios network monitoring an
ii php4-mysql 4.3.9-1 MySQL module for php4
ii python-mysqldb 1.1.6-1 A Python interface to MySQL
atsrvlx02-new:~#
atsrvlx02-new:~# /etc/init.d/nagios reload
Reloading nagios configuration files.
Not running.
atsrvlx02-new:~#
though:
atsrvlx02-new:~# ps faux | grep nagios
root 8619 0.0 0.0 1580 468 pts/7 S+ 13:45 0:00 \_ grep nagios
nagios 2054 0.0 0.0 2620 1208 ? SNs 13:01 0:00 /usr/sbin/nagios /etc/nagios/nagios.cfg
atsrvlx02-new:~#
The initscript searches for /var/log/nagios/status.log
atsrvlx02-new:~# namei /var/log/nagios/status.log
f: /var/log/nagios/status.log
d /
d var
d log
d nagios
? status.log - No such file or directory (2)
atsrvlx02-new:~#
AFAIK the status is writte into the db:
#######################
atsrvlx02-new:/usr/share/doc/nagios-mysql# mysql nagios_db
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6097 to server version: 4.0.21-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables;
+---------------------+
| Tables_in_nagios_db |
+---------------------+
| hostcomments |
| hostdowntime |
| hostextinfo |
| hostretention |
| hoststatus |
| programretention |
| programstatus |
| servicecomments |
| servicedowntime |
| serviceextinfo |
| serviceretention |
| servicestatus |
+---------------------+
12 rows in set (0.00 sec)
mysql> select * from programstatus ;
+---------------------+---------------------+-------------+------------+---------------------+---------------------+------------------------+-------------------------------+
----------------------+----------------------+-----------------------+----------------------+---------------------------+--------------------------+
| last_update | program_start | daemon_mode | nagios_pid | last_command_check | last_log_rotation | execute_service_checks | accept_passive_service_checks |
enable_event_handlers | obsess_over_services | enable_flap_detection | enable_notifications | enable_failure_prediction | process_performance_data |
+---------------------+---------------------+-------------+------------+---------------------+---------------------+------------------------+-------------------------------+
----------------------+----------------------+-----------------------+----------------------+---------------------------+--------------------------+
| 2004-12-07 13:48:50 | 2004-12-07 13:02:05 | 0 | 2054 | 2004-12-07 13:48:49 | 1970-01-01 01:00:00 | 1 | 1 |
1 | 0 | 0 | 1 | 1 | 0 |
+---------------------+---------------------+-------------+------------+---------------------+---------------------+------------------------+-------------------------------+
----------------------+----------------------+-----------------------+----------------------+---------------------------+--------------------------+
1 row in set (0.00 sec)
mysql>
#####################
for more information feel free to contact me at: charlie@uta.at
wbr
charlie
-- System Information:
Debian Release: 3.1
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.9
Locale: LANG=en_GB, LC_CTYPE=en_GB
--
- Because it messes up the order in which you normally read text.
- Why is top-posting such a bad idea?
- Top-posting.
- What is the most annoying thing on Usenet?
---------------------------------------
Received: (at 284599-close) by bugs.debian.org; 9 Dec 2004 15:50:29 +0000
>From seanius@seanius.net Thu Dec 09 07:50:29 2004
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 1CcQYn-0001a8-00; Thu, 09 Dec 2004 07:50:29 -0800
Received: by sativa.seanius.net (Postfix, from userid 1000)
id 89D2F15829; Thu, 9 Dec 2004 10:49:58 -0500 (EST)
Date: Thu, 9 Dec 2004 10:49:58 -0500
From: sean finney <seanius@debian.org>
To: VEGH Karoly <karoly.vegh@uta.at>, 284599-close@bugs.debian.org
Subject: Re: Bug#284599: [Pkg-nagios-devel] Bug#284599: nagios-common: status file search in fs with nagios-mysql
Message-ID: <20041209154958.GB2960@seanius.net>
References: <20041207152313.GA9027@seanius.net> <20041209121048.GL30174@marvin>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="mxv5cy4qt+RJ9ypb"
Content-Disposition: inline
In-Reply-To: <20041209121048.GL30174@marvin>
User-Agent: Mutt/1.5.5.1+cvs20040105i
Delivered-To: 284599-close@bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(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_2004_03_25
X-Spam-Level:
--mxv5cy4qt+RJ9ypb
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On Thu, Dec 09, 2004 at 01:10:48PM +0100, VEGH Karoly wrote:
> I'm absolutley sorry, I did RTFM now awhile, and this problem is=20
> already documented and the fix for it you can find as a hint in the
> /etc/nagios/cgi.cfg:
<snip>
> and in /usr/share/doc/nagios-common/README.Debian.gz under point 4.) it
> is exactly written what and how to do to get this right.
<snip>
> sorry for wasting your time&resources,
no worries, glad the fix worked :)
sean
--=20
--mxv5cy4qt+RJ9ypb
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)
iD8DBQFBuHQmynjLPm522B0RAtsFAJ9d3uqRAu4ZLaBylATxz/Y6kVYiXgCeMMzE
Ipibx+BD8FYpl0s6vOdVU2E=
=qtnE
-----END PGP SIGNATURE-----
--mxv5cy4qt+RJ9ypb--