Nagios with MySql

[Ben Clewett]

Andreoni Antonella wrote:
> Hi all
> 
> I've just started Nagios with database support but it doesn't work
> 
> on the web interface I got the following error:
> 
> Whoops!
> Error: Could not read host and service status information!
> 
> And in the log file nagios.log there is the following error message
> [1085497246] Error: Could not lock status data tables in database 'nagios'

Just a pre-check: Did you run the provided script to create the database?

Something like:

$ cd contrib/database
$ cat create_myqsl | mysql -u $USER -p$PASS -D $DATABASE -h $HOST

Where $USER $PASS $DATABASE and $HOST have been correctly setup, and are 
(probably) the same as those used in nagios.cfg?

Ben


-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null