From owner-freebsd-stable@FreeBSD.ORG Thu Apr 17 14:03:54 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 A4B1A106564A for ; Thu, 17 Apr 2008 14:03:54 +0000 (UTC) (envelope-from jdc@parodius.com) Received: from mx01.sc1.parodius.com (mx01.sc1.parodius.com [72.20.106.3]) by mx1.freebsd.org (Postfix) with ESMTP id 9C12A8FC16 for ; Thu, 17 Apr 2008 14:03:54 +0000 (UTC) (envelope-from jdc@parodius.com) Received: by mx01.sc1.parodius.com (Postfix, from userid 1000) id 79EDE1CC033; Thu, 17 Apr 2008 07:03:54 -0700 (PDT) Date: Thu, 17 Apr 2008 07:03:54 -0700 From: Jeremy Chadwick To: Claus Guttesen Message-ID: <20080417140354.GA84662@eos.sc1.parodius.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.17 (2007-11-01) 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 14:03:54 -0000 On Thu, Apr 17, 2008 at 02:05:27PM +0200, 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. > > This is the output (backtrace) from gdb: > > (gdb) bt > #0 0x000000080651c340 in ?? () > #1 0x000000080094ebd5 in puts () from /lib/libc.so.7 > #2 0x000000080094f1ee in gethostbyname () from /lib/libc.so.7 > #3 0x000000000041ee80 in ap_get_local_host () > #4 0x000000000041e131 in ap_fini_vhost_config () > #5 0x000000000040de35 in ap_read_config () > #6 0x00000000004156f1 in standalone_main () > #7 0x0000000000416e2c in main () > > 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. Last night I migrated one of my machines from mysql51 to postgresql83, which included adding php5-pgsql to my extensions list. I have absolutely no problems. I'm using Apache 2.2, however. $ pkg_info | egrep 'apache|php5-pgsql|postgres' apache-2.2.8 Version 2.2 of Apache web server with prefork MPM. php5-pgsql-5.2.5_1 The pgsql shared extension for php postgresql-client-8.3.1 PostgreSQL database (client) postgresql-server-8.3.1 The most advanced open-source database available anywhere -- | Jeremy Chadwick jdc at parodius.com | | Parodius Networking http://www.parodius.com/ | | UNIX Systems Administrator Mountain View, CA, USA | | Making life hard for others since 1977. PGP: 4BD6C0CB |