using mysql

[Trevor Cullingsworth]

Hi all,

Does anyone have a document on how to set up nagios to use mysql for its 
config files?

Right now, I have nagios 1.2 compiled with mysql support.  I also have 
Nagmin running and I have mysql set up.  When I configured Nagmin, I was 
able to populate a mysql database that I called "nagios" from info 
extrapolated from the nagios .cfg files - hosts.cfg, hostgroups.cfg, 
contactgroups.cfg, etc.

I want to have nagios check against this database for its monitoring 
rather than use the flat .cfg files.  I have not gotten this to work.  
If I change an IP address of a host I want to check in the mysql 
database, nagios still continues to check the IP address of the host  
that is configured in the hosts.cfg file for example.

I have the following set up in nagios.cfg:

    xdddb_host=localhost
    xdddb_port=3306
    xdddb_username=nagios
    xdddb_password=********
    xdddb_database=nagios

And I have the following set up in cgi.cfg:

    nagios_check_command=/usr/bin/perl /usr/local/nagios/libexec/check_mysql


However, when I look at nagios from my browser it is giving me the 
following:

    Process Status Information
    Process Status: 	
      UNKNOWN  
    Check Command Output:  	Nagios check command did not return any output 


How can I get nagios to use the hosts, contactgroup, etc. from the mysql 
database instead of the *.cfg files under the Nagios home etc directory?

Thank you.

Trevor Cullingsworth


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20050506/4f76cb93/attachment.html>