<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi all,<br>
<br>
Does anyone have a document on how to set up nagios to use mysql for
its config files?<br>
<br>
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.<br>
<br>
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.<br>
<br>
I have the following set up in nagios.cfg:<br>
<blockquote>xdddb_host=localhost<br>
xdddb_port=3306<br>
xdddb_username=nagios<br>
xdddb_password=********<br>
xdddb_database=nagios<br>
</blockquote>
And I have the following set up in cgi.cfg:<br>
<blockquote>nagios_check_command=/usr/bin/perl
/usr/local/nagios/libexec/check_mysql<br>
</blockquote>
<br>
However, when I look at nagios from my browser it is giving me the
following:<br>
<blockquote>
<div class="dataTitle">Process Status Information</div>
<table class="data" border="1" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td class="stateInfoTable2">
<table border="0">
<tbody>
<tr>
<td class="dataVar">Process Status:</td>
<td class="dataVal">
<div class="processUNKNOWN"> UNKNOWN </div>
</td>
</tr>
<tr>
<td class="dataVar">Check Command Output: </td>
<td class="dataVal">Nagios check command did not return
any output </td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</blockquote>
<br>
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?<br>
<br>
Thank you.<br>
<br>
Trevor Cullingsworth<br>
<br>
<blockquote><br>
</blockquote>
</body>
</html>