DBD::CSV: make test fails

Hello,

[sorry for eventual double posting]

since a longer time I am using DBD::CSV for several purposes and were
quite happy with it. But now I try to install it on an old Linux Server
(SuSE) and the 'make test' fails in nearly every case. Can someone give
some hints?

Here is the 'make test' part from the automated installation from CPAN
(perl -MCPAN...):

-----------------------------------
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /home/rroggenb/perl/bin/perl "-MExtUtils::Command::MM"
"-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........1.15 at t/00base.t line 15.
t/00base...........ok
t/10dsnlist........ok
t/20createdrop.....dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-5
Failed 4/5 tests, 20.00% okay
t/30insertfetch....dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-17
Failed 16/17 tests, 5.88% okay
t/40bindparam......dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-28
Failed 27/28 tests, 3.57% okay
t/40blobs..........dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-11
Failed 10/11 tests, 9.09% okay
t/40listfields.....dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-13
Failed 12/13 tests, 7.69% okay
t/40nulls..........dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-11
Failed 10/11 tests, 9.09% okay
t/40numrows........dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-25
Failed 24/25 tests, 4.00% okay
t/50chopblanks.....dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-35
Failed 34/35 tests, 2.86% okay
t/50commit.........dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-16
Failed 15/16 tests, 6.25% okay
t/ak-dbd...........dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-47
Failed 46/47 tests, 2.13% okay
t/csv..............dubious
Test returned status 22 (wstat 5632, 0x1600)
DIED. FAILED tests 2-23
Failed 22/23 tests, 4.35% okay
t/dbdadmin.........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED test 4
Failed 1/4 tests, 75.00% okay
Failed Test Stat Wstat Total Fail List of Failed
------------------------------------------------------------ -------------------
t/20createdrop.t 22 5632 5 8 2-5
t/30insertfetch.t 22 5632 17 32 2-17
t/40bindparam.t 22 5632 28 54 2-28
t/40blobs.t 22 5632 11 20 2-11
t/40listfields.t 22 5632 13 24 2-13
t/40nulls.t 22 5632 11 20 2-11
t/40numrows.t 22 5632 25 48 2-25
t/50chopblanks.t 22 5632 35 68 2-35
t/50commit.t 22 5632 16 30 2-16
t/ak-dbd.t 22 5632 47 92 2-47
t/csv.t 22 5632 23 44 2-23
t/dbdadmin.t 0 11 4 1 4
Failed 12/14 test scripts. 221/243 subtests failed.
Files=14, Tests=243, 7 wallclock secs ( 6.35 cusr + 0.59 csys = 6.94 CPU)
Failed 12/14 test programs. 221/243 subtests failed.
make: *** [test_dynamic] Error 255
JZUCKER/DBD-CSV-0.22.tar.gz
/usr/bin/make test -- NOT OK
-----------------------------------

My system identifies itself as follows (uname -a):

Linux serapis 2.2.14-2GB-SMP #1 SMP Mon May 8 10:24:19 MEST 2000 i686 unknown

And 'perl -V' results in the following:

-----------------------------------
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=linux, osvers=2.2.14-2gb-smp, archname=i686-linux-ld
uname='linux serapis 2.2.14-2gb-smp #1 smp mon may 8 10:24:19 mest
2000 i686 unknown '
config_args='-Dcc=gcc -Dprefix=/home/rroggenb'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=define
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-fno-strict-aliasing -pipe -I/usr/local/include'
ccversion='', gccversion='2.95.2 19991024 (release)', 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='long double', nvsize=12,
Off_t='off_t', lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lndbm -lgdbm -ldbm -ldb -ldl -lm -lcrypt -lutil -lc -lposix
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc -lposix
libc=, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version='2.1.3'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl):
Compile-time options: PERL_MALLOC_WRAP USE_LARGE_FILES USE_LONG_DOUBLE
USE_PERLIO
Built under linux
Compiled at Oct 11 2007 14:32:47
@INC:
/home/rroggenb/perl/lib/5.8.8/i686-linux-ld
/home/rroggenb/perl/lib/5.8.8
/home/rroggenb/perl/lib/site_perl/5.8.8/i686-linux-ld
/home/rroggenb/perl/lib/site_perl/5.8.8
/home/rroggenb/perl/lib/site_perl
.
-----------------------------------

