Problem with the installation of DBD::Pg

Olivier ARNAIZ <Olivier.Arnaiz-YdWU2LU/[email protected]>
Newsgroups gmane.comp.db.postgresql.dbdpg
Message-ID <[email protected]>
Hello,

I try to install DBD::Pg but I have some trouble. I have tried with cpan
and with the sources directly.

My OS :Linux FC4
Perl : 5.8.6
PostgreSQL : 7.04.13
DBI : 1.51 (cpan version)
DBD::Pg : 1.49 

The 'make test failed, and if I force the installation, I always have
the error :

[olivier@nestor ~]$ perl test.pl
install_driver(Pg) failed: Can't load '/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/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/i386-linux-thread-multi/DynaLoader.pm line 230.
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at test.pl line 7


Any suggestions ?

Thanks
Olivier

My log when I install DBD::Pg :


[olivier@nestor DBD-Pg-1.49]$ perl Makefile.PL
Configuring DBD::Pg 1.49
Remember to actually read the README file!
OS: linux
PostgreSQL version: 70413 (default port: 5432)
Using DBI 1.51 (for perl 5.008006 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::Pg


[olivier@nestor DBD-Pg-1.49]$ make
cp Pg.pm blib/lib/DBD/Pg.pm
/usr/bin/perl -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/" /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI/Driver.xst > Pg.xsi
/usr/bin/perl /usr/lib/perl5/5.8.6/ExtUtils/xsubpp  -typemap /usr/lib/perl5/5.8.6/ExtUtils/typemap  Pg.xs > Pg.xsc && mv Pg.xsc Pg.c
gcc -c  -I/usr/local/pgsql/include -I/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -DPGLIBVERSION=70413 -DPGDEFPORT=5432 -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables  -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"1.49\" -DXS_VERSION=\"1.49\" -fPIC "-I/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE"   Pg.c
gcc -c  -I/usr/local/pgsql/include -I/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -DPGLIBVERSION=70413 -DPGDEFPORT=5432 -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables  -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"1.49\" -DXS_VERSION=\"1.49\" -fPIC "-I/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE"   dbdimp.c
gcc -c  -I/usr/local/pgsql/include -I/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -DPGLIBVERSION=70413 -DPGDEFPORT=5432 -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables  -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"1.49\" -DXS_VERSION=\"1.49\" -fPIC "-I/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE"   quote.c
gcc -c  -I/usr/local/pgsql/include -I/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -DPGLIBVERSION=70413 -DPGDEFPORT=5432 -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables  -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"1.49\" -DXS_VERSION=\"1.49\" -fPIC "-I/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE"   types.c
Running Mkbootstrap for DBD::Pg ()
chmod 644 Pg.bs
rm -f blib/arch/auto/DBD/Pg/Pg.so
gcc  -shared -L/usr/local/lib Pg.o dbdimp.o quote.o types.o  -o blib/arch/auto/DBD/Pg/Pg.so   -L/usr/local/pgsql/lib -lpq
chmod 755 blib/arch/auto/DBD/Pg/Pg.so
cp Pg.bs blib/arch/auto/DBD/Pg/Pg.bs
chmod 644 blib/arch/auto/DBD/Pg/Pg.bs
Manifying blib/man3/DBD::Pg.3pm


[olivier@nestor DBD-Pg-1.49]$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00-signature......gpg: Signature made Fri 05 May 2006 03:54:36 PM UTC using DSA key ID 14964AC8
gpg: Can't check signature: public key not found
t/00-signature......ok
        1/1 skipped: Module::Signature cannot verify
t/00basic...........NOK 2
#   Failed test 'use DBD::Pg;'
#   in t/00basic.t at line 11.
#     Tried to use 'DBD::Pg'.
#     Error:  Can't load '/home/olivier/Desktop/DBD-Pg-1.49/blib/arch/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/i386-linux-thread-multi/DynaLoader.pm line 230.
#  at (eval 6) line 2
# Compilation failed in require at (eval 6) line 2.
# BEGIN failed--compilation aborted at t/00basic.t line 11.
t/00basic...........ok 3/3# Looks like you failed 1 test of 3.
t/00basic...........dubious
        Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 2
        Failed 1/3 tests, 66.67% okay
t/01connect.........Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
Use of uninitialized value in concatenation (.) or string at t/01connect.t line 74.
#
# Program               Version
# Perl                  5.8.6 (linux)
# DBD::Pg
# PostgreSQL (compiled)
# PostgreSQL (target)
# PostgreSQL (reported)
# Default port
# DBI                   1.51
# DBI_DSN
skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file.
t/01constants.......Can't load '/home/olivier/Desktop/DBD-Pg-1.49/blib/arch/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/i386-linux-thread-multi/DynaLoader.pm line 230.
 at t/01constants.t line 4
Compilation failed in require at t/01constants.t line 4.
BEGIN failed--compilation aborted at t/01constants.t line 4.
# Looks like your test died before it could output anything.
t/01constants.......dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-28
        Failed 28/28 tests, 0.00% okay
t/01setup...........skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file.
t/02attribs.........skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/03dbmethod........Can't load '/home/olivier/Desktop/DBD-Pg-1.49/blib/arch/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/i386-linux-thread-multi/DynaLoader.pm line 230.
 at t/03dbmethod.t line 16
Compilation failed in require at t/03dbmethod.t line 16.
BEGIN failed--compilation aborted at t/03dbmethod.t line 16.
# Looks like your test died before it could output anything.
t/03dbmethod........dubious
        Test returned status 255 (wstat 65280, 0xff00)
t/03smethod.........skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/04misc............Can't load '/home/olivier/Desktop/DBD-Pg-1.49/blib/arch/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/i386-linux-thread-multi/DynaLoader.pm line 230.
 at t/04misc.t line 8
Compilation failed in require at t/04misc.t line 8.
BEGIN failed--compilation aborted at t/04misc.t line 8.
# Looks like your test died before it could output anything.
t/04misc............dubious
        Test returned status 255 (wstat 65280, 0xff00)
t/05arrays..........skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/06bytea...........Can't load '/home/olivier/Desktop/DBD-Pg-1.49/blib/arch/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/i386-linux-thread-multi/DynaLoader.pm line 230.
 at t/06bytea.t line 7
Compilation failed in require at t/06bytea.t line 7.
BEGIN failed--compilation aborted at t/06bytea.t line 7.
# Looks like your test died before it could output anything.
t/06bytea...........dubious
        Test returned status 255 (wstat 65280, 0xff00)
t/07copy............skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/12placeholders....skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/20savepoints......skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
t/99_pod............ok
t/99cleanup.........skipped
        all skipped: Cannot run test unless DBI_DSN is defined. See the README file
Failed Test     Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/00basic.t        1   256     3    1  33.33%  2
t/01constants.t  255 65280    28   56 200.00%  1-28
t/03dbmethod.t   255 65280    ??   ??       %  ??
t/04misc.t       255 65280    ??   ??       %  ??
t/06bytea.t      255 65280    ??   ??       %  ??
9 tests and 1 subtest skipped.
Failed 5/16 test scripts, 68.75% okay. 29/34 subtests failed, 14.71% okay.
make: *** [test_dynamic] Error 255


-- 
--------------
Olivier ARNAIZ
CNRS - Centre de Génétique Moléculaire
Avenue de la Terrasse - Bât. 26
91198 GIF-SUR-YVETTE CEDEX
[email protected]
http://paramecium.cgm.cnrs-gif.fr


_______________________________________________
Dbdpg-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/dbdpg-general
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.