Hi Bobby, the 'perl Makefile.PL' for DBD::DB2 says 'Using DB2 in "/usr"'
and 'Libraries: -L/usr/lib -ldb2'.  This is the first indication that
something is wrong since that's not a valid location for DB2.  Makefile.PL
tries to find DB2 by traversing PATH and looking for
<path>/../include/sqlcli.h.  This means somebody has copied the DB2 header
files (at least sqlcli.h) to /usr/include on your system.  That would be
fine if the DB2 libraries were also copied to /usr/lib which - apparently -
they weren't since you got the error 'cannot find -ldb2'.  It's not a good
idea at all to be copying these files around since they won't be updated
when DB2 is upgraded.

If for some reason you don't want to delete those include files, you can
specify the correct install location of DB2 by setting DB2PATH=<path to
sqllib> (or alternately DB2_HOME with the same effect) before running "perl
Makefile.PL".  This is covered in point 3 of the CAVEATS file.

Regards,
Robert


[EMAIL PROTECTED] on 26/04/2001 04:06:09 PM

Please respond to [EMAIL PROTECTED]

To:   [EMAIL PROTECTED]
cc:
Subject:  RH Linux 7 + Apache 1.3.19 + mod_perl 1.25






Please help my, I am really a wits end.  I have read all the README,
CEVEATS, and MAN files I could find, search the entire DBI and mod_perl
mail-list archives, and done dozens of google searches all to no avail.

I have been attempting to install DBI::DB2 on my RedHat Linux 7.0 system
with no success.  I am currently using Apache 1.3.19 w/ mod_perl 1.25.  DBI
1.14 seems to install but I get so many errors that I wonder if the problem
isn't coming from a bad DBI install.  Just in case, I tried the OPTIMIZE=
-00 but it didn't help.  This is a standard Linux, Apache install.  I have
DB2 PDE 7.0 fully installed on the machine (no errors or problems detected
with it.)

When I run perl Makefile.PL DBI i get no problems just the usual startup
screen. When i run make for DBI i get:

gcc -c  -fno-strict-aliasing -O2 -march=i386 -mcpu=i686
-DVERSION=\"1.14\" -
DXS_VERSION=\"1.14\" -fPIC -I/usr/lib/perl5/5.6.0/i386-linux/CORE -Wall
-Wno-com
ment -DDBI_NO_THREADS DBI.c
DBI.xs: In function `dbih_clearcom':
DBI.c:2770: warning: unused variable `Perl___notused'
DBI.c: In function `XS_DBD_____common_trace':
DBI.c:2790: warning: unused variable `Perl___notused'
DBI.c: In function `XS_DBD_____common_trace_msg':
DBI.c:2841: warning: unused variable `Perl___notused'
DBI.c: In function `XS_DBD_____common_rows':
DBI.c:2879: warning: unused variable `Perl___notused'
DBI.c: In function `XS_DBD___mem__common_DESTROY':
DBI.c:2895: warning: unused variable `Perl___notused'
DBI.c: In function `boot_DBI':
DBI.c:2915: warning: unused variable `Perl___notused'
etc... etc... etc... etc..

(there a alot more of these warings, If anyone needs to know them all I
will send them)

Running Mkbootstrap for DBI ()
chmod 644 DBI.bs
LD_RUN_PATH="" gcc -o blib/arch/auto/DBI/DBI.so  -shared -L/usr/local/lib
DBI.o

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 dbiproxy blib/script/dbiproxy
/usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0
-MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbiproxy
cp dbish blib/script/dbish
/usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0
-MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbish
Manifying blib/man3/DBI::ProxyServer.3pm
Manifying blib/man3/DBD::Proxy.3pm
Manifying blib/man3/DBI::Format.3pm
Manifying blib/man1/dbish.1
Manifying blib/man3/DBI::Shell.3pm
Manifying blib/man3/DBD::ADO.3pm
Manifying blib/man3/DBI.3pm
Manifying blib/man3/DBI::FAQ.3pm
Manifying blib/man3/Bundle::DBI.3pm
Manifying blib/man3/Win32::DBIODBC.3pm
Manifying blib/man1/dbiproxy.1
Manifying blib/man3/DBI::W32ODBC.3pm
Manifying blib/man3/DBI::DBD.3pm
Manifying blib/man3/DBD::Multiplex.3pm


