Re: faied tests installing DBD::ODBC on FreeBSD

Blake Mitchell Fri, 12 Nov 2004 01:55:03 -0800

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)

[EMAIL PROTECTED]:/usr/local/src/DBD-ODBC-1.13$ echo $DBI_DSN dbi:ODBC:Test [EMAIL PROTECTED]:/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.

[EMAIL PROTECTED]:/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)

[EMAIL PROTECTED]:/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.

Re: faied tests installing DBD::ODBC on FreeBSD

Reply via email to