Skip Menu |

This queue is for tickets about the DBD-Pg CPAN distribution.

Report information
The Basics
Id: 32470
Status: resolved
Priority: 0/
Queue: DBD-Pg

People
Owner: Nobody in particular
Requestors: aw [...] ice-sa.com
Cc:
AdminCc:

Bug Information
Severity: Unimportant
Broken in: (no value)
Fixed in: 2.0.0



Subject: Install 2.0.0_4
Date: Mon, 21 Jan 2008 09:28:10 +0100
To: bug-DBD-Pg [...] rt.cpan.org
From: André Warnier <aw [...] ice-sa.com>
Hi. The following was on a Debian Etch system, such : Linux arthur 2.6.18-4-686 #1 SMP Wed May 9 23:03:12 UTC 2007 i686 GNU/Linux The system is vanilla distribution, except that I manually de-installed the libdbi-perl package (DBI), and re-installed DBI from the latest CPAN source, prior to running the DBD-Pg 2.0.0_4 installation below. PostgreSQL is the 8.1 Debian Etch package, standard apt-get install. Note : I am not quite sure if the source directory I was using has a standard set of permissions, and that may be the reason for the failure in the second section below. So let's say that this is mainly a report on the test failures in section 1 and 3 below. First try : run Makefile.PL, make, make test as root ---------------------------------------------------- ... (no problem during Makefile.PL and make) ... root@arthur:/usr/local/src/DBD-Pg-2.0.0_4# 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........skipped: Set the environment variable TEST_SIGNATURE to enable this test t/00basic.............ok t/01connect...........# # DBI Version 1.601 # DBD::Pg Version 2.0.0_4 # Perl Version 5.8.8 # OS linux # PostgreSQL (compiled) ? # PostgreSQL (target) ? # PostgreSQL (reported) ? # Default port ? # DBI_DSN dbi:Pg:dbname=postgres # DBI_USER postgres # Test schema dbd_pg_testschema # Adjusted: DBI_DSN DBI_USER # Error was: FATAL: Ident authentication failed for user "postgres" # t/01connect...........skipped: Connection to database failed, cannot continue testing t/01constants.........ok t/02attribs...........skipped: Connection to database failed, cannot continue testing t/03dbmethod..........skipped: Connection to database failed, cannot continue testing t/03smethod...........skipped: Connection to database failed, cannot continue testing t/04misc..............skipped: Connection to database failed, cannot continue testing t/06bytea.............skipped: Connection to database failed, cannot continue testing t/07copy..............skipped: Connection to database failed, cannot continue testing t/08async.............skipped: Connection to database failed, cannot continue testing t/09arrays............skipped: Connection to database failed, cannot continue testing t/12placeholders......skipped: Connection to database failed, cannot continue testing t/20savepoints........skipped: Connection to database failed, cannot continue testing t/99_perlcritic.......skipped: Set the environment variable TEST_CRITIC to enable this test t/99_pod..............ok t/99_yaml.............ok t/99cleanup...........skipped: Connection to database failed, cannot continue testing All tests successful. Files=18, Tests=140, 10 wallclock secs ( 0.40 usr 0.04 sys + 8.35 cusr 0.73 csys = 9.52 CPU) Result: PASS root@arthur:/usr/local/src/DBD-Pg-2.0.0_4# (Thus it passes, but without running any connected tests). root@arthur:/usr/local/src/DBD-Pg-2.0.0_4# make clean rm -f \ *.a core \ core.[0-9] blib/arch/auto/DBD/Pg/extralibs.all \ Pg.c core.[0-9][0-9] \ Pg.bso pm_to_blib.ts \ core.[0-9][0-9][0-9][0-9] Pg.x \ Pg.bs perl \ tmon.out *.o \ pm_to_blib blib/arch/auto/DBD/Pg/extralibs.ld \ blibdirs.ts core.[0-9][0-9][0-9][0-9][0-9] \ *perl.core core.*perl.*.? \ Makefile.aperl perl \ Pg.def core.[0-9][0-9][0-9] \ mon.out libPg.def \ perlmain.c perl.exe \ so_locations Pg.exp rm -rf \ Pg.xsi trace \ blib mv Makefile Makefile.old > /dev/null 2>&1 root@arthur:/usr/local/src/DBD-Pg-2.0.0_4# Second try, after "make clean" (root), try to run Makefile.PL, make, make test as user "postgres" : -------------------------------------------------------------- root@arthur:/usr/local/src/DBD-Pg-2.0.0_4# su - postgres postgres@arthur:~$ cd /usr/local/src/DBD-Pg-2.0.0_4 postgres@arthur:/usr/local/src/DBD-Pg-2.0.0_4$ perl Makefile.PL WARNING! This is a test version (2.0.0_4) and should not be used in production! Configuring DBD::Pg 2.0.0_4 PostgreSQL version: 80109 (default port: 5432) POSTGRES_HOME: (not set) POSTGRES_INCLUDE: (not set) POSTGRES_LIB: (not set) OS: linux Checking if your kit is complete... Looks good Using DBI 1.601 (for perl 5.008008 on i486-linux-gnu-thread-multi) installed in /usr/local/lib/perl/5.8.8/auto/DBI/ Writing Makefile for DBD::Pg Unable to open MakeMaker.tmp: Permission denied at /usr/share/perl/5.8/ExtUtils/MakeMaker.pm line 878. # Looks like your test died before it could output anything. postgres@arthur:/usr/local/src/DBD-Pg-2.0.0_4$ exit logout (As postgres, it doesn't have the right permissions to run the MakeFile) 3rd try : run Makefile.PL, make a root, then make test as "postgres" : ----------------------------------------------------------------------- root@arthur:/usr/local/src/DBD-Pg-2.0.0_4# make clean make: *** No rule to make target `clean'. Stop. root@arthur:/usr/local/src/DBD-Pg-2.0.0_4# perl Makefile.PL WARNING! This is a test version (2.0.0_4) and should not be used in production! Configuring DBD::Pg 2.0.0_4 PostgreSQL version: 80109 (default port: 5432) POSTGRES_HOME: (not set) POSTGRES_INCLUDE: (not set) POSTGRES_LIB: (not set) OS: linux Checking if your kit is complete... Looks good Using DBI 1.601 (for perl 5.008008 on i486-linux-gnu-thread-multi) installed in /usr/local/lib/perl/5.8.8/auto/DBI/ Writing Makefile for DBD::Pg root@arthur:/usr/local/src/DBD-Pg-2.0.0_4# make cp Pg.pm blib/lib/DBD/Pg.pm /usr/bin/perl -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/" /usr/local/lib/perl/5.8.8/auto/DBI/Driver.xst > Pg.xsi /usr/bin/perl /usr/share/perl5/ExtUtils/xsubpp -typemap /usr/share/perl/5.8/ExtUtils/typemap Pg.xs > Pg.xsc && mv Pg.xsc Pg.c cc -c -I/usr/include/postgresql -I/usr/local/lib/perl/5.8.8/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=80109 -DPGDEFPORT=5432 -O2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.0.0_4\" -DXS_VERSION=\"2.0.0_4\" -fPIC "-I/usr/lib/perl/5.8/CORE" Pg.c cc -c -I/usr/include/postgresql -I/usr/local/lib/perl/5.8.8/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=80109 -DPGDEFPORT=5432 -O2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.0.0_4\" -DXS_VERSION=\"2.0.0_4\" -fPIC "-I/usr/lib/perl/5.8/CORE" dbdimp.c cc -c -I/usr/include/postgresql -I/usr/local/lib/perl/5.8.8/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=80109 -DPGDEFPORT=5432 -O2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.0.0_4\" -DXS_VERSION=\"2.0.0_4\" -fPIC "-I/usr/lib/perl/5.8/CORE" quote.c cc -c -I/usr/include/postgresql -I/usr/local/lib/perl/5.8.8/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=80109 -DPGDEFPORT=5432 -O2 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.0.0_4\" -DXS_VERSION=\"2.0.0_4\" -fPIC "-I/usr/lib/perl/5.8/CORE" types.c Running Mkbootstrap for DBD::Pg () chmod 644 Pg.bs rm -f blib/arch/auto/DBD/Pg/Pg.so cc -shared -L/usr/local/lib Pg.o dbdimp.o quote.o types.o -o blib/arch/auto/DBD/Pg/Pg.so \ -L/usr/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 root@arthur:/usr/local/src/DBD-Pg-2.0.0_4# su - postgres postgres@arthur:~$ cd /usr/local/src/DBD-Pg-2.0.0_4 postgres@arthur:/usr/local/src/DBD-Pg-2.0.0_4$ 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........skipped: Set the environment variable TEST_SIGNATURE to enable this test t/00basic.............ok t/01connect...........1/15 # # DBI Version 1.601 # DBD::Pg Version 2.0.0_4 # Perl Version 5.8.8 # OS linux # PostgreSQL (compiled) 80109 # PostgreSQL (target) 80111 # PostgreSQL (reported) PostgreSQL 8.1.11 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) # Default port 5432 # DBI_DSN dbi:Pg: # DBI_USER <not set> # Test schema dbd_pg_testschema # Adjusted: DBI_DSN t/01connect...........ok t/01constants.........ok t/02attribs...........ok t/03dbmethod..........34/207 # Failed test 'Correct stats output for dbd_pg_test3' # in t/03dbmethod.t at line 564. # Structures begin differing at: # $got->[5][11] = '4' # $expected->[5][11] = '0' t/03dbmethod..........110/207 # Failed test 'Correct stats output for dbd_pg_test3' # in t/03dbmethod.t at line 583. # Structures begin differing at: # $got->[5][11] = '4' # $expected->[5][11] = '0' t/03dbmethod..........171/207 # Looks like you failed 2 tests of 207. t/03dbmethod.......... Dubious, test returned 2 (wstat 512, 0x200) Failed 2/207 subtests (less 2 skipped subtests: 203 okay) t/03smethod...........ok t/04misc..............ok t/06bytea.............ok t/07copy..............ok t/08async.............ok t/09arrays............ok t/12placeholders......ok t/20savepoints........ok t/99_perlcritic.......skipped: Set the environment variable TEST_CRITIC to enable this test t/99_pod..............ok t/99_yaml.............ok t/99cleanup...........ok Test Summary Report ------------------- t/03dbmethod.t (Wstat: 512 Tests: 207 Failed: 2) Failed tests: 108, 112 Non-zero exit status: 2 Files=18, Tests=942, 20 wallclock secs ( 1.34 usr 0.08 sys + 10.74 cusr 0.78 csys = 12.94 CPU) Result: FAIL Failed 1/18 test programs. 2/942 subtests failed. make: *** [test_dynamic] Error 255 postgres@arthur:/usr/local/src/DBD-Pg-2.0.0_4$ (After this, I did run a "make install" as root, it installed it and it runs) Best regards, André
Looks like Postgres changed some of the stats for version 8.1, so we recently (January 19) adjusted the tests. Please try it out when you get a chance and see if all the tests are working for you now.