The DBI make test looks like 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=0; runtests @ARGV;' t/*.t
t/basics............ok
t/dbidrv............ok
t/examp.............ok
t/meta..............ok
t/proxy.............skipped test on this platform
t/shell.............ok 1/3Warning [/etc/inputrc line 4]:
  Invalid value `on' for variable `meta-flag'.
  Choose from [On Off].
Warning [/etc/inputrc line 5]:
  Invalid value `on' for variable `input-meta'.
  Choose from [On Off].
Warning [/etc/inputrc line 6]:
  Invalid value `off' for variable `convert-meta'.
  Choose from [On Off].
Warning [/etc/inputrc line 7]:
  Invalid value `on' for variable `output-meta'.
  Choose from [On Off].
t/shell.............ok
t/subclass..........ok
All tests successful, 1 test skipped.
Files=7, Tests=179,  2 wallclock secs ( 0.82 cusr +  0.12 csys =  0.94 CPU)
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 test.pl
test.pl
DBI test application $Revision: 10.4 $
Using /usr/src/DBI-1.14/blib
Switch: DBI 1.14 by Tim Bunce, 1.14
Available Drivers: ADO, ExampleP, Multiplex, Proxy
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.04 usr +  0.00 sys =  0.04
CPU)

Testing handle creation speed...
5000 NullP statement handles cycled in 0.5 cpu+sys seconds (10204 per sec)

test.pl done


The DBD::DB2 perl Makefile.PL is:

Configuring DBD::DB2...
Remember to actually read the README and CAVEATS files!

Using DB2 in "/usr"
System: perl5.006 DBI1.14 linux porky.devel.redhat.com 2.2.5-22smp #1 smp
wed jun 2 09:11:51 edt 1999 i686 unknown  i386-linux dl_dlopen.xs
Compiler: gcc -O2 -march=i386 -mcpu=i686 -fno-strict-aliasing
Includes: -I"/usr/include"
-I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
Libraries: -L/usr/lib -ldb2

Writing Makefile for DBD::DB2::Constants
Writing Makefile for DBD::DB2


and the DBD::DB2 make is:

make[1]: Entering directory `/usr/src/DBD-DB2-0.75/Constants'
gcc -c -I"/usr/include" -fno-strict-aliasing -O2 -march=i386 -mcpu=i686
-DVERSION=\"0.20\" -DXS_VERSION=\"0.20\" -fPIC
-I/usr/lib/perl5/5.6.0/i386-linux/CORE  Constants.c
Running Mkbootstrap for DBD::DB2::Constants ()
chmod 644 Constants.bs
LD_RUN_PATH="" gcc -o ../blib/arch/auto/DBD/DB2/Constants/Constants.so
-shared
-L/usr/local/lib Constants.o
chmod 755 ../blib/arch/auto/DBD/DB2/Constants/Constants.so
cp Constants.bs ../blib/arch/auto/DBD/DB2/Constants/Constants.bs
chmod 644 ../blib/arch/auto/DBD/DB2/Constants/Constants.bs
make[1]: Leaving directory `/usr/src/DBD-DB2-0.75/Constants'
gcc -c -I"/usr/include"
-I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -fno-strict-aliasing
-O2 -march=i386 -mcpu=i686     -DVERSION=\"0.75\" -DXS_VERSION=\"0.75\"
-fPIC -I/usr/lib/perl5/5.6.0/i386-linux/CORE  DB2.c
gcc -c -I"/usr/include"
-I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -fno-strict-aliasing
-O2 -march=i386 -mcpu=i686     -DVERSION=\"0.75\" -DXS_VERSION=\"0.75\"
-fPIC -I/usr/lib/perl5/5.6.0/i386-linux/CORE  dbdimp.c
Running Mkbootstrap for DBD::DB2 ()
chmod 644 DB2.bs
LD_RUN_PATH="/usr/lib" gcc -o blib/arch/auto/DBD/DB2/DB2.so  -shared
-L/usr/local/lib DB2.o dbdimp.o     -L/usr/lib -ldb2
/usr/bin/ld: cannot find -ldb2
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/DB2/DB2.so] Error 1

Thanks in advance for any help or advice.  If there is already some
information on this let me know.
Bobby


Categories:




Reply via email to