Nagios with Postgresql

[JOSE GALIANA]

Hi all!

I am trying to install Nagios 1.2 with Postgresql 7.2.1, in a Linux Debian 3.0 R2 Kernel 2.4

I make binaries with commands :

Base
./configure --prefix=/usr/local/nagios --with-nagios-user=nagios --with-nagios-group=nagios 
--with-cgiurl=/nagios/cgi-bin --with-gd-lib=/usr/lib --with-gd-inc=/usr/lib --with-htmurl=/nagios --with-pgsql-xdata 
--with-pgsql-downtime --with-pgsql-comments --with-pgsql-status --with-pgsql-retention --with-pgsql-extinfo 
--with-pgsql-lib=/usr/lib/postgresql/lib --with-pgsql-inc=/usr/lib/postgresql/lib

Plugins
./configure --prefix=/usr/local/nagios --with-nagios-user=nagios --with-nagios-group=nagios 
--with-cgiurl=/nagios/cgi-bin --with-pgsql=/usr/lib/postgresql

Problem:
When Nagios starts the Event Log show

Nagios 1.2 starting ...
Finished daemonizing ...
Error: Could not insert/update status record for program in table 'programstatus' of database 'nagios'
Error: Could not insert/update status record for program in table 'programstatus' of database 'nagios'
......
Error: Could not insert/update status record for program in table 'programstatus' of database 'nagios'
Caught SIGSEGV, shutting down....


I can access Database and insert data in tables with others programs like PHPpgadmin, but Nagios can't.
The user logged to do this in PHPpgadmin is the same for files cgi.cfg and resources.cfg .

Any solution ?

Thanks

Gal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20041109/5f4194c4/attachment.html>