mysql - Nagios not talknig

[spdesai at gnvfc.net]

Hello 
I have configured mysql in nagios in cgi.cfg and resourse.cfg...
also created the required tables in mysql...with all privilages..as per below..

xsddb_host=localhost
xsddb_port=3306
xsddb_database=nagios
xsddb_username=noc
xsddb_password=noc

xcddb_host=localhost
xcddb_port=3306
xcddb_database=nagios
xcddb_username=noc
xcddb_password=noc

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

and mysql configuration are as below..

mysql> show tables;
+------------------+
| Tables_in_nagios |
+------------------+
| hostcomments     |
| hostdowntime     |
| hostextinfo      |
| hostretention    |
| hoststatus       |
| programretention |
| programstatus    |
| servicecomments  |
| servicedowntime  |
| serviceextinfo   |
| serviceretention |
| servicestatus    |
+------------------+
12 rows in set (0.00 sec)

and given all privilages to noc user for all tables 

GRANT ALL PRIVILEGES on *.* to noc;

But mysql and nagios not talking with eachother..

Kindly give me the solutions..

thanks in advance

-suhag.



-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/



-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you shotput
a projector? How fast can you ride your desk chair down the office luge track?
If you want to score the big prize, get to know the little guy.  
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
_______________________________________________
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