pkg/26002: pkgsrc: php4-pgsql has a dependency problem

[acruhl%gmail.com@localhost]

>Number:         26002
>Category:       pkg
>Synopsis:       pkgsrc: php4-pgsql has a dependency problem
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Mon Jun 21 21:27:00 UTC 2004
>Closed-Date:
>Last-Modified:
>Originator:     Andy Ruhl
>Release:        2.0E i386
>Organization:
>Environment:
# uname -a
NetBSD bugs.homeunix.net 2.0E NetBSD 2.0E (GENERIC) #0: Tue May 18 03:46:15 
CEST 2004  
tron%lyssa.zhadum.de@localhost:/export/scratch/tron/build.19008a/obj/sys/arch/i386/compile/GENERIC
 i386
>Description:
# apachectl start
[1]   Abort trap (core dumped) ${HTTPD}
/usr/pkg/sbin/apachectl start: httpd could not be started


>How-To-Repeat:
pkgsrc php4-pgsql seems to depend on postgresql-libs. It works fine at 
postgresql level 7.3, but causes a core dump of apache when postgresql 7.4 is 
installed.

I built packages out of both so I could experiment:

php-pgsql-4.3.6nb2.tgz
postgresql-lib-7.3.4nb2.tgz

I decided I wanted to be at postgresql 7.4.x, so I did a pkg_delete on the 
above two packages. I did a make package and installed all of the postgresql 
7.4.x packages:

postgresql-docs-7.4.2.tgz
postgresql-7.4.2nb1.tgz
postgresql-lib-7.4.2nb1.tgz
postgresql-client-7.4.2nb1.tgz
postgresql-server-7.4.2.tgz

I then did a pkg_add on the php-pgsql-4.3.6nb2.tgz package from above, and it 
installed fine (postgresql-lib-7.4.2 must have satisfied it).

However, when I stopped and started apache, I got this:

# apachectl start
[1]   Abort trap (core dumped) ${HTTPD}
/usr/pkg/sbin/apachectl start: httpd could not be started


>Fix:
This is only a workaround:

I confirmed that this problem is related to the php4-pgsql package because I 
commented out this line in the php.ini file:

;extension=pgsql.so

And then apache starts:

# apachectl start
/usr/pkg/sbin/apachectl start: httpd started

If I uninstall all posgresql 7.4.x packages, then install 
posgresql-lib-7.3.4nb2.tgz, then uncomment the above line in php.ini, apache 
will start again. The problem seems to be specifically with upgrading the 
postgresql-lib package from 7.3.x to 7.4.x. I am not able to load the pgsql 
module into php at posgresql 7.4.x.
>Release-Note:
>Audit-Trail:
>Unformatted: