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
