RES: [imp] Postgres and Persistent Conections

[Alexander E. Belck]

I tryed to set 'pgsql.max_persistent = 3' in php.ini where I got
unable to login. Then I set it to 10, where I could login, but
after browsing some messages I got the same errors as when
trying to login with 'pgsql.max_persistent = 3'. Following
is one of this errors:

Warning: PostgreSQL query failed: pqReadData() -- read() failed: errno=32
Broken pipe in /home/vhost/spsul.com.br/www/horde/imp/lib/db.pgsql on line
100

The erro occurs in diferent lines (I remamber 82 too).

I also tryed to set 'pgsql.allow_persistent = Off' where I got the same
error in .../lib/db.pgsql

Thanks
Alex

-----Mensagem original-----
De: Martin A. Marques [mailto:martin@math.unl.edu.ar]
Enviada em: quinta-feira, 1 de março de 2001 19:29
Para: imp@lists.horde.org
Assunto: Re: [imp] Postgres and Persistent Conections


Mensaje citado por: "Alexander E. Belck" <alexb@iol.psi.br>:

> > I'm trying to use horde-1.2.4 with imp-2.2.4 with Postgres wher I
> still
> > (I'm upgrading from 1.2.3/2.2.3) have problems with persistent
> conections.
> > I searched all documents and found that .../hord/imp/lib/db.pgsql at
> > function imp_open_pg_db() still use 'pg_pconnect'.
> >
> > I tryed to modify this to 'pg_connect' but this generates a lot of
> erros
> > when I try to login at IMP.
> >
> > Does someby knows how to use horde/imp with Postgres without
> generating a
> > lot of idle postgres processes that seams never to end ?

In the php.ini file, lower down the amount of persistent conections to 2 or
3,
and wait for PHP-4.0.5 to come out, which will have the persistent conection
problem resolved (as I heard)

Saludos... :-)


System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Martín Marqués                  email:  martin@math.unl.edu.ar
Santa Fe - Argentina            http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

--
IMP mailing list: http://horde.org/imp/
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: imp-unsubscribe@lists.horde.org





>From chuck@horde.org Date: Thu,  1 Mar 2001 20:34:29 -0500
Return-Path: <chuck@horde.org>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 18184 invoked from network); 2 Mar 2001 01:35:29 -0000
Received: from 208-59-178-62.c3-0.smr-ubr1.sbo-smr.ma.cable.rcn.com (HELO marina.horde.org) (208.59.178.62)
  by horde.org with SMTP; 2 Mar 2001 01:35:29 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id 7554C3CA9; Thu,  1 Mar 2001 20:34:29 -0500 (EST)
Received: from 192.168.0.198 ( [192.168.0.198])
	as user chuck@marina.horde.org by marina.horde.org with HTTP;
	Thu,  1 Mar 2001 20:34:29 -0500
Message-ID: <983496869.3a9ef8a51503e@marina.horde.org>
Date: Thu,  1 Mar 2001 20:34:29 -0500
From: Chuck Hagenbuch <chuck@horde.org>
To: imp@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [imp] Performance

Quoting David Richards <d.richards@qut.edu.au>:

> Most connections are made using http only, so session storage is not too
> much of an issue.

That statement doesn't make sense... If you're using IMP 2.2, then you have 
phplib for sessions, and it has to be storing them somewhere...

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"We have no fuel on board, plus or minus 8 kilograms." -A NASA scientist


>From chuck@horde.org Date: Thu,  1 Mar 2001 20:40:51 -0500
Return-Path: <chuck@horde.org>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 19227 invoked from network); 2 Mar 2001 01:41:51 -0000
Received: from 208-59-178-62.c3-0.smr-ubr1.sbo-smr.ma.cable.rcn.com (HELO marina.horde.org) (208.59.178.62)
  by horde.org with SMTP; 2 Mar 2001 01:41:51 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id 394933CA9; Thu,  1 Mar 2001 20:40:51 -0500 (EST)
Received: from 192.168.0.198 ( [192.168.0.198])
	as user chuck@marina.horde.org by marina.horde.org with HTTP;
	Thu,  1 Mar 2001 20:40:51 -0500
Message-ID: <983497251.3a9efa231ce90@marina.horde.org>
Date: Thu,  1 Mar 2001 20:40:51 -0500
From: Chuck Hagenbuch <chuck@horde.org>
To: imp@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [imp] why can't I login?

Quoting Jonathan Ellis <jbellis@hotmail.com>:

> > Anything in your apache logs?
> 
> No.  (And again, I'm running aolserver.)

Okay. Sorry if I'm backtracking (too many vaguely similar problem descriptions 
in the last few days).

- You're using IMP 2.2.x, correct?

- When you go to test.php3 and click on the phplib session test, does the 
counter increment?

- If not, that's your problem, and you need to get that working

- If so, then you need to figure out why IMP isn't even trying to connect to 
the imap server when you log in. There isn't a surefire way to do this, but 
looking in mailbox.php3 in the login case, seeing if $imp->authenticate() ever 
gets called, and in any case, seeing where things bomb out, is probably the 
best way to go about it.

- One thing to check, if you're running php4, is that you have register_globals 
= On. IMP 2.2 won't work with it off.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"We have no fuel on board, plus or minus 8 kilograms." -A NASA scientist