Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 17 Apr 2008 11:35:54 -0400
From:      Jim Pingle <lists@pingle.org>
To:        Claus Guttesen <kometen@gmail.com>
Cc:        FreeBSD <freebsd-stable@freebsd.org>
Subject:   Re: php5 and postgresql 8.2/8.3
Message-ID:  <48076E5A.50306@pingle.org>
In-Reply-To: <b41c75520804170620j32758dep36ef01a8f37430bd@mail.gmail.com>
References:  <b41c75520804170505h31769efycafb0a238c78aa24@mail.gmail.com> <b41c75520804170620j32758dep36ef01a8f37430bd@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?48076E5A.50306>