[Nagiosplug-help] nagios-mysql issues
trent at unt.edu
Thu Dec 2 08:38:02 CET 2004
I've configured nagios text several times successfully but I can't the
the database bit working.
I'm currently using MySQL 4.02 and Nagios 1.2 on FreeBSD 5.3. It would
be nice to know what version of MySQL Nagios wants.
I created the nagios database manually with the mysql root account. I
mysql -u root nagios < create_mysql. I verified that the tables were
I then ran GRANT SELECT, INSERT, UPDATE, DELETE ON nagios.* TO
nagios at localhost IDENTIFIED BY 'password';
and GRANT LOCK TABLES ON nagios.* TO nagios at localhost IDENTIFIED BY
from the mysql prompt.
I've copied the check_nagios_db.pl over to /usr/local/share/nagios/ and
pointed at it in cgi.cfg.
I've edited the database sections in cgi.cfg and resource.cfg with the
appropriate database info.
Nagios starts fine from the startup script but then acts like its not
running or can't get status when I view the web page.
1101979948] Nagios 1.2 starting... (PID=27143)
 Finished daemonizing... (New PID=27144)
 Error: Could not read program retention data from table
 Error: Could not read host retention data from table
 Error: Could not read service retention data from table
 Error: Could not lock status data tables in database ''
No errors in mysqld log.
Thanks for any help.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 1489 bytes
Desc: not available
More information about the Help