help me - nagios access mysql

[Marcos & Marcelo]

Hi Folks,
  
  I finally installed Nagios with Mysql support. I
execute the file create_mysql, which create all tables
in mysql database. However, after configuring the
cgi.cfg, I look at the nagios.log and I receive an
error message like that.

Does anybody know how to solve it?
Is cgi.cfg the only file that need to be configured in
order to make nagios connect to mysql database, or
there are others?
nagios.log
[1077349565] Nagios 1.2 starting... (PID=7621)
[1077349565] Finished daemonizing... (New PID=7622)
[1077349566] Error: Could not read program retention
data from table programretention
[1077349566] Error: Could not read host retention data
from table hostretention
[1077349566] Error: Could not read service retention
data from table serviceretention
[1077349566] Error: Could not lock status data tables
in database ''
[1077349580] Error: Could not lock status data tables
in database ''
[1077349595] Error: Could not lock status data tables
in database ''
[1077349595] SERVICE ALERT:
c3po;FTP;CRITICAL;SOFT;1;Connection refused by host
[1077349610] Error: Could not lock status data tables
in database ''
[1077349625] Error: Could not lock status data tables
in database ''
[1077349629] HOST ALERT:
mmendonc-lap;DOWN;SOFT;1;/bin/ping -n -U -c 1
192.168.1.5
[1077349632] HOST ALERT:
mmendonc-lap;DOWN;SOFT;2;/bin/ping -n -U -c 1
192.168.1.5
[1077349635] HOST ALERT:
mmendonc-lap;DOWN;SOFT;3;/bin/ping -n -U -c 1
192.168.1.5
[1077349638] HOST ALERT:
mmendonc-lap;DOWN;SOFT;4;/bin/ping -n -U -c 1
192.168.1.5
[1077349641] HOST ALERT:
mmendonc-lap;DOWN;SOFT;5;/bin/ping -n -U -c 1
192.168.1.5
[1077349644] HOST ALERT:
mmendonc-lap;DOWN;SOFT;6;/bin/ping -n -U -c 1
192.168.1.5
[1077349647] HOST ALERT:
mmendonc-lap;DOWN;SOFT;7;/bin/ping -n -U -c 1
192.168.1.5
[1077349650] HOST ALERT:
mmendonc-lap;DOWN;SOFT;8;/bin/ping -n -U -c 1
192.168.1.5
[1077349653] HOST ALERT:
mmendonc-lap;DOWN;SOFT;9;/bin/ping -n -U -c 1
192.168.1.5
[1077349656] HOST ALERT:
mmendonc-lap;DOWN;HARD;10;/bin/ping -n -U -c 1
192.168.1.5

cgi.cfg

# DG EXTENDED DATA
xeddb_host=c3po.starwars
xeddb_port=3306
xeddb_database=db
xeddb_username=root
xeddb_password=root

 DB STATUS DATA (Read-Only For CGIs)
xsddb_host=c3po.starwars
xsddb_port=3306
xsddb_database=db
xsddb_username=root
xsddb_password=root

# DB COMMENT DATA (Read-Only For CGIs)
xcddb_host=c3po.starwars
xcddb_port=3306
xcddb_database=db
xcddb_username=root
xcddb_password=root

# DB DOWNTIME DATA (Read-Only For CGIs)
xdddb_host=c3po.starwars
xdddb_port=3306
xdddb_database=db
xdddb_username=root
xdddb_password=root

Thanks,
Marcelo




______________________________________________________________________

Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora:
http://br.yahoo.com/info/mail.html


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&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