Nagios with Postgresql

[JOSE GALIANA]

Gracias!
Lo he conseguido solucionar actualizando PostgreSql a la versión 8.0.0.

Thanks!
I have installed version of PostgreSQL 8.0.0 and problem has finished.

Gal
  ----- Original Message ----- 
  From: JOSE GALIANA 
  To: Nagios 
  Sent: Tuesday, November 09, 2004 1:10 PM
  Subject: [Nagios-users] Nagios with Postgresql


  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/20041111/9060db96/attachment.html>