When Im doing an 'make test' on DBI:ODBC it fails quite miserably. I have
got ODBC working with php so I know that my drivers and such is working.
Versions:
Perl 5.6.0
MySQL 3.23.46
MyODBC 3.51.01
iODBC 3.0.5
DBI 1.21
DBI:ODBC 0.38
iODBC is extraced to the directory /usr/local/libiodbc-3.0.5. It has
installed its lib files in /usr/local/lib and include files in
/usr/local/include.
My /usr/local/include directory has these files (ls -F):
iodbcinst.h isqlext.h isql.h isqltypes.h php/ sqlext.h sql.h sqltypes.h
My /usr/local/lib has these files (ls -F):
libiodbc.a libiodbcinst.so.2.1.5* libmyodbc3-3.51.01.so*
libiodbcinst.a libiodbc.la* libmyodbc3.la*
libiodbcinst.la* libiodbc.so@ libmyodbc3.so@
libiodbcinst.so@ libiodbc.so.2@ php/
libiodbcinst.so.2@ libiodbc.so.2.1.5* php.ini
DBI's 'make test' works out fine.
When Im compiling DBI:ODBC I have these environments exported:
ODBCHOME="/usr/local"
LD_LIBRARY_PATH="/usr/local/lib"
LD_RUN_PATH="/usr/local/lib"
DBI_DSN="dbi:ODBC:db"
DBI_USER="user"
DBI_PASS="pass"
ODBCINI="/etc/odbc.ini"
When Im doing an 'perl Makefile.PL' everything seems fine and here is the
output:
Configuring DBD::ODBC ...
>>> Remember to actually *READ* the README file!
And re-read it if you have any problems.
Using DBI 1.21 installed in /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
Using ODBC in /usr/local
Umm, this looks like a iodbc type of driver manager.
We expect to find the isql.h, isqlext.h and iodbc.h files (which were
supplied with iODBC) in $ODBCHOME/include directory alongside
the /usr/local/lib/libiodbc.a /usr/local/lib/libiodbc.so /usr/local/lib/libiodbcinst.a
/usr/local/lib/libiodbcinst.so library.
Using DBI 1.21 installed in /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
Writing Makefile for DBD::ODBC
The DBD::ODBC tests will use these values for the database connection:
DBI_DSN=dbi:ODBC:db e.g. dbi:ODBC:demo
DBI_USER=user
DBI_PASS=pass
When Im doing an 'make' I get this output:
gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -fno-strict-aliasing
-O2 -march=i386 -mcpu=i686 -DVERSION=\"0.38\" -DXS_VERSION=\"0.38\" -fPIC
-I/usr/lib/perl5/5.6.0/i386-linux/CORE -I/usr/local/include ODBC.c
gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -fno-strict-aliasing
-O2 -march=i386 -mcpu=i686 -DVERSION=\"0.38\" -DXS_VERSION=\"0.38\" -fPIC
-I/usr/lib/perl5/5.6.0/i386-linux/CORE -I/usr/local/include dbdimp.c
dbdimp.c:1586: warning: `_dbd_rebind_ph' was declared implicitly `extern' and later
`static'
dbdimp.c:1135: warning: previous declaration of `_dbd_rebind_ph'
Running Mkbootstrap for DBD::ODBC ()
chmod 644 ODBC.bs
LD_RUN_PATH="/usr/local/lib" gcc -o blib/arch/auto/DBD/ODBC/ODBC.so -shared
-L/usr/local/lib ODBC.o dbdimp.o -L/usr/local/lib -liodbc
chmod 755 blib/arch/auto/DBD/ODBC/ODBC.so
cp ODBC.bs blib/arch/auto/DBD/ODBC/ODBC.bs
chmod 644 blib/arch/auto/DBD/ODBC/ODBC.bs
Manifying blib/man3/DBD::ODBC.3pm
Seems fine to me except a couple of warnings. Ill try with a 'make test
TEST_VERBOSE=1' and I get this:
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness
qw(&runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t
t/01base............1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t/02simple..........1..17
ok 1
Test 2: connecting to the database
dubious
Test returned status 0 (wstat 15, 0xf)
DIED. FAILED tests 2-17
Failed 16/17 tests, 5.88% okay
t/03dbatt...........1..6
ok 1
dubious
Test returned status 0 (wstat 15, 0xf)
DIED. FAILED tests 2-6
Failed 5/6 tests, 16.67% okay
t/05meth............1..6
ok 1
dubious
Test returned status 0 (wstat 15, 0xf)
DIED. FAILED tests 2-6
Failed 5/6 tests, 16.67% okay
t/07bind............1..9
ok 1
Test 2: connecting to the database
dubious
Test returned status 0 (wstat 15, 0xf)
DIED. FAILED tests 2-9
Failed 8/9 tests, 11.11% okay
t/08bind2...........dubious
Test returned status 0 (wstat 15, 0xf)
t/09multi...........dubious
Test returned status 0 (wstat 15, 0xf)
Failed Test Status Wstat Total Fail Failed List of failed
-------------------------------------------------------------------------------
t/02simple.t 0 15 17 16 94.12% 2-17
t/03dbatt.t 0 15 6 5 83.33% 2-6
t/05meth.t 0 15 6 5 83.33% 2-6
t/07bind.t 0 15 9 8 88.89% 2-9
t/08bind2.t 0 15 ?? ?? % ??
t/09multi.t 0 15 ?? ?? % ??
Failed 6/7 test scripts, 14.29% okay. 34/43 subtests failed, 20.93% okay.
make: *** [test_dynamic] Error 2
Please CC me since Im not a member of this maillinglist.
--
* John Ericson [EMAIL PROTECTED]
* ICQ: 7325429 JID: [EMAIL PROTECTED]
* web: http://john.pp.se
