It occured to me that it wuld probably be better if I showed the output of a
manual build:
# make realclean
rm -rf ODBC.c ODBC.xsi dbdodbc.h ./blib Makefile.aperl
blib/arch/auto/DBD/ODBC/extralibs.all perlmain.c mon.out core core.*perl.*.?
*perl.core so_locations pm_to_blib *.o *.a perl.exe ODBC.bs ODBC.bso
ODBC.def ODBC.exp
mv Makefile Makefile.old > /dev/null 2>&1
rm -rf blib/lib/auto/DBD/ODBC blib/arch/auto/DBD/ODBC
rm -f blib/arch/auto/DBD/ODBC/ODBC.so blib/arch/auto/DBD/ODBC/ODBC.bs
rm -f blib/arch/auto/DBD/ODBC/ODBC.a
rm -f blib/lib/DBD/ODBC.pm
rm -rf Makefile Makefile.old
# Makefile.PL
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/local/lib/perl5/site_perl/5.005/i386-freebsd/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 library.
Checking if your kit is complete...
Looks good
Using DBI 1.21 installed in
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI
Writing Makefile for DBD::ODBC
The DBD::ODBC tests will use these values for the database connection:
DBI_DSN=dbi:ODBC:database=onetoone;host=64.78.148.124;port=1071e.g.
dbi:ODBC:demo
DBI_USER=waterline2
DBI_PASS=EPA123$
# make
cp ODBC.pm blib/lib/DBD/ODBC.pm
/usr/local/bin/perl -p -e "s/~DRIVER~/ODBC/g" <
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI/Driver.xst >
ODBC.xsi
/usr/local/bin/perl -I/usr/local/lib/perl5/5.6.1/i386-freebsd -I/usr/local/l
ib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.6.1/ExtUtils/typemap ODBC.xs > ODBC.xsc && mv
ODBC.xsc ODBC.c
cc -c -I. -I/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI -fno-
strict-aliasing -I/usr/local/include -O -DVERSION=\"0.35\" -DXS_VERSION=
\"0.35\" -DPIC -fpic -I/usr/local/lib/perl5/5.6.1/i386-freebsd/CORE -I/usr/l
ocal/include ODBC.c
cc -c -I. -I/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI -fno-
strict-aliasing -I/usr/local/include -O -DVERSION=\"0.35\" -DXS_VERSION=
\"0.35\" -DPIC -fpic -I/usr/local/lib/perl5/5.6.1/i386-freebsd/CORE -I/usr/l
ocal/include dbdimp.c
dbdimp.c:1572: warning: `_dbd_rebind_ph' was declared implicitly `extern'
and later `static'
dbdimp.c:1121: warning: previous declaration of `_dbd_rebind_ph'
Running Mkbootstrap for DBD::ODBC ()
chmod 644 ODBC.bs
rm -f blib/arch/auto/DBD/ODBC/ODBC.so
LD_RUN_PATH="/usr/local/lib" cc -shared -L/usr/local/lib ODBC.o
dbdimp.o -o blib/arch/auto/DBD/ODBC/ODBC.so -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.3
# make test
PERL_DL_NONLAZY=1
/usr/local/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.1/i386
-freebsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; runtests @ARGV;' t/*.t
t/01base............install_driver(ODBC) failed: Can't load
'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:
blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at
/usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/01base.t line 14
t/01base............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/02simple..........ok 1/17install_driver(ODBC) failed: Can't load
'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:
blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at
/usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/02simple.t line 13
t/02simple..........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-17
Failed 16/17 tests, 5.88% okay
t/03dbatt...........ok 1/6install_driver(ODBC) failed: Can't load
'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:
blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at
/usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/03dbatt.t line 12
t/03dbatt...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-6
Failed 5/6 tests, 16.67% okay
t/05meth............ok 1/6install_driver(ODBC) failed: Can't load
'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:
blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at
/usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/05meth.t line 13
t/05meth............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-6
Failed 5/6 tests, 16.67% okay
t/07bind............ok 1/9install_driver(ODBC) failed: Can't load
'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:
blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at
/usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/07bind.t line 11
t/07bind............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-9
Failed 8/9 tests, 11.11% okay
t/08bind2...........install_driver(ODBC) failed: Can't load
'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:
blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at
/usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/08bind2.t line 19
t/08bind2...........dubious
Test returned status 255 (wstat 65280, 0xff00)
t/09multi...........install_driver(ODBC) failed: Can't load
'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:
blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at
/usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/09multi.t line 20
t/09multi...........dubious
Test returned status 255 (wstat 65280, 0xff00)
Failed Test Status Wstat Total Fail Failed List of Failed
----------------------------------------------------------------------------
----
t/01base.t 255 65280 5 2 40.00% 4-5
t/02simple.t 255 65280 17 16 94.12% 2-17
t/03dbatt.t 255 65280 6 5 83.33% 2-6
t/05meth.t 255 65280 6 5 83.33% 2-6
t/07bind.t 255 65280 9 8 88.89% 2-9
t/08bind2.t 255 65280 ?? ?? % ??
t/09multi.t 255 65280 ?? ?? % ??
Failed 7/7 test scripts, 0.00% okay. 36/43 subtests failed, 16.28% okay.
*** Error code 2
Stop in /root/.cpan/build/DBD-ODBC-0.35.
# make test TEST_VERBOSE=1
PERL_DL_NONLAZY=1
/usr/local/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.1/i386
-freebsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=1; runtests @ARGV;' t/*.t
t/01base............install_driver(ODBC) failed: Can't load
'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:
blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at
/usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/01base.t line 14
1..5
ok 1
ok 2
ok 3
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/02simple..........1..17
install_driver(ODBC) failed: Can't load 'blib/arch/auto/DBD/ODBC/ODBC.so'
for module DBD::ODBC: blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol
"SQLFreeHandle" at /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm
line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/02simple.t line 13
ok 1
Test 2: connecting to the database
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-17
Failed 16/17 tests, 5.88% okay
t/03dbatt...........1..6
install_driver(ODBC) failed: Can't load 'blib/arch/auto/DBD/ODBC/ODBC.so'
for module DBD::ODBC: blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol
"SQLFreeHandle" at /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm
line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/03dbatt.t line 12
ok 1
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-6
Failed 5/6 tests, 16.67% okay
t/05meth............1..6
install_driver(ODBC) failed: Can't load 'blib/arch/auto/DBD/ODBC/ODBC.so'
for module DBD::ODBC: blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol
"SQLFreeHandle" at /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm
line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/05meth.t line 13
ok 1
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-6
Failed 5/6 tests, 16.67% okay
t/07bind............1..9
ok 1
install_driver(ODBC) failed: Can't load 'blib/arch/auto/DBD/ODBC/ODBC.so'
for module DBD::ODBC: blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol
"SQLFreeHandle" at /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm
line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/07bind.t line 11
Test 2: connecting to the database
dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-9
Failed 8/9 tests, 11.11% okay
t/08bind2...........install_driver(ODBC) failed: Can't load
'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:
blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at
/usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/08bind2.t line 19
dubious
Test returned status 255 (wstat 65280, 0xff00)
t/09multi...........install_driver(ODBC) failed: Can't load
'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC:
blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at
/usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/09multi.t line 20
dubious
Test returned status 255 (wstat 65280, 0xff00)
Failed Test Status Wstat Total Fail Failed List of Failed
----------------------------------------------------------------------------
----
t/01base.t 255 65280 5 2 40.00% 4-5
t/02simple.t 255 65280 17 16 94.12% 2-17
t/03dbatt.t 255 65280 6 5 83.33% 2-6
t/05meth.t 255 65280 6 5 83.33% 2-6
t/07bind.t 255 65280 9 8 88.89% 2-9
t/08bind2.t 255 65280 ?? ?? % ??
t/09multi.t 255 65280 ?? ?? % ??
Failed 7/7 test scripts, 0.00% okay. 36/43 subtests failed, 16.28% okay.
*** Error code 2
Stop in /root/.cpan/build/DBD-ODBC-0.35.
