From owner-freebsd-stable@FreeBSD.ORG Thu Apr 17 15:55:17 2008 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id B2204106566C for ; Thu, 17 Apr 2008 15:55:17 +0000 (UTC) (envelope-from lists@pingle.org) Received: from willow.pingle.org (willow.pingle.org [208.149.144.13]) by mx1.freebsd.org (Postfix) with ESMTP id 795F68FC15 for ; Thu, 17 Apr 2008 15:55:17 +0000 (UTC) (envelope-from lists@pingle.org) Received: from localhost (unknown [127.0.0.1]) by willow.pingle.org (Postfix) with ESMTP id A4E3511458; Thu, 17 Apr 2008 11:36:08 -0400 (EDT) X-Virus-Scanned: amavisd-new at pingle.org Received: from willow.pingle.org ([127.0.0.1]) by localhost (willow.pingle.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id pmV3F5U2pgvQ; Thu, 17 Apr 2008 11:36:02 -0400 (EDT) Received: from [192.168.130.110] (hpcw.hpcisp.com [208.149.144.9]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: jim) by willow.pingle.org (Postfix) with ESMTP id ADC3A11454; Thu, 17 Apr 2008 11:36:02 -0400 (EDT) Message-ID: <48076E5A.50306@pingle.org> Date: Thu, 17 Apr 2008 11:35:54 -0400 From: Jim Pingle User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: Claus Guttesen References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Cc: FreeBSD Subject: Re: php5 and postgresql 8.2/8.3 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 17 Apr 2008 15:55:17 -0000 Claus Guttesen wrote: >> I have installed php5 with support for postgresql (php5-pgsql). If I >> install postgresql-client ver. 8.2.7 or 8.3.x apache (httpd) >> core-dumps. If I install postgresql-client 8.1.11 or 8.2.6 apache does >> not core-dump. >> >> I have confirmed that it's postgresql which makes apache core dump by >> commenting out pgsql.so in /usr/local/etc/php/extensions.ini. This - >> off-course - prevents me from connecting to my db. :-/ >> >> Apache is ver. 1.3.41 from ports with no changes to the default-values >> during portinstall. PHP is ver. 5.2.5_1. > > Replying to myself (and others :-) ). When compiling php5 statically > with postgresql-support apache no longer core dumps. I added > CONFIGURE_ARGS+=--with-pgsql to /usr/ports/lang/php5/Makefile. > Not sure if this would make much of a difference in your case, but have you tried moving the line for pgsql.so up higher in extensions.ini? I haven't had any trouble with PostgreSQL's PHP extension, but I have with plenty of others (MySQL, recode, imap, sockets, and pspell) when the extensions were not in a specific order. I've documented the issue here: http://www.pingle.org/2006/10/18/php-crashes-extensions http://www.pingle.org/2007/09/22/php-crashes-extensions-workaround More info can be found in the archives as well. If that does alleviate your problem, let me know and I'll add notes for pgsql.so to my workaround. Jim