(Fwd) DBI

----- Forwarded message from "Bepristis, Brian" <bbeprist@xxxxxxxxxxxxxxxxxxxxx> -----

From: "Bepristis, Brian" <bbeprist@xxxxxxxxxxxxxxxxxxxxx>
To: Tim.Bunce@xxxxxxxxx
Subject: DBI
Date: Thu, 19 May 2005 15:17:00 -0400

I have a system running FC3 Linux Perl 5.8.6 and DBI v. 1.48 Oracle 10G Client and I cannot get DBI to
work for the life of me please help here is what I am doing when installing.



perl Makefile.PL







*** Note:

The optional PlRPC-modules (RPC::PlServer etc) are not installed.

If you want to use the DBD::Proxy driver and DBI::ProxyServer

modules, then you'll need to install the RPC::PlServer, RPC::PlClient,

Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you.

You can install them any time after installing the DBI.

You do *not* need these modules for typical DBI usage.



Optional modules are available from any CPAN mirror, in particular

http://search.cpan.org/

http://www.perl.com/CPAN/modules/by-module

http://www.perl.org/CPAN/modules/by-module

ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module



Creating DBI::PurePerl test variant: t/zvpp_01basics.t

Creating DBI::PurePerl test variant: t/zvpp_02dbidrv.t

Creating DBI::PurePerl test variant: t/zvpp_03handle.t

Creating DBI::PurePerl test variant: t/zvpp_04mods.t

Creating DBI::PurePerl test variant: t/zvpp_05thrclone.t

Creating DBI::PurePerl test variant: t/zvpp_06attrs.t

Creating DBI::PurePerl test variant: t/zvpp_07kids.t

Creating DBI::PurePerl test variant: t/zvpp_08keeperr.t

Creating DBI::PurePerl test variant: t/zvpp_09trace.t

Creating DBI::PurePerl test variant: t/zvpp_10examp.t

Creating DBI::PurePerl test variant: t/zvpp_11fetch.t

Creating DBI::PurePerl test variant: t/zvpp_14utf8.t

Creating DBI::PurePerl test variant: t/zvpp_15array.t

Creating DBI::PurePerl test variant: t/zvpp_20meta.t

Creating DBI::PurePerl test variant: t/zvpp_30subclass.t

Creating DBI::PurePerl test variant: t/zvpp_40profile.t

Creating DBI::PurePerl test variant: t/zvpp_41prof_dump.t

Creating DBI::PurePerl test variant: t/zvpp_42prof_data.t

Creating DBI::PurePerl test variant: t/zvpp_50dbm.t

Creating DBI::PurePerl test variant: t/zvpp_60preparse.t

Creating DBI::PurePerl test variant: t/zvpp_80proxy.t



I see you're using perl 5.008006 on i686-linux, okay.

Remember to actually *read* the README file!

Use 'make' to build the software (dmake or nmake on Windows).

Then 'make test' to execute self tests.

Then 'make install' to install the DBI and then delete this working

directory before unpacking and building any DBD::* drivers.



Writing Makefile for DBI







Then I



make

cc -c -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-I/usr/include/gdbm -O2 -DVERSION=\"1.48\" -DXS_VERSION

=\"1.48\" -fpic "-I/usr/local/lib/perl5/5.8.6/i686-linux/CORE" -Wall -Wno-comment -DDBI_NO_THREADS
DBI.c

Running Mkbootstrap for DBI ()

chmod 644 DBI.bs

rm -f blib/arch/auto/DBI/DBI.so

LD_RUN_PATH="" cc -shared -L/usr/local/lib DBI.o -o blib/arch/auto/DBI/DBI.so

chmod 755 blib/arch/auto/DBI/DBI.so

cp DBI.bs blib/arch/auto/DBI/DBI.bs

chmod 644 blib/arch/auto/DBI/DBI.bs

cp dbiprof blib/script/dbiprof

/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/dbiprof

cp dbiproxy blib/script/dbiproxy

/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/dbiproxy

Manifying blib/man1/dbiprof.1

Manifying blib/man1/dbiproxy.1

Manifying blib/man3/DBI::FAQ.3

Manifying blib/man3/DBI::SQL::Nano.3

Manifying blib/man3/DBD::Proxy.3

Manifying blib/man3/DBI::Const::GetInfo::ANSI.3

Manifying blib/man3/DBD::DBM.3

Manifying blib/man3/DBI::Const::GetInfoReturn.3

Manifying blib/man3/DBI.3

Manifying blib/man3/DBD::Sponge.3

Manifying blib/man3/DBI::Const::GetInfoType.3

Manifying blib/man3/Roadmap.3

Manifying blib/man3/DBI::DBD::Metadata.3

Manifying blib/man3/DBI::W32ODBC.3

