> > Hello, it�s me again, with the same problem...
> > I was looking into my disk, and into /usr/include i have a lot of
symlinks
> > to sql*** that point to /usr/IBMdb2/V7.1/include...
> > I am the only one who uses this machine, and i did not do that, so i
> suppose
> > when i installed db2 that links were created.
> > I ran make realclean, and then 'perl Makefile.pl' , 'make' & 'make test'
,
> > again with the error about undefined symbol.
> > I send you 3 files: step1.txt (the output of perl Makefile.PL) ,
step2.txt
> > (the output of make) & step3.txt (the out of make test)
> > I verified that in my environment i have DB2_HOME=/usr/IBMdb2
> > I�m running all these scripts as root, under bash
> > Thanks again for your help
> >
> > Ricardo
> > ----- Original Message -----
> > From: <[EMAIL PROTECTED]>
> > To: "rmd" <[EMAIL PROTECTED]>
> > Sent: Wednesday, May 02, 2001 5:31 PM
> > Subject: Re: DBD::DB2 installation problem
> >
> >
> >
> > The DBD::DB2 build failed, that's why you can't run install and test.
The
> > build failed is because Makefile.PL thinks DB2 is installed in /usr
(this
> > of course isn't possible). Someone must have manually copied DB2 header
> > files (sqlcli.h) to /usr/include on your system. You should not do
this.
> > In any case, you can explitly set DB2PATH (or DB2_HOME) to point to the
> DB2
> > install (as explained in the CAVEATS file), then build DBD::DB2 from
> > scratch again (make sure you run 'make realclean' first or untar the
> driver
> > from scratch).
> >
> > Regards,
> > Robert
> >
> > "rmd" <[EMAIL PROTECTED]> on 02/05/2001 04:26:48 PM
> >
> > To: DB2PERL/Toronto/IBM@IBMCA
> > cc:
> > Subject: Re: DBD::DB2 installation problem
> >
> >
> >
> > Thank you very much for your help.
> > Well, I think my DB2 environment is OK, I can connect to my database
from
> > the command line and from an application written in Java , running from
> the
> > web.
> >
> > Here I send you what you asked:
> >
>
> --------------------------------------------------------------------------
> --
> >
> > ----
> > command: perl -v
> > This is perl, v5.6.1 built for i686-linux
> > Copyright 1987-2001, Larry Wall
> > Perl may be copied only under the terms of either the Artistic License
or
> > the
> > GNU General Public License, which may be found in the Perl 5 source kit.
> > Complete documentation for Perl, including FAQ lists, should be found on
> > this system using `man perl' or `perldoc perl'. If you have access to
the
> > Internet, point your browser at http://www.perl.com/, the Perl Home
Page.
>
> --------------------------------------------------------------------------
> --
> >
> > ----
> >
> > command: perl -mDBI -e'print "DBI Version=$DBI::VERSION\n"'
> > DBI Version=1.15
>
> --------------------------------------------------------------------------
> --
> >
> > ----
> >
> > command: perl -mDBD::DB2 -e'print "DBD::DB2
Version=$DBD::DB2::VERSION\n"'
> > Can't locate DBD/DB2.pm in @INC (@INC contains:
> > /usr/local/lib/perl5/5.6.1/i686-linux /usr/local/lib/perl5/5.6.1
> > /usr/local/lib/perl5/site_perl/5.6.1/i686-linux
> > /usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .).
> > BEGIN failed--compilation aborted.
> >
> > (I think this error is because DBD::DB2 is not fully installed, when i
got
> > that error on 'make test' i did not ran 'make install'...)
>
> --------------------------------------------------------------------------
> --
> >
> > ----
> >
> > command: db2level
> > DB21085I Instance "db2inst1" uses DB2 code release "SQL07010" with
level
> > identifier "02010105" and informational tokens "DB2 v7.1.0", "n000510"
and
> > "".
>
> --------------------------------------------------------------------------
> --
> >
> > ----
> > This is the output from perl Makefile.PL
> >
> >
> > Configuring DBD::DB2...
> > Remember to actually read the README and CAVEATS files!
> >
> > Using DB2 in "/usr"
> > System: perl5.006001 DBI1.15 linux linux.altec.com.ar 2.2.16-22 #1 tue
aug
> > 22 16:49:06 edt 2000 i686 unknown i686-linux dl_dlopen.xs
> > Compiler:
> > cc -O2 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
> > Includes: -I"/usr/include"
> > -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux
> > /auto/DBI
> > Libraries: -L/usr/lib -ldb2
> >
> > Writing Makefile for DBD::DB2::Constants
> > Writing Makefile for DBD::DB2
> >
>
> --------------------------------------------------------------------------
> --
> >
> > ----
> > This is the output from make (after a long, long while...)
> > make[1]: Entering directory `/instalar/DBD-DB2-0.75/Constants'
> > cc -c -I"/usr/include" -fno-strict-aliasing -D_LARGEFILE_SOURCE
> > -D_FILE_OFFS
> > ET_BITS=64 -O2 -DVERSION=\"0.20\" -DXS_VERSION=\"0.20\" -fpic
> > -I/usr/local
> > /lib/perl5/5.6.1/i686-linux/CORE Constants.c
> > Running Mkbootstrap for DBD::DB2::Constants ()
> > chmod 644 Constants.bs
> > rm -f ../blib/arch/auto/DBD/DB2/Constants/Constants.so
> > LD_RUN_PATH="" cc -shared -L/usr/local/lib Constants.o -o
> > ../blib/arch/auto/DBD/DB2/Constants/Constants.so
> > 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 `/instalar/DBD-DB2-0.75/Constants'
> > cc -c -I"/usr/include"
> > -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/aut
> >
o/DBI -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2
> > -DVERSION=\"0.75\" -DXS_VERSION=\"0.75\" -fpic
> > -I/usr/local/lib/perl5/5.6.1/
> > i686-linux/CORE DB2.c
> > cc -c -I"/usr/include"
> > -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/aut
> >
o/DBI -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2
> > -DVERSION=\"0.75\" -DXS_VERSION=\"0.75\" -fpic
> > -I/usr/local/lib/perl5/5.6.1/
> > i686-linux/CORE dbdimp.c
> > Running Mkbootstrap for DBD::DB2 ()
> > chmod 644 DB2.bs
> > rm -f blib/arch/auto/DBD/DB2/DB2.so
> > LD_RUN_PATH="/usr/lib" cc -shared -L/usr/local/lib DB2.o dbdimp.o -o
> > blib/arch/auto/DBD/DB2/DB2.so -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
> >
> > grrrr... now, it cannot find libdb2.a, i suppose... I have a libdb2u.a
on
> > my /usr/lib directory
> > and if I try to cp it to libdb2.a i obtain the error i describe on my
> > previous mail.
> > I attach the makefile generated by perl Makefile.PL
> >
> > Thanx again
> >
> > ----- Original Message -----
> > From: <[EMAIL PROTECTED]>
> > To: "rmd" <[EMAIL PROTECTED]>
> > Sent: Wednesday, May 02, 2001 3:01 PM
> > Subject: Re: DBD::DB2 installation problem
> >
> >
> > Hmm, I've never seen that before. Are you sure your DB2 client
> environment
> > is setup properly? i.e. did you run sqllib/db2profile? Can you connect
> to
> > a database from the command line? If this is all okay, please send me
the
> > complete output for each step: 'perl Makefile.PL', 'make' & 'make
> install'.
> > Also, run the following commands and sent me the output:
> >
> > perl -v
> > perl -mDBI -e 'print "DBI Version = $DBI::VERSION\n"'
> > perl -mDBD::DB2 -e 'print "DBD::DB2 Version =
$DBD::DB2::VERSION\n"'
> > db2level
> >
> > Regards,
> > Robert
> >
> >
> > "rmd" <[EMAIL PROTECTED]> on 02/05/2001 02:13:45 PM
> >
> > Please respond to "rmd" <[EMAIL PROTECTED]>
> >
> > To: <[EMAIL PROTECTED]>
> > cc:
> > Subject: DBD::DB2 installation problem
> >
> >
> >
> > �ve tried to install DBD:DB2 using CPAN or compiling it directly via
perl
> > Makefile.PL, then make test and i get always this error:
> >
> > [root@linux DBD-DB2-0.75]# make test
> > make[1]: Entering directory '/instalar/DBD-DB2-0.75/Constants'
> > make[1]: Leaving directory '/instalar/DBD-DB2-0.75/Constants'
> > PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib
> > -I/usr/local/lib/perl5/5.6.1/i686-linux -I/usr/local/lib/perl5/5.6.1 -e
> > 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;'
> > t/*.t
> > t/base..............install_driver(DB2) failed: Can't load
> > 'blib/arch/auto/DBD/DB2/DB2.so' for module DBD::DB2: undefined symbol:
> > sqluirmt__FP7sqlcharP5sqldaT1P5sqlca at
> > /usr/local/lib/perl5/5.6.1/i686-linux/DynaLoader.pm line 206.
> > at (eval 1) line 3
> > Compilation failed in require at (eval 1) line 3.
> > Perhaps a required shared library or dll isn't installed where expected
> > at t/base.t line 16
> > t/base..............dubious
> > Test returned status 255 (wstat 65280, 0xff00)
> > DIED. FAILED tests 4-5
> > Failed 2/5 tests, 60.00% okay
> > t/main..............ok
> > Failed Test Status Wstat Total Fail Failed List of Failed
>
> --------------------------------------------------------------------------
> --
> >
> > ----t/base.t
> >
> > 255 65280 5 2 40.00% 4-5
> > Failed 1/2 test scripts, 50.00% okay. 2/6 subtests failed, 66.67% okay.
> > make: *** [test_dynamic] Error 29
> >
> > My system is a RedHat v7 with DB2 Personal Edition v7.1
> >
> > Thanx
> >
> >
> >
> > (See attached file: Makefile)
> >
> >
>
make[1]: Entering directory `/instalar/DBD-DB2-0.75/Constants'
make[1]: Leaving directory `/instalar/DBD-DB2-0.75/Constants'
PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/lib/perl5/5.6.1/i686-linux -I/usr/local/lib/perl5/5.6.1 -e 'use
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base..............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/main..............ok
install_driver(DB2) failed: Can't load 'blib/arch/auto/DBD/DB2/DB2.so' for module
DBD::DB2: undefined symbol: sqluirmt__FP7sqlcharP5sqldaT1P5sqlca at
/usr/local/lib/perl5/5.6.1/i686-linux/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/base.t line 16
Failed 1/2 test scripts, 50.00% okay. 2/6 subtests failed, 66.67% okay.
make: *** [test_dynamic] Error 29
Failed Test Status Wstat Total Fail Failed List of Failed
--------------------------------------------------------------------------------
t/base.t 255 65280 5 2 40.00% 4-5
cp DB2.pod blib/lib/DBD/DB2.pod
cp lib/Bundle/DBD/DB2.pm blib/lib/Bundle/DBD/DB2.pm
cp lib/Bundle/DBD/err.txt blib/lib/Bundle/DBD/err.txt
cp DB2.pm blib/lib/DBD/DB2.pm
make[1]: Entering directory `/instalar/DBD-DB2-0.75/Constants'
cp Constants.pm ../blib/lib/DBD/DB2/Constants.pm
AutoSplitting ../blib/lib/DBD/DB2/Constants.pm (../blib/lib/auto/DBD/DB2/Constants)
/usr/local/bin/perl -I/usr/local/lib/perl5/5.6.1/i686-linux
-I/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.6.1/ExtUtils/typemap Constants.xs > Constants.xsc && mv
Constants.xsc Constants.c
cc -c -I"/usr/IBMdb2/include" -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"0.20\" -DXS_VERSION=\"0.20\" -fpic
-I/usr/local/lib/perl5/5.6.1/i686-linux/CORE Constants.c
Running Mkbootstrap for DBD::DB2::Constants ()
chmod 644 Constants.bs
rm -f ../blib/arch/auto/DBD/DB2/Constants/Constants.so
LD_RUN_PATH="" cc -shared -L/usr/local/lib Constants.o -o
../blib/arch/auto/DBD/DB2/Constants/Constants.so
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 `/instalar/DBD-DB2-0.75/Constants'
/usr/local/bin/perl -I/usr/local/lib/perl5/5.6.1/i686-linux
-I/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.6.1/ExtUtils/typemap DB2.xs > DB2.xsc && mv DB2.xsc DB2.c
cc -c -I"/usr/IBMdb2/include"
-I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -fno-strict-aliasing
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"0.75\"
-DXS_VERSION=\"0.75\" -fpic -I/usr/local/lib/perl5/5.6.1/i686-linux/CORE DB2.c
cc -c -I"/usr/IBMdb2/include"
-I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -fno-strict-aliasing
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"0.75\"
-DXS_VERSION=\"0.75\" -fpic -I/usr/local/lib/perl5/5.6.1/i686-linux/CORE dbdimp.c
Running Mkbootstrap for DBD::DB2 ()
chmod 644 DB2.bs
rm -f blib/arch/auto/DBD/DB2/DB2.so
LD_RUN_PATH="/usr/lib" cc -shared -L/usr/local/lib DB2.o dbdimp.o -o
blib/arch/auto/DBD/DB2/DB2.so -ldb2
chmod 755 blib/arch/auto/DBD/DB2/DB2.so
cp DB2.bs blib/arch/auto/DBD/DB2/DB2.bs
chmod 644 blib/arch/auto/DBD/DB2/DB2.bs
Manifying blib/man3/DBD::DB2.3
Manifying blib/man3/Bundle::DBD::DB2.3
Configuring DBD::DB2...
Remember to actually read the README and CAVEATS files!
Using DB2 in "/usr/IBMdb2"
System: perl5.006001 DBI1.15 linux linux.altec.com.ar 2.2.16-22 #1 tue aug 22 16:49:06
edt 2000 i686 unknown i686-linux dl_dlopen.xs
Compiler: cc -O2 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Includes: -I"/usr/IBMdb2/include"
-I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
Libraries: -L/usr/IBMdb2/lib -ldb2
Checking if your kit is complete...
Looks good
Checking if your kit is complete...
Looks good
Writing Makefile for DBD::DB2::Constants
Writing Makefile for DBD::DB2
