<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Gracias!</FONT></DIV>
<DIV><FONT face=Arial size=2>Lo he conseguido solucionar actualizando PostgreSql
a la versión 8.0.0.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks!</FONT></DIV>
<DIV><FONT face=Arial size=2>I have installed version of PostgreSQL 8.0.0
and problem has finished.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gal</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=josefranciscogaliana.ruralcaja@cajarural.com
href="mailto:josefranciscogaliana.ruralcaja@cajarural.com">JOSE GALIANA</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=nagios-users@lists.sourceforge.net
href="mailto:nagios-users@lists.sourceforge.net">Nagios</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, November 09, 2004 1:10
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Nagios-users] Nagios with
Postgresql</DIV>
<DIV><FONT face=Arial size=2></FONT><BR></DIV>
<DIV><FONT face=Arial size=2>Hi all!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am trying to install Nagios 1.2 with Postgresql
7.2.1, in a Linux Debian 3.0 R2 Kernel 2.4</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I make binaries with commands :</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Base</FONT></DIV>
<DIV><FONT face=Arial size=2>./configure --prefix=/usr/local/nagios
--with-nagios-user=nagios --with-nagios-group=nagios </FONT></DIV>
<DIV><FONT face=Arial size=2>--with-cgiurl=/nagios/cgi-bin
--with-gd-lib=/usr/lib --with-gd-inc=/usr/lib --with-htmurl=/nagios
--with-pgsql-xdata </FONT></DIV>
<DIV><FONT face=Arial size=2>--with-pgsql-downtime --with-pgsql-comments
--with-pgsql-status --with-pgsql-retention --with-pgsql-extinfo </FONT></DIV>
<DIV><FONT face=Arial size=2>--with-pgsql-lib=/usr/lib/postgresql/lib
--with-pgsql-inc=/usr/lib/postgresql/lib</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Plugins</FONT></DIV>
<DIV><FONT face=Arial size=2>./configure --prefix=/usr/local/nagios
--with-nagios-user=nagios --with-nagios-group=nagios </FONT></DIV>
<DIV><FONT face=Arial size=2>--with-cgiurl=/nagios/cgi-bin
--with-pgsql=/usr/lib/postgresql</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial size=2>
<DIV>Problem:</DIV>
<DIV>When Nagios starts the Event Log show</DIV>
<DIV> </DIV>
<DIV>Nagios 1.2 starting ...<BR>Finished daemonizing ...<BR>Error: Could not
insert/update status record for program in table 'programstatus' of database
'nagios'<BR>Error: Could not insert/update status record for program in table
'programstatus' of database 'nagios'<BR>......<BR>Error: Could not
insert/update status record for program in table 'programstatus' of database
'nagios'<BR>Caught SIGSEGV, shutting down....</DIV>
<DIV> </DIV>
<DIV><BR>I can access Database and insert data in tables with others programs
like PHPpgadmin, but Nagios can't.<BR>The user logged to do this in PHPpgadmin
is the same for files cgi.cfg and resources.cfg .</DIV>
<DIV> </DIV>
<DIV>Any solution ?</DIV>
<DIV> </DIV>
<DIV>Thanks</DIV>
<DIV> </DIV>
<DIV>Gal</FONT></DIV></BLOCKQUOTE></BODY></HTML>