Manifying blib/man3/DBI::Const::GetInfo::ODBC.3

Manifying blib/man3/DBI::ProfileDumper::Apache.3

Manifying blib/man3/Bundle::DBI.3

Manifying blib/man3/DBI::Profile.3

Manifying blib/man3/DBD::File.3

Manifying blib/man3/DBI::ProfileDumper.3

Manifying blib/man3/DBI::ProxyServer.3

Manifying blib/man3/DBI::DBD.3

Manifying blib/man3/DynaLoader.3

Manifying blib/man3/Win32::DBIODBC.3

Manifying blib/man3/DBI::PurePerl.3

Manifying blib/man3/DBI::ProfileData.3



Then





make test

PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib',
'blib/arch')" t/*.t

t/01basics............ok

4/131 skipped: developer tests

t/02dbidrv............ok

t/03handle............ok

t/04mods..............ok

t/05thrclone..........skipped

all skipped: this linux perl 5.008006 not configured to support iThreads

t/06attrs.............ok

t/07kids..............ok

t/08keeperr...........ok

t/09trace.............ok

t/10examp.............ok

t/11fetch.............ok

t/14utf8..............ok

t/15array.............ok

t/20meta..............ok

t/30subclass..........ok

t/40profile...........ok

t/41prof_dump.........ok

t/42prof_data.........ok

t/50dbm...............ok

t/60preparse..........ok

t/80proxy.............skipped

all skipped: modules required for proxy are probably not installed (e.g., RPC/PlClient.pm)

t/pod.................skipped

all skipped: Test::Pod 1.00 required for testing POD

t/zvpp_01basics.......ok

4/131 skipped: developer tests

t/zvpp_02dbidrv.......ok

10/51 skipped: various reasons

t/zvpp_03handle.......ok

69/124 skipped: various reasons

t/zvpp_04mods.........ok

t/zvpp_05thrclone.....skipped

all skipped: this linux perl 5.008006 not configured to support iThreads

t/zvpp_06attrs........ok

7/137 skipped: various reasons

t/zvpp_07kids.........skipped

all skipped: $h->{Kids} attribute not supported for DBI::PurePerl

t/zvpp_08keeperr......ok

t/zvpp_09trace........ok

t/zvpp_10examp........ok

39/253 skipped: various reasons

t/zvpp_11fetch........ok 16/16Bad file descriptor at t/zvpp_11fetch.t line 3.

t/zvpp_11fetch........ok

t/zvpp_14utf8.........ok

t/zvpp_15array........ok

t/zvpp_20meta.........ok

t/zvpp_30subclass.....ok

t/zvpp_40profile......skipped

all skipped: profiling not supported for DBI::PurePerl

t/zvpp_41prof_dump....skipped

all skipped: profiling not supported for DBI::PurePerl

t/zvpp_42prof_data....skipped

all skipped: profiling not supported for DBI::PurePerl

t/zvpp_50dbm..........ok

t/zvpp_60preparse.....skipped

all skipped: preparse not supported for DBI::PurePerl

t/zvpp_80proxy........skipped

all skipped: modules required for proxy are probably not installed (e.g., RPC/PlClient.pm)

All tests successful, 10 tests and 133 subtests skipped.

Files=43, Tests=2114, 11 wallclock secs (10.47 cusr + 0.99 csys = 11.46 CPU)

PERL_DL_NONLAZY=1 /usr/local/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl

test.pl

DBI test application $Revision: 11.7 $

Switch: DBI 1.48 by Tim Bunce, 1.48

Available Drivers: DBM, ExampleP, File, Proxy, Sponge

dbi:ExampleP:: testing 5 sets of 20 connections:

Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Disconnecting...

Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Disconnecting...

Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Disconnecting...

Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Disconnecting...

Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Disconnecting...

Made 100 connections in 0 wallclock secs ( 0.02 usr + 0.01 sys = 0.03 CPU)



Testing handle creation speed...

11363 NullP sth/s perl 5.008006 i686-linux (gcc 3.4.2 -O2)



test.pl done







Then





make install

Files found in blib/arch: installing files in blib/lib into architecture dependent library tree

Writing /usr/local/lib/perl5/site_perl/5.8.6/i686-linux/auto/DBI/.packlist

Appending installation info to /usr/local/lib/perl5/5.8.6/i686-linux/perllocal.pod





When I run a application this is what I get





./test_db_conn.pl

Can't locate object method "bootstrap" via package "DBI" at
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm line 247.

BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm line
254.

Compilation failed in require at ./test_db_conn.pl line 8.

BEGIN failed--compilation aborted at ./test_db_conn.pl line 8.









Any help will be much appreciated I have been researching this for almost 3 days and cannot find the
right answer.







Brian Bepristis



----- End forwarded message -----
.

Relevant Pages