Re: [Dbi-interbase-devel] More DBD::Interbase install woes.
Status: Beta
Brought to you by:
edpratomo
|
From: Scott T. <sc...@dc...> - 2003-03-04 23:29:49
|
At 02:46 PM 3/04/03, Daniel Ritz wrote:
>hmm...i tried perl5.8.0, dbi-1.30, dbd-interbase-0.40 on a linux box with
>firebirdss-1.0.2.908-0.
>works like a charm. no problems. perl is even built with threads...
Yeah, I was quite sure it was only me. :(
>now i need a bit more information:
>- perl from distro or self compiled?
RH7.2 came with Perl 5.6.0 with an upgrade to 5.6.1, I built 5.8.0
myself. I removed it and reverted everything back to 5.6.1.
>- same for dbi
DBI-1.30 from CPAN source files
>- distro w/ version if these are distro packages
RH7.2
>- compiler
gcc-2.96-112.7.2
>- output of perl Makefile.PL
perl Makefile.PL
InterBase bin directory : [/opt/interbase/bin]
InterBase include directory : [/opt/interbase/include]
InterBase lib directory : [/opt/interbase/lib]
Reading cached test configuration...
Full path to your test database : [/opt/interbase/examples/employee.gdb]
Username : [SYSDBA]
Password : [masterkey]
Checking if your kit is complete...
Looks good
Using DBI 1.30 installed in /usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI
Writing Makefile for DBD::InterBase
>- output of make
# make
cp lib/DBD/InterBase/GetInfo.pm blib/lib/DBD/InterBase/GetInfo.pm
cp lib/Bundle/DBD/InterBase.pm blib/lib/Bundle/DBD/InterBase.pm
cp InterBase.pm blib/lib/DBD/InterBase.pm
cp lib/DBD/InterBase/FAQ.pm blib/lib/DBD/InterBase/FAQ.pm
/usr/bin/perl -p -e "s/~DRIVER~/InterBase/g" <
/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI/Driver.xst > InterBase.xsi
/usr/bin/perl -I/usr/lib/perl5/5.6.1/i386-linux -I/usr/lib/perl5/5.6.1
/usr/lib/perl5/5.6.1/ExtUtils/xsubpp -noprototypes -typemap
/usr/lib/perl5/5.6.1/ExtUtils/typemap -typemap typemap InterBase.xs >
InterBase.xsc && mv InterBase.xsc InterBase.c
gcc -c -I"/opt/interbase/include"
-I"/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI" -fno-strict-aliasing
-I/usr/local/include -O2 -march=i386 -mcpu=i686 -DVERSION=\"0.40\"
-DXS_VERSION=\"0.40\" -fPIC -I/usr/lib/perl5/5.6.1/i386-linux/CORE InterBase.c
gcc -c -I"/opt/interbase/include"
-I"/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBI" -fno-strict-aliasing
-I/usr/local/include -O2 -march=i386 -mcpu=i686 -DVERSION=\"0.40\"
-DXS_VERSION=\"0.40\" -fPIC -I/usr/lib/perl5/5.6.1/i386-linux/CORE dbdimp.c
Running Mkbootstrap for DBD::InterBase ()
chmod 644 InterBase.bs
rm -f blib/arch/auto/DBD/InterBase/InterBase.so
LD_RUN_PATH="/opt/interbase/lib:/lib" gcc -shared -L/usr/local/lib
InterBase.o dbdimp.o -o
blib/arch/auto/DBD/InterBase/InterBase.so -L/opt/interbase/lib -lgds -ldl
chmod 755 blib/arch/auto/DBD/InterBase/InterBase.so
cp InterBase.bs blib/arch/auto/DBD/InterBase/InterBase.bs
chmod 644 blib/arch/auto/DBD/InterBase/InterBase.bs
Manifying blib/man3/Bundle::DBD::InterBase.3pm
Manifying blib/man3/DBD::InterBase.3pm
Manifying blib/man3/DBD::InterBase::FAQ.3pm
>looking at the message "Driver has not implemented the disconnect_all
>method" there seems to something wrong with the DBI / DBI headers.
That's what I thought at first too, then MySQL and PostgreSQL. Maybe it's
a mess from the RPM and then redoing it from source. Now I've gone back to
5.6.1 and there are still way to many errors. I knew I should not have
messed around with putting RH on that server. (at least I have a backup
server:)
Thanks for your time Daniel.
New with 5.6.1 it says it can't load DBI.so but the file is there:
# make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/lib/perl5/5.6.1/i386-linux -I/usr/lib/perl5/5.6.1 -e 'use
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base............ok
t/10dsnlist.........ok
t/20createdrop......ok
t/30insertfetch.....ok
t/40alltypes........DBD::InterBase::db do failed: Invalid token
-Dynamic SQL Error
-SQL error code = -104
-Database SQL dialect 1 does not support reference to TIME datatype
DBD::InterBase::db prepare failed: Undefined name
-Dynamic SQL Error
-SQL error code = -204
-Table unknown
-BUILTIN
-At line 1, column 13.
Can't call method "execute" on an undefined value at t/40alltypes.t line 141.
t/40alltypes........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-27
Failed 26/27 tests, 3.70% okay
t/40bindparam.......ok
t/40blobs...........ok
t/40cursoron........ok
t/40cursor..........ok
t/40datetime........DBD::InterBase::db do failed: Invalid token
-Dynamic SQL Error
-SQL error code = -104
-Database SQL dialect 1 does not support reference to TIME datatype
DBD::InterBase::db prepare failed: Undefined name
-Dynamic SQL Error
-SQL error code = -204
-Table unknown
-BUILTIN
-At line 1, column 13.
Can't call method "execute" on an undefined value at t/40datetime.t line 121.
t/40datetime........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-14
Failed 13/14 tests, 7.14% okay
t/40doparam.........ok
t/40listfields......ok
t/40nulls...........ok
t/40numrows.........ok
t/41numeric.........DBD::InterBase::db do failed: The insert, update,
delete, ddl or authorization statement cannot
be executed because the transaction is inquiry only
-Dynamic SQL Error
-SQL error code = -817
-Metadata update statement is not allowed by the current database SQL dialect 1
DBD::InterBase::db prepare failed: Undefined name
-Dynamic SQL Error
-SQL error code = -204
-Table unknown
-BUILTIN
-At line 1, column 13.
Can't call method "execute" on an undefined value at t/41numeric.t line 107.
t/41numeric.........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-30
Failed 29/30 tests, 3.33% okay
t/50chopblanks......ok
t/50commit..........ok
t/60leaks...........FAILED before any test output arrived
t/61settx...........ok
t/70nestedoff.......ok
t/70nestedon........ok
t/ak-dbd............ok
t/dbdadmin..........ok
Failed Test Status Wstat Total Fail Failed List of Failed
--------------------------------------------------------------------------------
t/40alltypes.t 255 65280 27 26 96.30% 2-27
t/40datetime.t 255 65280 14 13 92.86% 2-14
t/41numeric.t 255 65280 30 29 96.67% 2-30
t/60leaks.t ?? ?? % ??
Failed 4/23 test scripts, 82.61% okay. 68/392 subtests failed, 82.65% okay.
make: *** [test_dynamic] Error 29
:(
|