Nagios,Postgres & RHEL 3

[Jose Galiana]

Hi,
I did have the same problem.

You can try to install Postgres 8.0.0 Beta, it works better than 7.4.6.

Have a nice day.




----- Original Message ----- 
From: "Robert Bilbrey" <rbilbrey at cymark.com>
To: <Nagios-users at lists.sourceforge.net>
Sent: Friday, December 03, 2004 5:09 AM
Subject: [Nagios-users] Nagios,Postgres & RHEL 3


> 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



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