>Number:         31293
>Category:       pkg
>Synopsis:       link problem postgresql80-plperl with libperl
>Confidential:   no
>Severity:       critical
>Priority:       high
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Sun Sep 11 17:25:00 +0000 2005
>Originator:     cg@cgall.de
>Release:        NetBSD 3.0_BETA
>Environment:
System: NetBSD cg 3.0_BETA NetBSD 3.0_BETA (CG) #4: Wed Sep  7 18:17:05 CEST 2005  root@cg:/usr/obj/sys/arch/i386/compile/CG i386
Architecture: i386
Machine: i386
>Description:
$ createlang plperl 
createlang: language installation failed: ERROR:  could not load library
"/usr/pkg/lib/postgresql/plperl.so": Shared object "libperl.so" not found



$ uname -a
NetBSD cg 3.0_BETA NetBSD 3.0_BETA (CG) #4: Wed Sep  7 18:17:05 CEST 2005  root@cg:/usr/obj/sys/arch/i386/compile/CG i386
$ id
uid=1003(pgsql) gid=1000(pgsql) groups=1000(pgsql)

$ ldd /usr/pkg/lib/postgresql/plperl.so
/usr/pkg/lib/postgresql/plperl.so:
	-lperl => not found
	-lm.0 => /usr/lib/libm387.so.0
	-lm.0 => /usr/lib/libm.so.0
	-lcrypt.0 => /usr/lib/libcrypt.so.0
	-lpthread.0 => /usr/lib/libpthread.so.0

$ pkg_info | grep postgres                                                                                          
postgresql80-plperl-8.0.3 PL/Perl procedural language for the PostgreSQL backend
postgresql80-server-8.0.3nb2 PostgreSQL database server programs
postgresql80-client-8.0.3nb2 PostgreSQL database client programs

$ perl -V
Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
  Platform:
    osname=netbsd, osvers=3.0_beta, archname=i386-netbsd-thread-multi
    uname='netbsd cg 3.0_beta netbsd 3.0_beta (cg) #4: wed sep 7 18:17:05 cest 2005 root@cg:usrobjsysarchi386compilecg i386 '
    config_args='-sde -Darchname=i386-netbsd -Dcc=cc -Doptimize=-O2  -pthread  -I/usr/include -Duseshrplib -Ui_malloc -Uusemymalloc -Uinstallusrbinperl -Dinstallstyle=lib/perl5 -Dprefix=/usr/pkg -Dsiteprefix=/usr/pkg -Dvendorprefix=/usr/pkg -Dscriptdir=/usr/pkg/lib/perl5/bin -Dsitescript=/usr/pkg/lib/perl5/site_perl/bin -Dvendorscript=/usr/pkg/lib/perl5/vendor_perl/bin -Dprivlib=/usr/pkg/lib/perl5/5.8.0 -Dsitelib=/usr/pkg/lib/perl5/site_perl/5.8.0 -Dvendorlib=/usr/pkg/lib/perl5/vendor_perl/5.8.0 -Dman1ext=1 -Dman1dir=/usr/pkg/lib/perl5/man/man1 -Dsiteman1dir=/usr/pkg/lib/perl5/site_perl/man/man1 -Dvendorman1dir=/usr/pkg/lib/perl5/vendor_perl/man/man1 -Dman3ext=3 -Dman3dir=/usr/pkg/lib/perl5/man/man3 -Dsiteman3dir=/usr/pkg/lib/perl5/site_perl/man/man3 -Dvendorman3dir=/usr/pkg/lib/perl5/vendor_perl/man/man3 -Daphostname=/bin/hostname -Dln=/bin/ln -Dsed=/usr/bin/sed -Dissymlink=test -h -Duseithreads -Dlibswanted=m crypt '
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-fno-strict-aliasing -pipe -I/usr/pkg/include',
    optimize='-O2 -pthread -I/usr/include',
    cppflags='-fno-strict-aliasing -pipe -I/usr/pkg/include'
    ccversion='', gccversion='3.3.3 (NetBSD nb3 20040520)', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=4, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -Wl,-R/usr/pkg/lib  -pthread  -L/usr/pkg/lib'
    libpth=/usr/pkg/lib /usr/lib
    libs=-lm -lcrypt -lpthread
    perllibs=-lm -lcrypt -lpthread
    libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E  -Wl,-R/usr/pkg/lib/perl5/5.8.0/i386-netbsd-thread-multi/CORE'
    cccdlflags='-DPIC -fPIC ', lddlflags=' -Wl,-R/usr/pkg/lib  -pthread --whole-archive -shared  -L/usr/pkg/lib'


Characteristics of this binary (from libperl): 
  Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
                        PERL_IMPLICIT_CONTEXT
  Built under netbsd
  Compiled at Sep  9 2005 23:45:48
  @INC:
    /usr/pkg/lib/perl5/site_perl/5.8.0/i386-netbsd-thread-multi
    /usr/pkg/lib/perl5/site_perl/5.8.0
    /usr/pkg/lib/perl5/site_perl/5.8.0
    /usr/pkg/lib/perl5/vendor_perl/5.8.0/i386-netbsd-thread-multi
    /usr/pkg/lib/perl5/vendor_perl/5.8.0
    /usr/pkg/lib/perl5/vendor_perl/5.8.0
    /usr/pkg/lib/perl5/5.8.0/i386-netbsd-thread-multi
    /usr/pkg/lib/perl5/5.8.0
    .

>Fix:

Unknown