Hi. 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. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare
> 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.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. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare
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 |
this problem is very old for me. it goes, at least from http://www.freebsd.org/cgi/query-pr.cgi?pr=97272 I found a workaround: you simply should set ServerName foobar.emxample in httpd.conf i don't know why missing ServerName causes coredump of apache in case of php+php_pgsql, but this works for me -- SY, Marat