Nagios,Postgres & RHEL 3

[Robert Bilbrey]

Hi, I am trying to get Nagios working with Postgres 7.4.6 on a RHEL 3 
box. It is a new install.
The make files are generated with Postgres support enabled and 
compilation with make all goes w/o a problem.  Nagios does not seem to 
be picking up the db connection information in the resource file. It 
does pick up the $USER1$ definition in the file. 

I compiled nagios with the following configure settings :

--prefix=/usr/local/nagios --with-command-user=apache 
--with-command-grp=apache \
 --with-cgiurl=/nagios/cgi-bin --with-htmurl=/nagios 
--enable-embedded-perl \
--with-gd-lib=/usr/lib/ --with-gd-inc=/usr/include/ --with-perlcache \
--with-nagios-user=nagios --with-nagios-grp=nagios 
--with-init-dir=/etc/init.d \
  --with-pgsql-lib=/usr/local/pgsql/lib/ 
--with-pgsql-inc=/usr/local/pgsql/include/ --with-pgsql-xdata

 This is the error that Nagios is logging when the service is started.:

[1100823991] Error: Could not connect to PostgreSQL database '' on host 
'' using username '' and password ''.  Status data will not
be saved!
[1100823991] Error: Could not connect to PostgreSQL database '' on host 
'' using username '' 1and password ''.  Retention data will
not be processed or saved!
[1100823991] Error: Could not re-connect to database server on host '' 
for status data.  I'll keep trying every 60 seconds...
[1100823991] Error: Could not connect to PostgreSQL database '' on host 
'' using username '' and password '' for comment data!
[1100823991] Error: Could not connect to PostgreSQL database '' on host 
'' using username '' and password '' for downtime data!

resources.cfg file:
$USER1$=/usr/lib/nagios/plugins

#downtime tables
xdddb_host=127.0.0.1
xdddb_port=5432
xdddb_username=nagios
xdddb_password=xxxxxxxx
xdddb_database=nagiosdata
xdddb_optimize_data=1


#comment tables
xcddb_host=127.0.0.1
xcddb_port=5432
xcddb_username=nagios
xcddb_password=xxxxxxxx
xcddb_database=nagiosdata
xcddb_optimize_data=1

#status tables
xsddb_host=127.0.0.1
xsddb_port=5432
xsddb_username=nagios
xsddb_password=xxxxxxxx
xsddb_database=nagiosdata
xsddb_optimize_data=1
xsddb_optimize_interval=3600

#retention Data
xrddb_host=127.0.0.1
xrddb_port=5432
xrddb_username=nagios
xrddb_password=xxxxxxxx
xrddb_database=nagiosdata
xrddb_optimize_data=1






-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
_______________________________________________
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