help me - nagios access mysql

[Dan Hopkins]

> -----Original Message-----
> From: Marcos & Marcelo [mailto:gemeosdf at yahoo.com.br]
> Sent: 05 April 2004 00:35
> To: nagios_list
> Subject: [Nagios-users] help me - nagios access mysql
 
<snip>

> [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 ''

<snip>
 
> 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


Make sure your resource.cfg DB entries match the cgi.cgi entries (cgi.cfg
for CGI's, resource.cfg for the Nagios daemon) 

-- 
Dan Hopkins
Systems Developer, easynet Ltd.
e: dan.hopkins at uk.easynet.net
t: +44(0) 1749 333305


-------------------------------------------------------
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