Bug#284599: [Pkg-nagios-devel] Bug#284599: nagios-common: status file search in fs with nagios-mysql
sean finney
sean finney <seanius@debian.org>, 284599@bugs.debian.org
Tue, 7 Dec 2004 10:23:13 -0500
--82I3+IH0IqGh5yIs
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
tags 284599 pending
thanks
i believe this problem is fixed in the version currently making its
way through sid to sarge. can you give that version a try and verify
that it works? if you don't want to bother with grabbing something
=66rom sid, you can either wait a week and a half for it to make
its way to sarge, or i can send you the init script from the
newest version.
sean
On Tue, Dec 07, 2004 at 01:58:57PM +0100, karoly.vegh@uta.at wrote:
> Package: nagios-common
> Severity: important
>=20
>=20
> I'm running debian sarge.
>=20
> 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 administra=
tion
> ii mysql-admin-co 1.0.12-1 Architecture independent files for MySQ=
L 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 m=
anage
> ii nagios-mysql 1.3-0+pre4 A host/service/network monitoring and m=
anage
> ii nagios-plugins 1.3.1.0-12 Plugins for the nagios network monitori=
ng 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:~#=20
>=20
> atsrvlx02-new:~# /etc/init.d/nagios reload=20
> Reloading nagios configuration files.
> Not running.
> atsrvlx02-new:~#=20
>=20
> though:
>=20
> 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:~#
>=20
> The initscript searches for /var/log/nagios/status.log
>=20
> 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:~#
>=20
> AFAIK the status is writte into the db:
>=20
> #######################
> 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
>=20
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 6097 to server version: 4.0.21-log
>=20
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>=20
> 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)
>=20
> mysql> select * from programstatus ;=20
> +---------------------+---------------------+-------------+------------+-=
--------------------+---------------------+------------------------+-------=
------------------------+
> ----------------------+----------------------+-----------------------+---=
-------------------+---------------------------+--------------------------+
> | 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 | en=
able_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)
>=20
> mysql>
>=20
> #####################
>=20
>=20
> for more information feel free to contact me at: charlie@uta.at
>=20
>=20
> wbr
>=20
> charlie
>=20
> -- 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=3Den_GB, LC_CTYPE=3Den_GB
>=20
> --=20
> - 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?
>=20
>=20
> _______________________________________________
> Pkg-nagios-devel mailing list
> Pkg-nagios-devel@lists.alioth.debian.org
> http://lists.alioth.debian.org/mailman/listinfo/pkg-nagios-devel
--=20
--82I3+IH0IqGh5yIs
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)
iD8DBQFBtcrhynjLPm522B0RAuvBAJ4wTaHte4+gqLIGPqOqiHHrjNY3UACZAer3
Q84a7z9Z2MF10oQV/3m1qjg=
=Khhp
-----END PGP SIGNATURE-----
--82I3+IH0IqGh5yIs--