Bug 104881 – DBD-Pg looks for libpq.so.3 -- libpq.so.4 installed

• Product: Gentoo Linux
• Status: RESOLVED TEST-REQUEST

[Description Daniel Lundin 2005-09-05 05:18:05 UTC]

Both the stable (1.22) and testing versions of DBD-Pg looks for libpq.so.3, but
that is not installed by the libpq ebuild (8.0.3).

Reproducible: Always
Steps to Reproduce:
1. emerge libpq and DBD-Pg
2. Run a perl script that tries to connect to a Postgresql database.
3.

Actual Results:  
The Perl script fails with:
install_driver(Pg) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/x86_64-linux/auto/DBD/Pg/Pg.so' for module
DBD::Pg: libpq.so.3: cannot open shared object file: No such file or directory
at /usr/lib/perl5/5.8.6/x86_64-linux/DynaLoader.pm line 230.
 at (eval 2) line 3
Compilation failed in require at (eval 2) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at /tmp/dbi_test line 8


Expected Results:  
Perl should have connected to the database.

Creating a symlink from libpq.so.4.0 pointing to libpq.so.3 seems to work. (I've
only done a really simple select so far.)

dl@tilia:/usr/lib$ emerge info
Portage 2.0.51.22-r2 (default-linux/amd64/2005.1, gcc-3.4.4, glibc-2.3.5-r1,
2.6.11-gentoo-r6 x86_64)
=================================================================
System uname: 2.6.11-gentoo-r6 x86_64 AMD Opteron(tm) Processor 246
Gentoo Base System version 1.6.13
dev-lang/python:     2.3.5
sys-apps/sandbox:    1.2.11
sys-devel/autoconf:  2.13, 2.59-r6
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6
sys-devel/binutils:  2.15.92.0.2-r10
sys-devel/libtool:   1.5.18-r1
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="amd64"
AUTOCLEAN="yes"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=opteron -mtune=opteron -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.3/env
/usr/kde/3.3/share/config /usr/kde/3.3/shutdown /usr/kde/3/share/config
/usr/lib/X11/xkb /usr/lib/mozilla/defaults/pref /usr/share/config
/usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/
/usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/
/usr/share/texmf/xdvi/ /var/qmail/control"
CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d"
CXXFLAGS="-march=opteron -mtune=opteron -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig buildpkg distlocks fixpackages sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org
http://distro.ibiblio.org/pub/Linux/distributions/gentoo"
LC_ALL="en_US"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="amd64 X a52 alsa apache2 arts avi bash-completion berkdb bitmap-fonts
bonobo browserplugin cdr crypt cups curl doc dv dvdread eds encode esd fam fame
foomaticdb fortran gd gdbm gif gnome gpm gstreamer gtk gtk2 gtkhtml imagemagick
imap imlib ipv6 java jpeg kde libwww livecd lzw lzw-tiff mad mikmod modperl
motif mozdevelop mozilla mozsvg mp3 mpeg mpi mpm-prefork mysql ncurses nls nptl
ogg opengl pam pdflib perl png postgres ppds python qt quicktime readline ruby
sdl slang spell ssl tcltk tcpd tetex threads tiff tlctk truetype-fonts
type1-fonts unicode usb userlocales vorbis wxgtk1 xml xml2 xmmsxpm xprint xv
zlib userland_GNU kernel_linux elibc_glibc"
Unset:  ASFLAGS, CTARGET, LANG, LDFLAGS, LINGUAS, PORTDIR_OVERLAY

[Comment 1 Jakub Moc (RETIRED) 2005-09-05 05:37:21 UTC]

You seem to have stale files from old perl version. Did you run perl-cleaner
after upgrading perl?

[Comment 2 Daniel Lundin 2005-09-07 01:32:23 UTC]

(In reply to comment #1)
> You seem to have stale files from old perl version. Did you run perl-cleaner
> after upgrading perl?

I've never heard of perl-cleaner before (I suppose a message scrolled by when
upgrading perl, but I'm afraid I didn't notice). After running it (perl-cleaner
all) and unmerging/emerging libpq and DBD-Pg the problem persists, however.

(Sorry for the delay; I replied to the email.)

[Comment 3 Jakub Moc (RETIRED) 2005-11-09 09:11:05 UTC]

Mass re-assign.

[Comment 4 Chris White (RETIRED) 2006-01-27 21:45:29 UTC]

is dev-perl/DBD-Pg-1.43 still applicable to this?

[Comment 5 Daniel Lundin 2006-01-28 00:28:23 UTC]

(In reply to comment #4)
> is dev-perl/DBD-Pg-1.43 still applicable to this?
> 
I'm afraid I don't know, as I'm not running DBD-Pg on any Gentoo system for the moment.

[Comment 6 Chris White (RETIRED) 2006-05-21 13:02:39 UTC]

Closing with a test case request.