Best regards

Robert

Re: DBD::CSV: make test fails

My guess is that you are either missing some prerequisites or that the
older linux perl has some old copies of them. Try to first install the
latest DBD-File, SQL::Statement, and Text::CSV_XS. If you still get
errors, please let me know what versions of those modules you have.
Good luck!

--
Jeff

rroggenb@mathematik.Uni-Osnabrueck.DE wrote:
> Hello,
>
> [sorry for eventual double posting]
>
> since a longer time I am using DBD::CSV for several purposes and were
> quite happy with it. But now I try to install it on an old Linux Server
> (SuSE) and the 'make test' fails in nearly every case. Can someone give
> some hints?
>
> Here is the 'make test' part from the automated installation from CPAN
> (perl -MCPAN...):
>
> -----------------------------------
> /usr/bin/make -- OK
> Running make test
> PERL_DL_NONLAZY=1 /home/rroggenb/perl/bin/perl "-MExtUtils::Command::MM"
> "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/00base...........1.15 at t/00base.t line 15.
> t/00base...........ok
> t/10dsnlist........ok
> t/20createdrop.....dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-5
> Failed 4/5 tests, 20.00% okay
> t/30insertfetch....dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-17
> Failed 16/17 tests, 5.88% okay
> t/40bindparam......dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-28
> Failed 27/28 tests, 3.57% okay
> t/40blobs..........dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-11
> Failed 10/11 tests, 9.09% okay
> t/40listfields.....dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-13
> Failed 12/13 tests, 7.69% okay
> t/40nulls..........dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-11
> Failed 10/11 tests, 9.09% okay
> t/40numrows........dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-25
> Failed 24/25 tests, 4.00% okay
> t/50chopblanks.....dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-35
> Failed 34/35 tests, 2.86% okay
> t/50commit.........dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-16
> Failed 15/16 tests, 6.25% okay
> t/ak-dbd...........dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-47
> Failed 46/47 tests, 2.13% okay
> t/csv..............dubious
> Test returned status 22 (wstat 5632, 0x1600)
> DIED. FAILED tests 2-23
> Failed 22/23 tests, 4.35% okay
> t/dbdadmin.........dubious
> Test returned status 0 (wstat 11, 0xb)
> DIED. FAILED test 4
> Failed 1/4 tests, 75.00% okay
> Failed Test Stat Wstat Total Fail List of Failed
> ------------------------------------------------------------ -------------------
> t/20createdrop.t 22 5632 5 8 2-5
> t/30insertfetch.t 22 5632 17 32 2-17
> t/40bindparam.t 22 5632 28 54 2-28
> t/40blobs.t 22 5632 11 20 2-11
> t/40listfields.t 22 5632 13 24 2-13
> t/40nulls.t 22 5632 11 20 2-11
> t/40numrows.t 22 5632 25 48 2-25
> t/50chopblanks.t 22 5632 35 68 2-35
> t/50commit.t 22 5632 16 30 2-16
> t/ak-dbd.t 22 5632 47 92 2-47
> t/csv.t 22 5632 23 44 2-23
> t/dbdadmin.t 0 11 4 1 4
> Failed 12/14 test scripts. 221/243 subtests failed.
> Files=14, Tests=243, 7 wallclock secs ( 6.35 cusr + 0.59 csys = 6.94 CPU)
> Failed 12/14 test programs. 221/243 subtests failed.
> make: *** [test_dynamic] Error 255
> JZUCKER/DBD-CSV-0.22.tar.gz
> /usr/bin/make test -- NOT OK
> -----------------------------------
>
> My system identifies itself as follows (uname -a):
>
> Linux serapis 2.2.14-2GB-SMP #1 SMP Mon May 8 10:24:19 MEST 2000 i686 unknown
>
> And 'perl -V' results in the following:
>
> -----------------------------------
> Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
> Platform:
> osname=linux, osvers=2.2.14-2gb-smp, archname=i686-linux-ld
> uname='linux serapis 2.2.14-2gb-smp #1 smp mon may 8 10:24:19 mest
> 2000 i686 unknown '
> config_args='-Dcc=gcc -Dprefix=/home/rroggenb'
> hint=recommended, useposix=true, d_sigaction=define
> usethreads=undef use5005threads=undef useithreads=undef
> usemultiplicity=undef
> useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
> use64bitint=undef use64bitall=undef uselongdouble=define
> usemymalloc=n, bincompat5005=undef
> Compiler:
> cc='gcc', ccflags ='-fno-strict-aliasing -pipe -I/usr/local/include
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
> optimize='-O2',
> cppflags='-fno-strict-aliasing -pipe -I/usr/local/include'
> ccversion='', gccversion='2.95.2 19991024 (release)', 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='long double', nvsize=12,
> Off_t='off_t', lseeksize=8
> alignbytes=4, prototype=define
> Linker and Libraries:
> ld='gcc', ldflags =' -L/usr/local/lib'
> libpth=/usr/local/lib /lib /usr/lib
> libs=-lnsl -lndbm -lgdbm -ldbm -ldb -ldl -lm -lcrypt -lutil -lc -lposix
> perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc -lposix
> libc=, so=so, useshrplib=false, libperl=libperl.a
> gnulibc_version='2.1.3'
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
> cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options: PERL_MALLOC_WRAP USE_LARGE_FILES USE_LONG_DOUBLE
> USE_PERLIO
> Built under linux
> Compiled at Oct 11 2007 14:32:47
> @INC:
> /home/rroggenb/perl/lib/5.8.8/i686-linux-ld
> /home/rroggenb/perl/lib/5.8.8
> /home/rroggenb/perl/lib/site_perl/5.8.8/i686-linux-ld
> /home/rroggenb/perl/lib/site_perl/5.8.8
> /home/rroggenb/perl/lib/site_perl
> .
> -----------------------------------
>
> Best regards
>
> Robert
>
>
>
>
>
>
>
>

