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--