[imp] IMP 2.2.6 problems

Rich Lafferty rich@horde.org
Tue, 7 Aug 2001 10:25:22 -0400


On Tue, Aug 07, 2001 at 09:19:25AM -0500, Brent J. Nordquist (bjn@horde.org) wrote:
> On Mon, 23 Jul 2001, Daniel Spratlen <spratlen@arches.uga.edu> wrote:
> 
> > Hi, I just downloaded the new rpm's for RH7 for imp 2.2.6 and horde
> > 1.2.6.  I use postgresql.  I proformed my upgrade by getting the three
> > rpm's that I needed, and then rpm -Uvh *.rpm.  That all went fine, but
> > now imp is broken.  Here is what I get:
> >
> > Warning: 1 is not a valid PostgreSQL link resource in
> > /var/www/horde-phplib/db_pgsql.inc on line 52
> 
> I've reproduced this here.  Turns out this is not an RPM issue; it's
> imp/lib/db.pgsql rev 1.1.2.4 from IMP 2.2.5; when I revert that change the
> problem goes away.

As it turns out, that change (going back to persistent database
connections) introduces a different problem which can be a little
problematic when you go into production -- basically, persistent
Postgres connections in PHP don't work as expected, and you can end up
with a lot of open connections to the database that will just wait
around until they time out. (What made me notice the problem in the
first place was that our main machine was using about half a gigabyte
of RAM for its Postgres process -- which was only handling IMP -- with
tens of thousands of open connections!).

But the error message that Daniel showed is symptomatic of a bug in
PHP. The bug's detailed here:

  http://www.php.net/bugs.php?id=9746

This was fixed in PHP 4.0.5. I spoke with Brent on IRC, and he's going
to try it out and, I presume, do the necessary RPM incantations.

Apologies for not noticing this right when it was posted!

So, once again, to prevent bringing a moderately-loaded machine to its
knees, do not do this:

>  	/* echo "dbconnectstring='$dbconnectstring'" ; /* for debugging */
> -	return (($db = pg_connect($dbconnectstring))) ;
> +	return (($db = pg_pconnect($dbconnectstring))) ;
>  }

  -Rich

-- 
Rich Lafferty --------------+-----------------------------------------------
 Montreal, Quebec, Canada   |  Save the Pacific Northwest Tree Octopus!
 http://www.lafferty.ca/    |    http://zapatopi.net/treeoctopus.html
rich@lafferty.ca -----------+-----------------------------------------------


>From chuck@horde.org Date: Tue,  7 Aug 2001 10:28:51 -0400
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 27328 invoked from network); 7 Aug 2001 14:30:46 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.198.7)
  by horde.org with SMTP; 7 Aug 2001 14:30:46 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id 91BAE39F6; Tue,  7 Aug 2001 10:28:51 -0400 (EDT)
Received: from 206.243.191.252 ( [206.243.191.252])
	as user chuck@localhost by marina.horde.org with HTTP;
	Tue,  7 Aug 2001 10:28:51 -0400
Message-ID: <997194531.3b6ffb234a257@marina.horde.org>
Date: Tue,  7 Aug 2001 10:28:51 -0400
From: Chuck Hagenbuch <chuck@horde.org>
To: imp@lists.horde.org
References: <000d01c11f47$57d83210$fe0a0a0a@vilgefort>
In-Reply-To: <000d01c11f47$57d83210$fe0a0a0a@vilgefort>
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] High priority flag...

Quoting Micha³ Biernacki <mbiernacki@supermedia.pl>:

> So... how can I check that the message in the mailbox has
> X-Priority set to 1 (Highest). I would like to show it
> with different colours or sth.

Write a patch to manually parse the headers and check for that one.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
Some fallen angels have their good reasons.


>From chuck@horde.org Date: Tue,  7 Aug 2001 10:29:19 -0400
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 27663 invoked from network); 7 Aug 2001 14:31:13 -0000
Received: from h00104bc60b3c.ne.mediaone.net (HELO marina.horde.org) (24.91.198.7)
  by horde.org with SMTP; 7 Aug 2001 14:31:13 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id 1B75C3A00; Tue,  7 Aug 2001 10:29:20 -0400 (EDT)
Received: from 206.243.191.252 ( [206.243.191.252])
	as user chuck@localhost by marina.horde.org with HTTP;
	Tue,  7 Aug 2001 10:29:19 -0400
Message-ID: <997194559.3b6ffb3ff0059@marina.horde.org>
Date: Tue,  7 Aug 2001 10:29:19 -0400
From: Chuck Hagenbuch <chuck@horde.org>
To: imp@lists.horde.org
References: <Pine.GSO.4.33.0108062041370.24390-100000@tefnut.cam.org>
In-Reply-To: <Pine.GSO.4.33.0108062041370.24390-100000@tefnut.cam.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] another little issue ...

Quoting Frederic Trudeau <ftrudeau@CAM.ORG>:

> the link 'Edit my filter rules', under the 'Filters' section in the
> Options redirecets me to the Options page, altough I can see in the task
> bar that I should normally redirect me to
> domain.com/horde/imp/filters.php.

Are you using pop3 or have you turned off folder use? Right now the filters 
screen wants to make sure that you're allowed to use folders before letting you 
in. Max, maybe the filters can check for folders internally and not show those 
options, instead?

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
Some fallen angels have their good reasons.


>From mbiernacki@supermedia.pl Date:	Tue, 7 Aug 2001 16:34:07 +0200
Return-Path: <mbiernacki@supermedia.pl>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 29121 invoked from network); 7 Aug 2001 14:34:25 -0000
Received: from dns1.supermedia.pl (212.75.96.2)
  by horde.org with SMTP; 7 Aug 2001 14:34:25 -0000
Received: from c4-fe0.jer.warszawa.supermedia.pl ([212.75.96.97]:2564 "EHLO
	vilgefort" smtp-auth: "mbiernacki" TLS-CIPHER: <none>)
	by mail.supermedia.pl with ESMTP id <S1446992AbRHGOeR>;
	Tue, 7 Aug 2001 16:34:17 +0200
From:	=?iso-8859-2?Q?Micha=B3_Biernacki?= <mbiernacki@supermedia.pl>
To:	<imp@lists.horde.org>
Date:	Tue, 7 Aug 2001 16:34:07 +0200
Organization: Super Media Interactive
Message-ID: <000101c11f4e$03f0fe00$fe0a0a0a@vilgefort>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2627
Importance: Normal
In-Reply-To: <997194531.3b6ffb234a257@marina.horde.org>
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Subject: RE: [imp] High priority flag...

> Write a patch to manually parse the headers and check for that one.

Thanks... the patch is written and works fine.

-- 
mb