Re: DBD::CSV: make test fails

[sorry for the missing subject in previous posting]

Hi Ron,

thanks for the hint in the right direction: executing the tests
individually shows the needed details. The message I get is:

YOU ARE MISSING REQUIRED MODULES: [ ]

This is not much (missing an unnamed module?), but I detected in lip.pl
(located in the same test directory) the code which throws the error
message. There are the prerequisits tested (lines 40-49). But this list
includes DBD::CSV itself! How can this ever work? Besides this DBD::CSV is
not part of the error reporting (which explains the empty brackets above).
After commenting the DBD::CSV-test, I come to the next problem:

Can't locate DBI object method "list_tables" via package "DBD::Adabas::db"
at CSV.dbtest line 94.

So the DBD::CSV problem turns to an DBD::Adabas issue...

But why do I need another DB to test DBD::CSV? This seems to me not
necessary.

Greetings Robert

---

>Hi Robert
>
>
>> t/20createdrop.....dubious
>> Test returned status 22 (wstat 5632, 0x1600)
>> DIED. FAILED tests 2-5
>> Failed 4/5 tests, 20.00% okay
>
> Perhaps it's a permissions problem. Try running this test by itself, and
find if there is a specific statement (Perl, SQL) which fails.
>
> --
> Ron Savage

Re: DBD::CSV: make test fails

rroggenb@mathematik.Uni-Osnabrueck.DE wrote:

Hi Robert

> This is not much (missing an unnamed module?), but I detected in lip.pl
> (located in the same test directory) the code which throws the error
> message. There are the prerequisits tested (lines 40-49). But this list
> includes DBD::CSV itself! How can this ever work? Besides this DBD::CSV is

How can this ever work, you ask.

Well, look. The '[d]make test' command contains 'blib\lib', which means
the version of DBD::CSV shipped but not yet installed is looked for in
'blib\lib', and that makes sense since it is precisely that code which
is being tested!

