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/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 > 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/05meth............1..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 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 >
