RE: ODBC fails on test
I did so and now when I do an 'make test TEST_VERBOSE=1' Ill get: 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/01base1..5 ok 1 ok 2 ok 3 ok 4 ok 5 ok t/02simple..1..17 ok 1 Test 2: connecting to the database ok 2 Test 3: create test table And here it just stops. Ill have to abort it with a Ctrl+C. John, Would you do me a favor and go into ODBC.pm and comment out the whole do routine. Let me know if that gets the tests to pass for you. It's some relatively new code using SQLExecDirect instead of the whole prepare(), execute cycle. Let me know if that passes all the tests for you. I'll try to get MySQL up and running here, too. Thanks, Jeff -Original Message- From: John Ericson [mailto:[EMAIL PROTECTED]]On Behalf Of John Ericson Sent: Sunday, February 17, 2002 1:23 PM To: [EMAIL PROTECTED] Subject: Re: ODBC fails on test It works! Ah, it was a simple problem with MySQL. It turned out it seached for mysql.sock in /var/lib/mysql while it exist in /tmp. Im having programs that seaches for this file in /tmp too so I have reconfiguring to do here. I fixed temporarly by doing an symlink from /var/lib/mysql. 'make test' performs better. It can contact the db but still fails with a couple of things. Ill guess its just some permissions thing on the mysql server. My test perl program work perfectly thoe, it connects through ODBC to mysql using a special user and I can do queries and all. Heres the outpur of 'make test': 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/01base1..5 ok 1 ok 2 ok 3 ok 4 ok 5 ok t/02simple..1..17 ok 1 Test 2: connecting to the database ok 2 Test 3: create test table dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-17 Failed 15/17 tests, 11.76% okay t/03dbatt...1..6 ok 1 ok 2 dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-6 Failed 4/6 tests, 33.33% okay t/05meth1..6 ok 1 ok 2
RE: ODBC fails on test
I made a mistake when I checked it earlier, ignore that e-mail. Here's the output: cp ODBC.pm blib/lib/DBD/ODBC.pm 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/01base1..5 ok 1 ok 2 ok 3 ok 4 ok 5 ok t/02simple..1..17 ok 1 Test 2: connecting to the database ok 2 Test 3: create test table Using fields: COL_A smallint, COL_B text, COL_C long varchar, COL_D date not ok 3 Test 4: check existance of test table not ok 4 Test 5: insert test data not ok 5 Test 6: select test data It stops here instead. John, Would you do me a favor and go into ODBC.pm and comment out the whole do routine. Let me know if that gets the tests to pass for you. It's some relatively new code using SQLExecDirect instead of the whole prepare(), execute cycle. Let me know if that passes all the tests for you. I'll try to get MySQL up and running here, too. Thanks, Jeff -Original Message- From: John Ericson [mailto:[EMAIL PROTECTED]]On Behalf Of John Ericson Sent: Sunday, February 17, 2002 1:23 PM To: [EMAIL PROTECTED] Subject: Re: ODBC fails on test It works! Ah, it was a simple problem with MySQL. It turned out it seached for mysql.sock in /var/lib/mysql while it exist in /tmp. Im having programs that seaches for this file in /tmp too so I have reconfiguring to do here. I fixed temporarly by doing an symlink from /var/lib/mysql. 'make test' performs better. It can contact the db but still fails with a couple of things. Ill guess its just some permissions thing on the mysql server. My test perl program work perfectly thoe, it connects through ODBC to mysql using a special user and I can do queries and all. Heres the outpur of 'make test': 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/01base1..5 ok 1 ok 2 ok 3 ok 4 ok 5 ok t/02simple..1..17 ok 1 Test 2: connecting to the database ok 2 Test 3: create test table dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-17 Failed 15/17 tests, 11.76% okay t/03dbatt...1..6 ok 1 ok 2 dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-6 Failed 4/6 tests, 33.33% okay t/05meth1..6 ok 1 ok 2
RE: ODBC fails on test
When I got back from lunch I noticed that it had appended a couple of lines since last: Test 4: check existance of test table not ok 4 Test 5: insert test data not ok 5 Test 6: select test data dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-17 Failed 15/17 tests, 11.76% okay t/03dbatt...1..6 ok 1 ok 2 Use of uninitialized value in numeric lt () at t/03dbatt.t line 19. Use of uninitialized value in numeric eq (==) at t/03dbatt.t line 20. not ok 3 ok 4 And here my remote connection timed out.
RE: ODBC fails on test
John, I'm trying to install MySQL and MyODBC. Here's what I've done so far: Install MySQL 3.23.49 from binary (non max version) Attempt to install MyODBC 3.51.01 from source or binary (fails as I don't have a specific client lib) I'm looking to fix the client lib issue and I'll see what's going on with the tests... Regards, Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 8:09 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: ODBC fails on test When I got back from lunch I noticed that it had appended a couple of lines since last: Test 4: check existance of test table not ok 4 Test 5: insert test data not ok 5 Test 6: select test data dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-17 Failed 15/17 tests, 11.76% okay t/03dbatt...1..6 ok 1 ok 2 Use of uninitialized value in numeric lt () at t/03dbatt.t line 19. Use of uninitialized value in numeric eq (==) at t/03dbatt.t line 20. not ok 3 ok 4 And here my remote connection timed out.
Re: ODBC fails on test
It works! Ah, it was a simple problem with MySQL. It turned out it seached for mysql.sock in /var/lib/mysql while it exist in /tmp. Im having programs that seaches for this file in /tmp too so I have reconfiguring to do here. I fixed temporarly by doing an symlink from /var/lib/mysql. 'make test' performs better. It can contact the db but still fails with a couple of things. Ill guess its just some permissions thing on the mysql server. My test perl program work perfectly thoe, it connects through ODBC to mysql using a special user and I can do queries and all. Heres the outpur of 'make test': 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/01base1..5 ok 1 ok 2 ok 3 ok 4 ok 5 ok t/02simple..1..17 ok 1 Test 2: connecting to the database ok 2 Test 3: create test table dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-17 Failed 15/17 tests, 11.76% okay t/03dbatt...1..6 ok 1 ok 2 dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-6 Failed 4/6 tests, 33.33% okay t/05meth1..6 ok 1 ok 2 On Feb 16 20:39, Jeff Urlwin wrote: John, I believe iODBC has a test program to ensure your ODBC.ini is correct. That should be the major issue. iODBC includes the odbctest program in the samples directory. I'm not sure what MySQL requires in the ODBC.ini, but I'd check that, too. Jeff -Original Message- From: John Ericson [mailto:[EMAIL PROTECTED]]On Behalf Of John Ericson Sent: Friday, February 15, 2002 8:39 PM To: [EMAIL PROTECTED] Subject: DBI:ODBC fails on test 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
RE: ODBC fails on test
John, Would you do me a favor and go into ODBC.pm and comment out the whole do routine. Let me know if that gets the tests to pass for you. It's some relatively new code using SQLExecDirect instead of the whole prepare(), execute cycle. Let me know if that passes all the tests for you. I'll try to get MySQL up and running here, too. Thanks, Jeff -Original Message- From: John Ericson [mailto:[EMAIL PROTECTED]]On Behalf Of John Ericson Sent: Sunday, February 17, 2002 1:23 PM To: [EMAIL PROTECTED] Subject: Re: ODBC fails on test It works! Ah, it was a simple problem with MySQL. It turned out it seached for mysql.sock in /var/lib/mysql while it exist in /tmp. Im having programs that seaches for this file in /tmp too so I have reconfiguring to do here. I fixed temporarly by doing an symlink from /var/lib/mysql. 'make test' performs better. It can contact the db but still fails with a couple of things. Ill guess its just some permissions thing on the mysql server. My test perl program work perfectly thoe, it connects through ODBC to mysql using a special user and I can do queries and all. Heres the outpur of 'make test': 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/01base1..5 ok 1 ok 2 ok 3 ok 4 ok 5 ok t/02simple..1..17 ok 1 Test 2: connecting to the database ok 2 Test 3: create test table dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-17 Failed 15/17 tests, 11.76% okay t/03dbatt...1..6 ok 1 ok 2 dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-6 Failed 4/6 tests, 33.33% okay t/05meth1..6 ok 1 ok 2 On Feb 16 20:39, Jeff Urlwin wrote: John, I believe iODBC has a test program to ensure your ODBC.ini is correct. That should be the major issue. iODBC includes the odbctest program in the samples directory. I'm not sure what MySQL requires in the ODBC.ini, but I'd check that, too. Jeff -Original Message- From: John Ericson [mailto:[EMAIL PROTECTED]]On Behalf Of John Ericson Sent: Friday, February 15, 2002 8:39 PM To: [EMAIL PROTECTED] Subject: DBI:ODBC fails on test 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
RE: ODBC fails on test
John, I believe iODBC has a test program to ensure your ODBC.ini is correct. That should be the major issue. iODBC includes the odbctest program in the samples directory. I'm not sure what MySQL requires in the ODBC.ini, but I'd check that, too. Jeff -Original Message- From: John Ericson [mailto:[EMAIL PROTECTED]]On Behalf Of John Ericson Sent: Friday, February 15, 2002 8:39 PM To: [EMAIL PROTECTED] Subject: DBI:ODBC fails on test 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/01base1..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/05meth1..6 ok 1 dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 2-6 Failed 5/6 tests, 16.67% okay t/07bind1..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 01517 16 94.12% 2-17 t/03dbatt.t 015 65 83.33% 2-6 t/05meth.t015 65