Re: faied tests installing DBD::ODBC on FreeBSD
From: Blake Mitchell (blake_at_barkingspoon.com)
Date: 11/11/04
- Previous message: Morrison Davis: "Re: DBI/DBD on 9i with Solaris 9"
- In reply to: Jeff Urlwin: "RE: faied tests installing DBD::ODBC on FreeBSD"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 11 Nov 2004 14:50:03 -0800 To: dbi-users@perl.org
Thanks for the reply Jeff, the answers to your questions are inline.
Doesn't do much for me, but hopefully someone more experienced will be
able to see something of value.
Jeff Urlwin wrote:
>
>It's trying to connect and fail. While I'm not an expert on FreeTDS, I'd ask the
>following questions:
>1) is the DBI_DSN set correctly? (i.e. the same DSN you use to connect with isql)
>
>
blake@longimanus:/usr/local/src/DBD-ODBC-1.13$ echo $DBI_DSN
dbi:ODBC:Test
blake@longimanus:/usr/local/src/DBD-ODBC-1.13$
/usr/local/unixodbc/bin/isql Test $DBI_USER $DBI_PASS
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select top 1 * from Region
+------------+---------------------------------------------------+
| RegionID | RegionDescription |
+------------+---------------------------------------------------+
| 1 | Eastern |
+------------+---------------------------------------------------+
SQLRowCount returns 1
1 rows fetched
>2) is there a chance that DBD::ODBC's Makefile.PL picked up iODBC instead of unixODBC.
>
>
blake@longimanus:/usr/local/src/DBD-ODBC-1.13$ ldd
blib/arch/auto/DBD/ODBC/ODBC.so
blib/arch/auto/DBD/ODBC/ODBC.so:
libodbc.so.1 => /usr/local/unixodbc/lib/libodbc.so.1 (0x28118000)
libc_r.so.4 => /usr/lib/libc_r.so.4 (0x2817a000)
libc.so.4 => /usr/lib/libc.so.4 (0x28069000)
>3) can you try simply running the test with DBI trace on (set DBI_TRACE=9 before you run
>make test)
>
>
blake@longimanus:/usr/local/src/DBD-ODBC-1.13$ make test TEST_VERBOSE=1
PERL_DL_NONLAZY=1 /usr/local/perl/bin/perl "-MExtUtils::Command::MM"
"-e" "test_harness(1, 'blib/lib', 'blib/arch')" t/*.t
t/01base.........1..5
DBI 1.45-nothread default trace level set to 0x0/9 (pid 11348)
ok 1 - require DBI;
New DBI::dr (for DBD::Switch::dr, parent=, id=)
ok 2 - import DBI
dbih_setup_handle(DBI::dr=HASH(0x82482f4)=>DBI::dr=HASH(0x8215198),
DBD::Switch::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::Switch::dr, 112, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x8215198), Err, Null!)
SCALAR(0x82488cc) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8215198), State, Null!)
SCALAR(0x82488b4) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8215198), Errstr, Null!)
SCALAR(0x82488e4) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8215198), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8215198), FetchHashKeyName, Null!)
'NAME' (already defined)
ok 3 - DBI->internal is DBI::dr
-> DBI->install_driver(ODBC) for freebsd perl=5.008003 pid=11348
ruid=1003 euid=1003
install_driver: DBD::ODBC version 1.13 loaded from
/usr/local/src/DBD-ODBC-1.13/blib/lib/DBD/ODBC.pm
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x8215270)=>DBI::dr=HASH(0x820df0c),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x820df0c), Err, Null!)
SCALAR(0x8211688) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x820df0c), State, Null!)
SCALAR(0x8211640) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x820df0c), Errstr, Null!)
SCALAR(0x8211658) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x820df0c), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x820df0c), FetchHashKeyName, Null!)
'NAME' (already defined)
<- install_driver= DBI::dr=HASH(0x8215270)
ok 4 - Install ODBC driver OK
>> FETCH DISPATCH (DBI::dr=HASH(0x820df0c) rc2/1 @2 g0 ima404
pid#11348) at /usr/local/perl/lib/5.8.3/Test/More.pm line 268 via
t/01base.t line 18
warn: 0 '' (err#0)
<> FETCH= '1.13' ('Version' from cache) at
/usr/local/perl/lib/5.8.3/Test/More.pm line 268 via t/01base.t line 18
ok 5 - Version is not empty
-- DBI::END
>> disconnect_all DISPATCH (DBI::dr=HASH(0x8215270) rc1/4 @1 g0
ima801 pid#11348) at
/usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm line 673 via
t/01base.t line 0
!! warn: 0 CLEARED by call to disconnect_all method
-> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x8215270)~0x820df0c)
<- disconnect_all= '' at
/usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm line 673 via
t/01base.t line 0
! >> DESTROY DISPATCH (DBI::dr=HASH(0x820df0c) rc1/1 @1 g0 ima4
pid#11348) during global destruction
! -> DESTROY in DBD::_::common for DBD::ODBC::dr
(DBI::dr=HASH(0x820df0c)~INNER)
! <- DESTROY= undef during global destruction
DESTROY (dbih_clearcom) (drh 0x8215270, com 0x8264f00, imp global
destruction):
FLAGS 0x100215: COMSET Active Warn PrintWarn AutoCommit
PARENT undef
KIDS 0 (0 Active)
IMP_DATA undef
dbih_clearcom 0x8215270 (com 0x8264f00, type 1) done.
! >> DESTROY DISPATCH (DBI::dr=HASH(0x8215198) rc1/1 @1 g0 ima4
pid#11348) during global destruction
! -> DESTROY in DBD::_::common for DBD::Switch::dr
(DBI::dr=HASH(0x8215198)~INNER)
warn: 0 '' (err#0)
! <- DESTROY= undef during global destruction
DESTROY (dbih_clearcom) (drh 0x82482f4, com 0x811c800, imp global
destruction):
FLAGS 0x100215: COMSET Active Warn PrintWarn AutoCommit
PARENT undef
KIDS 0 (0 Active)
IMP_DATA undef
dbih_clearcom 0x82482f4 (com 0x811c800, type 1) done.
! >> DESTROY DISPATCH (DBI::dr=HASH(0x82482f4) rc1/1 @1 g0 ima4
pid#11348) during global destruction
! <> DESTROY for DBI::dr=HASH(0x82482f4) ignored (inner handle gone)
! >> DESTROY DISPATCH (DBI::dr=HASH(0x8215270) rc1/1 @1 g0 ima4
pid#11348) during global destruction
! <> DESTROY for DBI::dr=HASH(0x8215270) ignored (inner handle gone)
ok
t/02simple.......1..36
DBI 1.45-nothread default trace level set to 0x0/9 (pid 11349)
ok 1 - use DBI;
ok 2 - use ODBCTEST;
-> DBI->connect(, , ****)
-> DBI->install_driver(ODBC) for freebsd perl=5.008003 pid=11349
ruid=1003 euid=1003
install_driver: DBD::ODBC version 1.13 loaded from
/usr/local/src/DBD-ODBC-1.13/blib/lib/DBD/ODBC.pm
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x825c890)=>DBI::dr=HASH(0x82aa7a8),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x82aa7a8), Err, Null!)
SCALAR(0x821b144) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82aa7a8), State, Null!)
SCALAR(0x821b12c) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82aa7a8), Errstr, Null!)
SCALAR(0x821b1a4) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82aa7a8), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82aa7a8), FetchHashKeyName, Null!)
'NAME' (already defined)
<- install_driver= DBI::dr=HASH(0x825c890)
>> default_user DISPATCH (DBI::dr=HASH(0x825c890) rc1/3 @4 g1 ima1
pid#11349) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 576 via t/02simple.t line 21
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::ODBC::dr
(DBI::dr=HASH(0x825c890)~0x82aa7a8 undef undef HASH(0x822fd74))
<- default_user= ( 'keith' '<removed>' ) [2 items] at
/usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm line 576 via
t/02simple.t line 21
>> connect DISPATCH (DBI::dr=HASH(0x825c890) rc2/3 @5 g0 ima1
pid#11349) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 594
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x825c890)~0x82aa7a8
'Test' 'keith' **** HASH(0x82b3718))
New DBI::db (for DBD::ODBC::db, parent=DBI::dr=HASH(0x82aa7a8), id=)
dbih_setup_handle(DBI::db=HASH(0x82aa76c)=>DBI::db=HASH(0x82b376c),
DBD::ODBC::db, 8259dc8, Null!)
dbih_make_com(DBI::dr=HASH(0x82aa7a8), 829e700, DBD::ODBC::db, 224,
0) thr#0
dbih_setup_attrib(DBI::db=HASH(0x82b376c), Err,
DBI::dr=HASH(0x82aa7a8)) SCALAR(0x825cdf8) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82b376c), State,
DBI::dr=HASH(0x82aa7a8)) SCALAR(0x825ce58) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82b376c), Errstr,
DBI::dr=HASH(0x82aa7a8)) SCALAR(0x825ce28) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82b376c), TraceLevel,
DBI::dr=HASH(0x82aa7a8)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82b376c), FetchHashKeyName,
DBI::dr=HASH(0x82aa7a8)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82b376c), HandleSetErr,
DBI::dr=HASH(0x82aa7a8)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x82b376c), HandleError,
DBI::dr=HASH(0x82aa7a8)) undef (not defined)
Driver connect 'Test', 'keith', 'xxxx'
SQLDriverConnect failed:
SQLConnect 'Test', 'keith'
dubious
Test returned status 0 (wstat 138, 0x8a)
test program seems to have generated a core
DIED. FAILED tests 3-36
Failed 34/36 tests, 5.56% okay
t/03dbatt........1..24
DBI 1.45-nothread default trace level set to 0x0/9 (pid 11350)
ok 1 - use DBI;
ok 2 - use ODBCTEST;
-> DBI->connect(, , ****)
-> DBI->install_driver(ODBC) for freebsd perl=5.008003 pid=11350
ruid=1003 euid=1003
install_driver: DBD::ODBC version 1.13 loaded from
/usr/local/src/DBD-ODBC-1.13/blib/lib/DBD/ODBC.pm
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x825503c)=>DBI::dr=HASH(0x82a8824),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x82a8824), Err, Null!)
SCALAR(0x811e1c8) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82a8824), State, Null!)
SCALAR(0x8122fb4) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82a8824), Errstr, Null!)
SCALAR(0x8122ee8) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82a8824), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82a8824), FetchHashKeyName, Null!)
'NAME' (already defined)
<- install_driver= DBI::dr=HASH(0x825503c)
>> default_user DISPATCH (DBI::dr=HASH(0x825503c) rc1/3 @4 g1 ima1
pid#11350) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 576 via t/03dbatt.t line 24
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::ODBC::dr
(DBI::dr=HASH(0x825503c)~0x82a8824 undef undef HASH(0x8226938))
<- default_user= ( 'keith' '<removed>' ) [2 items] at
/usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm line 576 via
t/03dbatt.t line 24
>> connect DISPATCH (DBI::dr=HASH(0x825503c) rc2/3 @5 g0 ima1
pid#11350) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 594
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x825503c)~0x82a8824
'Test' 'keith' **** HASH(0x82a8b78))
New DBI::db (for DBD::ODBC::db, parent=DBI::dr=HASH(0x82a8824), id=)
dbih_setup_handle(DBI::db=HASH(0x829e7cc)=>DBI::db=HASH(0x82a8bcc),
DBD::ODBC::db, 824f974, Null!)
dbih_make_com(DBI::dr=HASH(0x82a8824), 82a0400, DBD::ODBC::db, 224,
0) thr#0
dbih_setup_attrib(DBI::db=HASH(0x82a8bcc), Err,
DBI::dr=HASH(0x82a8824)) SCALAR(0x82559a4) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a8bcc), State,
DBI::dr=HASH(0x82a8824)) SCALAR(0x8255a04) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a8bcc), Errstr,
DBI::dr=HASH(0x82a8824)) SCALAR(0x82559d4) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a8bcc), TraceLevel,
DBI::dr=HASH(0x82a8824)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a8bcc), FetchHashKeyName,
DBI::dr=HASH(0x82a8824)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a8bcc), HandleSetErr,
DBI::dr=HASH(0x82a8824)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x82a8bcc), HandleError,
DBI::dr=HASH(0x82a8824)) undef (not defined)
Driver connect 'Test', 'keith', 'xxxx'
SQLDriverConnect failed:
SQLConnect 'Test', 'keith'
dubious
Test returned status 0 (wstat 138, 0x8a)
test program seems to have generated a core
DIED. FAILED tests 3-24
Failed 22/24 tests, 8.33% okay
t/05meth.........1..8
DBI 1.45-nothread default trace level set to 0x0/9 (pid 11351)
ok 1 - use DBI;
-> DBI->connect(, , ****)
-> DBI->install_driver(ODBC) for freebsd perl=5.008003 pid=11351
ruid=1003 euid=1003
install_driver: DBD::ODBC version 1.13 loaded from
/usr/local/src/DBD-ODBC-1.13/blib/lib/DBD/ODBC.pm
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x824e460)=>DBI::dr=HASH(0x829b418),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x829b418), Err, Null!)
SCALAR(0x820fd44) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x829b418), State, Null!)
SCALAR(0x820fcf0) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x829b418), Errstr, Null!)
SCALAR(0x820fd20) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x829b418), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x829b418), FetchHashKeyName, Null!)
'NAME' (already defined)
<- install_driver= DBI::dr=HASH(0x824e460)
>> default_user DISPATCH (DBI::dr=HASH(0x824e460) rc1/3 @4 g1 ima1
pid#11351) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 576 via t/05meth.t line 24
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::ODBC::dr
(DBI::dr=HASH(0x824e460)~0x829b418 undef undef HASH(0x822615c))
<- default_user= ( 'keith' '<removed>' ) [2 items] at
/usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm line 576 via
t/05meth.t line 24
>> connect DISPATCH (DBI::dr=HASH(0x824e460) rc2/3 @5 g0 ima1
pid#11351) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 594
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x824e460)~0x829b418
'Test' 'keith' **** HASH(0x829b76c))
New DBI::db (for DBD::ODBC::db, parent=DBI::dr=HASH(0x829b418), id=)
dbih_setup_handle(DBI::db=HASH(0x8298bc0)=>DBI::db=HASH(0x829b7c0),
DBD::ODBC::db, 824bd98, Null!)
dbih_make_com(DBI::dr=HASH(0x829b418), 81c5980, DBD::ODBC::db, 224,
0) thr#0
dbih_setup_attrib(DBI::db=HASH(0x829b7c0), Err,
DBI::dr=HASH(0x829b418)) SCALAR(0x824edc8) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x829b7c0), State,
DBI::dr=HASH(0x829b418)) SCALAR(0x824ee28) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x829b7c0), Errstr,
DBI::dr=HASH(0x829b418)) SCALAR(0x824edf8) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x829b7c0), TraceLevel,
DBI::dr=HASH(0x829b418)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x829b7c0), FetchHashKeyName,
DBI::dr=HASH(0x829b418)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x829b7c0), HandleSetErr,
DBI::dr=HASH(0x829b418)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x829b7c0), HandleError,
DBI::dr=HASH(0x829b418)) undef (not defined)
Driver connect 'Test', 'keith', 'xxxx'
SQLDriverConnect failed:
SQLConnect 'Test', 'keith'
dubious
Test returned status 0 (wstat 138, 0x8a)
test program seems to have generated a core
DIED. FAILED tests 2-8
Failed 7/8 tests, 12.50% okay
t/07bind......... DBI 1.45-nothread default trace level set to 0x0/9
(pid 11352)
1..11
ok 1 - use ODBCTEST;
-> DBI->connect(, , ****)
-> DBI->install_driver(ODBC) for freebsd perl=5.008003 pid=11352
ruid=1003 euid=1003
install_driver: DBD::ODBC version 1.13 loaded from
/usr/local/src/DBD-ODBC-1.13/blib/lib/DBD/ODBC.pm
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x8249658)=>DBI::dr=HASH(0x8299b6c),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x8299b6c), Err, Null!)
SCALAR(0x819e700) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8299b6c), State, Null!)
SCALAR(0x8214908) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8299b6c), Errstr, Null!)
SCALAR(0x82149c8) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8299b6c), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8299b6c), FetchHashKeyName, Null!)
'NAME' (already defined)
<- install_driver= DBI::dr=HASH(0x8249658)
>> default_user DISPATCH (DBI::dr=HASH(0x8249658) rc1/3 @4 g1 ima1
pid#11352) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 576 via t/07bind.t line 22
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::ODBC::dr
(DBI::dr=HASH(0x8249658)~0x8299b6c undef undef HASH(0x821f754))
<- default_user= ( 'keith' '<removed>' ) [2 items] at
/usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm line 576 via
t/07bind.t line 22
>> connect DISPATCH (DBI::dr=HASH(0x8249658) rc2/3 @5 g0 ima1
pid#11352) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 594
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x8249658)~0x8299b6c
'Test' 'keith' **** HASH(0x82abadc))
New DBI::db (for DBD::ODBC::db, parent=DBI::dr=HASH(0x8299b6c), id=)
dbih_setup_handle(DBI::db=HASH(0x8299b30)=>DBI::db=HASH(0x82abb30),
DBD::ODBC::db, 8247b90, Null!)
dbih_make_com(DBI::dr=HASH(0x8299b6c), 829e600, DBD::ODBC::db, 224,
0) thr#0
dbih_setup_attrib(DBI::db=HASH(0x82abb30), Err,
DBI::dr=HASH(0x8299b6c)) SCALAR(0x8249fc0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82abb30), State,
DBI::dr=HASH(0x8299b6c)) SCALAR(0x824e43c) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82abb30), Errstr,
DBI::dr=HASH(0x8299b6c)) SCALAR(0x824e40c) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82abb30), TraceLevel,
DBI::dr=HASH(0x8299b6c)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82abb30), FetchHashKeyName,
DBI::dr=HASH(0x8299b6c)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82abb30), HandleSetErr,
DBI::dr=HASH(0x8299b6c)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x82abb30), HandleError,
DBI::dr=HASH(0x8299b6c)) undef (not defined)
Driver connect 'Test', 'keith', 'xxxx'
SQLDriverConnect failed:
SQLConnect 'Test', 'keith'
dubious
Test returned status 0 (wstat 138, 0x8a)
test program seems to have generated a core
DIED. FAILED tests 2-11
Failed 10/11 tests, 9.09% okay
t/08bind2........ DBI 1.45-nothread default trace level set to 0x0/9
(pid 11353)
1..5
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
-> DBI->connect(, , ****)
-> DBI->install_driver(ODBC) for freebsd perl=5.008003 pid=11353
ruid=1003 euid=1003
install_driver: DBD::ODBC version 1.13 loaded from
/usr/local/src/DBD-ODBC-1.13/blib/lib/DBD/ODBC.pm
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x8248658)=>DBI::dr=HASH(0x82e086c),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x82e086c), Err, Null!)
SCALAR(0x82dea34) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82e086c), State, Null!)
SCALAR(0x82de998) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82e086c), Errstr, Null!)
SCALAR(0x82dea04) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82e086c), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82e086c), FetchHashKeyName, Null!)
'NAME' (already defined)
<- install_driver= DBI::dr=HASH(0x8248658)
>> default_user DISPATCH (DBI::dr=HASH(0x8248658) rc1/3 @4 g1 ima1
pid#11353) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 576 via t/08bind2.t line 26
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::ODBC::dr
(DBI::dr=HASH(0x8248658)~0x82e086c undef undef HASH(0x821e754))
<- default_user= ( 'keith' '<removed>' ) [2 items] at
/usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm line 576 via
t/08bind2.t line 26
>> connect DISPATCH (DBI::dr=HASH(0x8248658) rc2/3 @5 g0 ima1
pid#11353) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 594
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x8248658)~0x82e086c
'Test' 'keith' **** HASH(0x82e0bc0))
New DBI::db (for DBD::ODBC::db, parent=DBI::dr=HASH(0x82e086c), id=)
dbih_setup_handle(DBI::db=HASH(0x82e0830)=>DBI::db=HASH(0x82e2030),
DBD::ODBC::db, 8246b90, Null!)
dbih_make_com(DBI::dr=HASH(0x82e086c), 82d7b80, DBD::ODBC::db, 224,
0) thr#0
dbih_setup_attrib(DBI::db=HASH(0x82e2030), Err,
DBI::dr=HASH(0x82e086c)) SCALAR(0x8248fc0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82e2030), State,
DBI::dr=HASH(0x82e086c)) SCALAR(0x824d43c) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82e2030), Errstr,
DBI::dr=HASH(0x82e086c)) SCALAR(0x824d40c) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82e2030), TraceLevel,
DBI::dr=HASH(0x82e086c)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82e2030), FetchHashKeyName,
DBI::dr=HASH(0x82e086c)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82e2030), HandleSetErr,
DBI::dr=HASH(0x82e086c)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x82e2030), HandleError,
DBI::dr=HASH(0x82e086c)) undef (not defined)
Driver connect 'Test', 'keith', 'xxxx'
SQLDriverConnect failed:
SQLConnect 'Test', 'keith'
dubious
Test returned status 0 (wstat 138, 0x8a)
test program seems to have generated a core
DIED. FAILED tests 3-5
Failed 3/5 tests, 40.00% okay
t/09multi........1..7
ok 1 - use strict;
DBI 1.45-nothread default trace level set to 0x0/9 (pid 11354)
ok 2 - use DBI;
ok 3 - use ODBCTEST;
-> DBI->connect(, , ****)
-> DBI->install_driver(ODBC) for freebsd perl=5.008003 pid=11354
ruid=1003 euid=1003
install_driver: DBD::ODBC version 1.13 loaded from
/usr/local/src/DBD-ODBC-1.13/blib/lib/DBD/ODBC.pm
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x8251c3c)=>DBI::dr=HASH(0x82a4478),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x82a4478), Err, Null!)
SCALAR(0x8218d80) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82a4478), State, Null!)
SCALAR(0x811e15c) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82a4478), Errstr, Null!)
SCALAR(0x811e0c0) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82a4478), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82a4478), FetchHashKeyName, Null!)
'NAME' (already defined)
<- install_driver= DBI::dr=HASH(0x8251c3c)
>> default_user DISPATCH (DBI::dr=HASH(0x8251c3c) rc1/3 @4 g1 ima1
pid#11354) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 576 via t/09multi.t line 26
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::ODBC::dr
(DBI::dr=HASH(0x8251c3c)~0x82a4478 undef undef HASH(0x8226938))
<- default_user= ( 'keith' '<removed>' ) [2 items] at
/usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm line 576 via
t/09multi.t line 26
>> connect DISPATCH (DBI::dr=HASH(0x8251c3c) rc2/3 @5 g0 ima1
pid#11354) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 594
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x8251c3c)~0x82a4478
'Test' 'keith' **** HASH(0x82a47cc))
New DBI::db (for DBD::ODBC::db, parent=DBI::dr=HASH(0x82a4478), id=)
dbih_setup_handle(DBI::db=HASH(0x82a443c)=>DBI::db=HASH(0x82a483c),
DBD::ODBC::db, 8251174, Null!)
dbih_make_com(DBI::dr=HASH(0x82a4478), 8294680, DBD::ODBC::db, 224,
0) thr#0
dbih_setup_attrib(DBI::db=HASH(0x82a483c), Err,
DBI::dr=HASH(0x82a4478)) SCALAR(0x82545a4) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a483c), State,
DBI::dr=HASH(0x82a4478)) SCALAR(0x8254604) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a483c), Errstr,
DBI::dr=HASH(0x82a4478)) SCALAR(0x82545d4) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a483c), TraceLevel,
DBI::dr=HASH(0x82a4478)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a483c), FetchHashKeyName,
DBI::dr=HASH(0x82a4478)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82a483c), HandleSetErr,
DBI::dr=HASH(0x82a4478)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x82a483c), HandleError,
DBI::dr=HASH(0x82a4478)) undef (not defined)
Driver connect 'Test', 'keith', 'xxxx'
SQLDriverConnect failed:
SQLConnect 'Test', 'keith'
dubious
Test returned status 0 (wstat 138, 0x8a)
test program seems to have generated a core
DIED. FAILED tests 4-7
Failed 4/7 tests, 42.86% okay
t/20SqlServer.... DBI 1.45-nothread default trace level set to 0x0/9
(pid 11355)
1..37
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
-> DBI->connect(, , ****)
-> DBI->install_driver(ODBC) for freebsd perl=5.008003 pid=11355
ruid=1003 euid=1003
install_driver: DBD::ODBC version 1.13 loaded from
/usr/local/src/DBD-ODBC-1.13/blib/lib/DBD/ODBC.pm
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x824b658)=>DBI::dr=HASH(0x830649c),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x830649c), Err, Null!)
SCALAR(0x82ffa64) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x830649c), State, Null!)
SCALAR(0x82ff9c8) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x830649c), Errstr, Null!)
SCALAR(0x82ffa34) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x830649c), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x830649c), FetchHashKeyName, Null!)
'NAME' (already defined)
<- install_driver= DBI::dr=HASH(0x824b658)
>> default_user DISPATCH (DBI::dr=HASH(0x824b658) rc1/3 @4 g1 ima1
pid#11355) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 576 via t/20SqlServer.t line 47
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::ODBC::dr
(DBI::dr=HASH(0x824b658)~0x830649c undef undef HASH(0x8221754))
<- default_user= ( 'keith' '<removed>' ) [2 items] at
/usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm line 576 via
t/20SqlServer.t line 47
>> connect DISPATCH (DBI::dr=HASH(0x824b658) rc2/3 @5 g0 ima1
pid#11355) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 594
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x824b658)~0x830649c
'Test' 'keith' **** HASH(0x830680c))
New DBI::db (for DBD::ODBC::db, parent=DBI::dr=HASH(0x830649c), id=)
dbih_setup_handle(DBI::db=HASH(0x8306460)=>DBI::db=HASH(0x8306860),
DBD::ODBC::db, 8249b90, Null!)
dbih_make_com(DBI::dr=HASH(0x830649c), 812d000, DBD::ODBC::db, 224,
0) thr#0
dbih_setup_attrib(DBI::db=HASH(0x8306860), Err,
DBI::dr=HASH(0x830649c)) SCALAR(0x824bfc0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8306860), State,
DBI::dr=HASH(0x830649c)) SCALAR(0x825043c) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8306860), Errstr,
DBI::dr=HASH(0x830649c)) SCALAR(0x825040c) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8306860), TraceLevel,
DBI::dr=HASH(0x830649c)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8306860), FetchHashKeyName,
DBI::dr=HASH(0x830649c)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8306860), HandleSetErr,
DBI::dr=HASH(0x830649c)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x8306860), HandleError,
DBI::dr=HASH(0x830649c)) undef (not defined)
Driver connect 'Test', 'keith', 'xxxx'
SQLDriverConnect failed:
SQLConnect 'Test', 'keith'
dubious
Test returned status 0 (wstat 138, 0x8a)
test program seems to have generated a core
DIED. FAILED tests 3-37
Failed 35/37 tests, 5.41% okay
t/30Oracle....... DBI 1.45-nothread default trace level set to 0x0/9
(pid 11356)
1..4
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
-> DBI->connect(, , ****)
-> DBI->install_driver(ODBC) for freebsd perl=5.008003 pid=11356
ruid=1003 euid=1003
install_driver: DBD::ODBC version 1.13 loaded from
/usr/local/src/DBD-ODBC-1.13/blib/lib/DBD/ODBC.pm
New DBI::dr (for DBD::ODBC::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x8248658)=>DBI::dr=HASH(0x82df378),
DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#0
dbih_setup_attrib(DBI::dr=HASH(0x82df378), Err, Null!)
SCALAR(0x82db95c) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82df378), State, Null!)
SCALAR(0x82db8c0) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82df378), Errstr, Null!)
SCALAR(0x82db92c) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82df378), TraceLevel, Null!) 0
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x82df378), FetchHashKeyName, Null!)
'NAME' (already defined)
<- install_driver= DBI::dr=HASH(0x8248658)
>> default_user DISPATCH (DBI::dr=HASH(0x8248658) rc1/3 @4 g1 ima1
pid#11356) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 576 via t/30Oracle.t line 26
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::ODBC::dr
(DBI::dr=HASH(0x8248658)~0x82df378 undef undef HASH(0x821d754))
<- default_user= ( 'keith' '<removed>' ) [2 items] at
/usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm line 576 via
t/30Oracle.t line 26
>> connect DISPATCH (DBI::dr=HASH(0x8248658) rc2/3 @5 g0 ima1
pid#11356) at /usr/local/perl/lib/site_perl/5.8.3/i386-freebsd/DBI.pm
line 594
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x8248658)~0x82df378
'Test' 'keith' **** HASH(0x82e0ae8))
New DBI::db (for DBD::ODBC::db, parent=DBI::dr=HASH(0x82df378), id=)
dbih_setup_handle(DBI::db=HASH(0x82df33c)=>DBI::db=HASH(0x82e0b3c),
DBD::ODBC::db, 8246b90, Null!)
dbih_make_com(DBI::dr=HASH(0x82df378), 82d3b80, DBD::ODBC::db, 224,
0) thr#0
dbih_setup_attrib(DBI::db=HASH(0x82e0b3c), Err,
DBI::dr=HASH(0x82df378)) SCALAR(0x8248fc0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82e0b3c), State,
DBI::dr=HASH(0x82df378)) SCALAR(0x824d43c) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82e0b3c), Errstr,
DBI::dr=HASH(0x82df378)) SCALAR(0x824d40c) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82e0b3c), TraceLevel,
DBI::dr=HASH(0x82df378)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82e0b3c), FetchHashKeyName,
DBI::dr=HASH(0x82df378)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x82e0b3c), HandleSetErr,
DBI::dr=HASH(0x82df378)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x82e0b3c), HandleError,
DBI::dr=HASH(0x82df378)) undef (not defined)
Driver connect 'Test', 'keith', 'xxxx'
SQLDriverConnect failed:
SQLConnect 'Test', 'keith'
dubious
Test returned status 0 (wstat 138, 0x8a)
test program seems to have generated a core
DIED. FAILED tests 3-4
Failed 2/4 tests, 50.00% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/02simple.t 0 138 36 68 188.89% 3-36
t/03dbatt.t 0 138 24 44 183.33% 3-24
t/05meth.t 0 138 8 14 175.00% 2-8
t/07bind.t 0 138 11 20 181.82% 2-11
t/08bind2.t 0 138 5 6 120.00% 3-5
t/09multi.t 0 138 7 8 114.29% 4-7
t/20SqlServer.t 0 138 37 70 189.19% 3-37
t/30Oracle.t 0 138 4 4 100.00% 3-4
Failed 8/9 test scripts, 11.11% okay. 117/137 subtests failed, 14.60% okay.
*** Error code 2
Stop in /usr/local/src/DBD-ODBC-1.13.
- Previous message: Morrison Davis: "Re: DBI/DBD on 9i with Solaris 9"
- In reply to: Jeff Urlwin: "RE: faied tests installing DBD::ODBC on FreeBSD"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