C:\perl-modules\DBD-CSV-0.22>dmake test
C:\strawberry-perl\perl\bin\perl.exe "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib\lib', 'blib\arch')" t/*.t
t/00base...........1.15 at t/00base.t line 15.
t/00base...........ok
t/10dsnlist........ok
t/20createdrop.....ok
t/30insertfetch....ok
t/40bindparam......ok
t/40blobs..........ok
t/40listfields.....ok
t/40nulls..........ok
t/40numrows........ok
t/50chopblanks.....ok
t/50commit.........ok
t/ak-dbd...........ok
t/csv..............ok
t/dbdadmin.........ok
All tests successful.
Files=14, Tests=243, 9 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00 CPU)

Also, for this I did /not/ define the env vars DBI_DSN, DBI_USER and
DBI_PASS.

> Can't locate DBI object method "list_tables" via package "DBD::Adabas::db"
> at CSV.dbtest line 94.
> So the DBD::CSV problem turns to an DBD::Adabas issue...
> But why do I need another DB to test DBD::CSV? This seems to me not
> necessary.

Hmmm. Odd. I think you have done something which triggered Jeff Zucker's
private tests. Don't do that!

--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html

Re: DBD::CSV: make test fails

Ok, it makes sense. I was sure it makes sense, but I could not see it.
Thanks for the explanation. But then: What's the way to successful tests
without manipulating the test code?

The DBD::Adabas-error comes during the tests t/20createdrop,
t/30insertfetch, t/40bindparam, and then I stopped going though the
others. The message is exactly the same in every test. If these are Jeff
Zucker's private tests, there is something wrong with the package...

Best regards

Robert

Ron Savage schrieb:
> rroggenb@mathematik.Uni-Osnabrueck.DE wrote:
>
> Hi Robert
>
>> This is not much (missing an unnamed module?), but I detected in lip.pl
>> (located in the same test directory) the code which throws the error
>> message. There are the prerequisits tested (lines 40-49). But this list
>> includes DBD::CSV itself! How can this ever work? Besides this
>> DBD::CSV is
>
> How can this ever work, you ask.
>
> Well, look. The '[d]make test' command contains 'blib\lib', which means
> the version of DBD::CSV shipped but not yet installed is looked for in
> 'blib\lib', and that makes sense since it is precisely that code which
> is being tested!
>
> C:\perl-modules\DBD-CSV-0.22>dmake test
> C:\strawberry-perl\perl\bin\perl.exe "-MExtUtils::Command::MM" "-e"
> "test_harness(0, 'blib\lib', 'blib\arch')" t/*.t
> t/00base...........1.15 at t/00base.t line 15.
> t/00base...........ok
> t/10dsnlist........ok
> t/20createdrop.....ok
> t/30insertfetch....ok
> t/40bindparam......ok
> t/40blobs..........ok
> t/40listfields.....ok
> t/40nulls..........ok
> t/40numrows........ok
> t/50chopblanks.....ok
> t/50commit.........ok
> t/ak-dbd...........ok
> t/csv..............ok
> t/dbdadmin.........ok
> All tests successful.
> Files=14, Tests=243, 9 wallclock secs ( 0.00 cusr + 0.00 csys = 0.00
> CPU)
>
> Also, for this I did /not/ define the env vars DBI_DSN, DBI_USER and
> DBI_PASS.
>
>> Can't locate DBI object method "list_tables" via package
>> "DBD::Adabas::db"
>> at CSV.dbtest line 94.
>> So the DBD::CSV problem turns to an DBD::Adabas issue...
>> But why do I need another DB to test DBD::CSV? This seems to me not
>> necessary.
>
> Hmmm. Odd. I think you have done something which triggered Jeff Zucker's
> private tests. Don't do that!
>

--

===================================
Robert Roggenbuck
Universitaetsbibliothek Osnabrueck
Alte Muenze 16
D-49074 Osnabrueck
Germany
Tel ++49/541/969-4344 Fax -4482
rroggenb@uni-osnabrueck.de

Postbox:
Postfach 4496
D-49034 Osnabrueck
===================================

Re: DBD::CSV: make test fails

Robert Roggenbuck wrote:

Hi Robert

> The DBD::Adabas-error comes during the tests t/20createdrop,
> t/30insertfetch, t/40bindparam, and then I stopped going though the
> others. The message is exactly the same in every test. If these are Jeff
> Zucker's private tests, there is something wrong with the package...

I don't think so. You saw the output of my 'dmake test'.

BTW I'm installing V 0.22 here.

I think you need to unpack the distro again, and trace thru the test
code to see what triggers reference to Adabas on your system. Obviously
it's not happening here, so there must be something in your set up which
is triggering this effect.

Keep us informed. It may need to be reported back to Jeff.

Good luck!

--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html

Re: DBD::CSV: make test fails

Robert Roggenbuck wrote:
>
> The DBD::Adabas-error comes during the tests t/20createdrop,
> t/30insertfetch, t/40bindparam, and then I stopped going though the
> others. The message is exactly the same in every test. If these are
> Jeff Zucker's private tests, there is something wrong with the package...
>
The Adabas and My/Msql stuff in the test directory is left over from
Jochen Wiedmann's original version of the tests which were meant to be a
blueprint for other kinds of tests. I suppose I should clean them out
of the distro, but I've never heard of them being triggered during a
make test of DBD::CSV and there are literally hundreds of CPAN tester
pass reports that successfully ignored the Adabas stuff over the past years.


>>> So the DBD::CSV problem turns to an DBD::Adabas issue...
>>> But why do I need another DB to test DBD::CSV? This seems to me not
>>> necessary.
>>
No, you absolutely should not need DBD::Adabas to pass the DBD::CSV tests.

--
Jeff

Re: DBD::CSV: make test fails

Robert Roggenbuck wrote:

Hi Robert

Looking at the code and the first error msg you got:
YOU ARE MISSING REQUIRED MODULES: [ ]
makes me suspect the method you are using to test the module.
Are you using 'The Mantra' of standard commands? Something like:

shell>gunzip DBD-CSV-0.22.tar.gz
shell>tar -xvf DBD-CSV-0.22.tar
shell>cd DBD-CSV-0.22
shell>perl Makefile.PL
shell>make (or dmake or nmake)
shell>perl -I lib t/20createdrop.t

Show us the output of all these commands...
--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html

Re: DBD::CSV: make test fails

Hi Ron,


Ron Savage schrieb:
> Robert Roggenbuck wrote:
>
> Hi Robert
>
> Looking at the code and the first error msg you got:
> YOU ARE MISSING REQUIRED MODULES: [ ]
> makes me suspect the method you are using to test the module.
> Are you using 'The Mantra' of standard commands? Something like:
As I said in my firs message I did the downloading, unzipping etc. via
'perl -MCPAN...' - which should include the correct Mantra. But lets
have a look, what going on if I do it maually:

>
> shell>gunzip DBD-CSV-0.22.tar.gz
> shell>tar -xvf DBD-CSV-0.22.tar
DBD-CSV-0.22/
DBD-CSV-0.22/t/
DBD-CSV-0.22/t/40numrows.t
DBD-CSV-0.22/t/mSQL.dbtest
DBD-CSV-0.22/t/dbdadmin.t
DBD-CSV-0.22/t/README
DBD-CSV-0.22/t/pNET.mtest
DBD-CSV-0.22/t/50commit.t
DBD-CSV-0.22/t/CSV.dbtest
DBD-CSV-0.22/t/50chopblanks.t
DBD-CSV-0.22/t/mSQL.mtest
DBD-CSV-0.22/t/Adabas.dbtest
DBD-CSV-0.22/t/mysql.dbtest
DBD-CSV-0.22/t/40bindparam.t
DBD-CSV-0.22/t/csv.t
DBD-CSV-0.22/t/40nulls.t
DBD-CSV-0.22/t/mSQL1.dbtest
DBD-CSV-0.22/t/Adabas.mtest
DBD-CSV-0.22/t/pNET.dbtest
DBD-CSV-0.22/t/mSQL1.mtest
DBD-CSV-0.22/t/30insertfetch.t
DBD-CSV-0.22/t/40listfields.t
DBD-CSV-0.22/t/mysql.mtest
DBD-CSV-0.22/t/00base.t
DBD-CSV-0.22/t/CSV.mtest
DBD-CSV-0.22/t/ak-dbd.t
DBD-CSV-0.22/t/lib.pl
DBD-CSV-0.22/t/10dsnlist.t
DBD-CSV-0.22/t/40blobs.t
DBD-CSV-0.22/t/skeleton.test
DBD-CSV-0.22/t/20createdrop.t
DBD-CSV-0.22/MANIFEST
DBD-CSV-0.22/lib/
DBD-CSV-0.22/lib/DBD/
DBD-CSV-0.22/lib/DBD/CSV.pm
DBD-CSV-0.22/lib/Bundle/
DBD-CSV-0.22/lib/Bundle/DBD/
DBD-CSV-0.22/lib/Bundle/DBD/CSV.pm
DBD-CSV-0.22/META.yml
DBD-CSV-0.22/ChangeLog
DBD-CSV-0.22/MANIFEST.SKIP
DBD-CSV-0.22/Makefile.PL
DBD-CSV-0.22/README
> shell>cd DBD-CSV-0.22
> shell>perl Makefile.PL
Checking if your kit is complete...
Looks good
Writing Makefile for DBD::CSV
> shell>make
cp lib/Bundle/DBD/CSV.pm blib/lib/Bundle/DBD/CSV.pm
cp lib/DBD/CSV.pm blib/lib/DBD/CSV.pm
Manifying blib/man3/Bundle::DBD::CSV.3
Manifying blib/man3/DBD::CSV.3
> shell>perl -I lib t/20createdrop.t
1..5
ok 1
Can't locate DBI object method "list_tables" via package
"DBD::Adabas::db" at t/CSV.dbtest line 94.

> Show us the output of all these commands...
There they are. I get the message 'YOU ARE MISSING REQUIRED MODULES'
only if I say just 'perl t/20createdrop.t' - I did not know that I need
to include 'lib' before executing the tests manually.

So the question remains: Why are the 'blueprint tests' triggered in my
case. Or better (looking at Your test result, where 20createdrop.t
succeeds and is not skipped): Why are they make troubles in my special
case? Could it be that they are looking for an Adabas installation and
behave different if there is one?

Best regards

Robert

Re: DBD::CSV: make test fails

Robert Roggenbuck wrote:

Hi Robert

> There they are. I get the message 'YOU ARE MISSING REQUIRED MODULES'
> only if I say just 'perl t/20createdrop.t' - I did not know that I need
> to include 'lib' before executing the tests manually.

That's just to get Perl to look in lib/ in the unpacked distro to find
DBD::CSV. Of course, if the module is already installed then not doing
that is testing the previously installed version.

Maybe try deleting any old version and rerunning the tests?

It's 8:30 pm here now. More tomorrow.

--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html

Re: DBD::CSV: make test fails

I looked in the code of t/20createdrop.t and t/lib.pl and found that in
lib.pl a lookup in the environment for DBI_DSN, DBI_PASS and DBI_USER is
made. If they are found these settings are used for further testing (for
getting data etc.) - else files for the use as tables are created
(lip.pl lines 28-34). If I unset the DBI_* variables, DBD::Adabas is not
used and all DBD::CSV-tests are passing - and finally 'make install'
succeeds.

May be this DBI_* usage should be removed from lib.pl?

For the DBD::Adabas problem I will open a new thread.

Thanks for all the comments :-)

Robert



Jeff Zucker schrieb:
> Robert Roggenbuck wrote:
>>
>> The DBD::Adabas-error comes during the tests t/20createdrop,
>> t/30insertfetch, t/40bindparam, and then I stopped going though the
>> others. The message is exactly the same in every test. If these are
>> Jeff Zucker's private tests, there is something wrong with the package...
>>
> The Adabas and My/Msql stuff in the test directory is left over from
> Jochen Wiedmann's original version of the tests which were meant to be a
> blueprint for other kinds of tests. I suppose I should clean them out
> of the distro, but I've never heard of them being triggered during a
> make test of DBD::CSV and there are literally hundreds of CPAN tester
> pass reports that successfully ignored the Adabas stuff over the past
> years.
>
>
>>>> So the DBD::CSV problem turns to an DBD::Adabas issue...
>>>> But why do I need another DB to test DBD::CSV? This seems to me not
>>>> necessary.
>>>
> No, you absolutely should not need DBD::Adabas to pass the DBD::CSV tests.

Re: DBD::CSV: make test fails

Robert Roggenbuck wrote:

Hi Robert

> (lip.pl lines 28-34). If I unset the DBI_* variables, DBD::Adabas is not
> used and all DBD::CSV-tests are passing - and finally 'make install'
> succeeds.

I did say in one email that I was not setting these. I was wondering if
you were. That would explain things.

> May be this DBI_* usage should be removed from lib.pl?

I guess it's a problem of experience 'v' documented or undocumented
defaults... Of course, this makes it hard for beginners :-(.

I hope your problem is now solved.
--
Ron Savage
ron@savage.net.au
http://savage.net.au/index.html

Re: DBD::CSV: make test fails

Hi Jeff,

While looking more closely to the origin of the error message

Can't locate DBI object method "list_tables" via package
"DBD::Adabas::db" at CSV.dbtest line 94.

I detected that there is nothing wrong with DBD::Adabas, it's DBD::CSV.
At a first glance I thought 'list_table' is a DBI function - but it is a
DBD::CSV privat feature. So again DBD::CSV is wrong in using DBD::Adabas
and applying it's own feature to a foreign driver.
Cleaning the test codes from using foreign drivers will also solve this
issue.

Best regards

Robert

----
Robert Roggenbuck schrieb:
> I looked in the code of t/20createdrop.t and t/lib.pl and found that in
> lib.pl a lookup in the environment for DBI_DSN, DBI_PASS and DBI_USER is
> made. If they are found these settings are used for further testing (for
> getting data etc.) - else files for the use as tables are created
> (lip.pl lines 28-34). If I unset the DBI_* variables, DBD::Adabas is not
> used and all DBD::CSV-tests are passing - and finally 'make install'
> succeeds.
>
> May be this DBI_* usage should be removed from lib.pl?
>
> For the DBD::Adabas problem I will open a new thread.
>
> Thanks for all the comments :-)
>
> Robert
>
>

Re: DBD::CSV: make test fails

Jeff Zucker schrieb:
> My guess is that you are either missing some prerequisites or that the
> older linux perl has some old copies of them. Try to first install the
> latest DBD-File, SQL::Statement, and Text::CSV_XS. If you still get
> errors, please let me know what versions of those modules you have.

I had some forwarding and mail folder filter problem with one of my
mailboxes, so I read this mail just yesterday. Even if my problem seems
solved I woun't let Your response without an answer. Indeed there is a
very old perl installation besides my privat one. But there is no DBI,
nor SQL::Satatement or Text::CSV_XS in it's @INC.

$> /usr/bin/perl -V

Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
Platform:
osname=linux, osvers=2.2.14, archname=i586-linux
uname='linux apollonius 2.2.14 #1 mon nov 8 15:51:29 cet 1999 i686
unknown '
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='cc', optimize='-O2 -pipe', gccversion=2.95.2 19991024 (release)
cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include'
ccflags ='-Dbool=char -DHAS_BOOL -I/usr/local/include'
stdchar='char', d_stdstdio=undef, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
alignbytes=4, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lc -lposix -lcrypt
libc=, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl):
Built under linux
Compiled at Mar 11 2000 08:03:12
@INC:
/usr/lib/perl5/5.00503/i586-linux
/usr/lib/perl5/5.00503
/usr/lib/perl5/site_perl/5.005/i586-linux
/usr/lib/perl5/site_perl/5.005
.

And in my private installation I have the most recent versions:

$> perl -e 'use SQL::Statement; print "$SQL::Statement::VERSION\n"'
1.15
$> perl -e 'use Text::CSV_XS; print "$Text::CSV_XS::VERSION\n"'
0.31
$> perl -e 'use DBI; print "$DBI::VERSION\n"'
1.59
$> perl -e 'use DBD::CSV; print "$DBD::CSV::VERSION\n"'
0.22

Best regards

Robert