Re: Problem Compiling under Solaris using DBI and DBD::DB2

Replies are listed 'Best First'.
Re^2: Problem Compiling under Solaris using DBI and DBD::DB2 by palaxos (Initiate) on Jan 13, 2012 at 20:55 UTC
Thanks for your answer. I don't have all the commands i did right here, but i kept what i did for DBD::DB2. STEP 1: root@whms17368 > /usr/perl5/5.8.4/bin/perlgcc Makefile.PL Configuring DBD::DB2... Remember to actually read the README and CAVEATS files! Using DB2 in "/home/db2inst1" System: perl5.008004 DBI1.616 sunos localhost 5.10 sun4u sparc SUNW,Ul +tra-2 sun4-solaris-64int dl_dlopen.xs Compiler: gcc -O2 -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFF +SET_BITS=64 -D_TS_ERRNO Includes: -I"/home/db2inst1/include" -I"/usr/perl5/site_perl/5.8.4/su +n4-solaris-64int/auto/DBI" -I"/usr/perl5/5.8.4/lib/sun4-solaris-64int +/auto/DBI" -I"/usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int/auto/DB +I" -I"/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI" Libraries: -L/home/db2inst1/lib -ldb2 Note (probably harmless): No library found for -ldb2 Writing Makefile for DBD::DB2::Constants Writing Makefile for DBD::DB2 STEP2: root@whms17368 > make gcc -c -I"/home/db2inst1/include" -D_LARGEFILE_SOURCE -D_FILE_OFFSET +_BITS=64 -D_TS_ERRNO -O2 -fno-strict-aliasing -DVERSION=\"1.82\" +-DXS_VERSION=\"1.82\" -fPIC "-I/usr/perl5/5.8.4/lib/sun4-solaris-64in +t/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="" gcc -G Constants.o -o ../blib/arch/auto/DBD/DB2/Const +ants/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 gcc -c -I"/home/db2inst1/include" -I"/usr/perl5/site_perl/5.8.4/sun4- +solaris-64int/auto/DBI" -I"/usr/perl5/5.8.4/lib/sun4-solaris-64int/au +to/DBI" -I"/usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int/auto/DBI" +-I"/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI" -D_LARGEF +ILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_TS_ERRNO -O2 -fno-strict-aliasin +g -DVERSION=\"1.82\" -DXS_VERSION=\"1.82\" -fPIC "-I/usr/perl5/5. +8.4/lib/sun4-solaris-64int/CORE" -DDB2_CACHE_FIX DB2.c gcc -c -I"/home/db2inst1/include" -I"/usr/perl5/site_perl/5.8.4/sun4- +solaris-64int/auto/DBI" -I"/usr/perl5/5.8.4/lib/sun4-solaris-64int/au +to/DBI" -I"/usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int/auto/DBI" +-I"/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI" -D_LARGEF +ILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_TS_ERRNO -O2 -fno-strict-aliasin +g -DVERSION=\"1.82\" -DXS_VERSION=\"1.82\" -fPIC "-I/usr/perl5/5. +8.4/lib/sun4-solaris-64int/CORE" -DDB2_CACHE_FIX dbdimp.c dbdimp.c: In function `dbd_db_connect': dbdimp.c:314: warning: cast to pointer from integer of different size dbdimp.c:325: warning: cast to pointer from integer of different size dbdimp.c:336: warning: cast to pointer from integer of different size dbdimp.c: In function `db2_db_STORE_attrib': dbdimp.c:897: warning: cast to pointer from integer of different size dbdimp.c: In function `dbd_conn_opt': dbdimp.c:2482: warning: cast to pointer from integer of different size dbdimp.c: In function `db2_st_STORE_attrib': dbdimp.c:3209: warning: cast to pointer from integer of different size Running Mkbootstrap for DBD::DB2 () chmod 644 DB2.bs rm -f blib/arch/auto/DBD/DB2/DB2.so LD_RUN_PATH="" gcc -G DB2.o dbdimp.o -o blib/arch/auto/DBD/DB2/DB2. +so 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/Bundle::DBD::DB2.3 Manifying blib/man3/DBD::DB2.3 root@whms17368 > STEP 3: root@whms17368 > make install Files found in blib/arch: installing files in blib/lib into architectu +re dependent library tree Writing /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/DB2/.pa +cklist Appending installation info to /usr/perl5/5.8.4/lib/sun4-solaris-64int +/perllocal.pod STEP 4: root@whms17368 > cd /export/home/ccmadm/CCM root@whms17368 > perl CCM.pl 2012/01/13 11:56:09 start test! ld.so.1: perl: fatal: relocation error: file /usr/perl5/site_perl/5.8. +4/sun4-solaris-64int/auto/DBD/DB2/DB2.so: symbol SQLAllocHandle: refe +renced symbol not found Killed [download]	[reply] [d/l]
Re^3: Problem Compiling under Solaris using DBI and DBD::DB2 by Eliya (Vicar) on Jan 13, 2012 at 21:54 UTC
`Note (probably harmless): No library found for -ldb2` [download] This is most likely the problem (note that although it says "probably harmless", it definitely isn't, as this is the essential library here). When you see this message, the respective link instruction is removed from the list, which means the Perl binding `.../DBD/DB2/DB2.so` won't be linked against the library — resulting in the "symbol not found" error later at dynamic link time. In case you're sure you do have the right library in the specified place (`/home/db2inst1/lib`), the pragmatic way to resolve the issue (instead of trying to figure out why the above MakeMaker check failed) would be to manually rerun the final link command with the appropriate link instruction added, i.e. (from within the build directory) `gcc -G DB2.o dbdimp.o -o blib/arch/auto/DBD/DB2/DB2.so -L/home/db2 +inst1/lib -ldb2 ^^^^^^^^^^ +^^^^^^^^^^^^^^^` [download] (if you get an error, you don't have the right library) Then run `make test && make install`, as usual.	[reply] [d/l] [select]
Re^4: Problem Compiling under Solaris using DBI and DBD::DB2 by Anonymous Monk on Jan 14, 2012 at 06:23 UTC
See Fixing MakeMaker and :nosearch in ExtUtils::Liblist	[reply]
Re^5: Problem Compiling under Solaris using DBI and DBD::DB2 by cavac (Prior) on Jan 14, 2012 at 08:17 UTC
Re^6: Problem Compiling under Solaris using DBI and DBD::DB2 by Anonymous Monk on Jan 14, 2012 at 08:25 UTC
Some notes below your chosen depth have not been shown here
Re^4: Problem Compiling under Solaris using DBI and DBD::DB2 by palaxos (Initiate) on Jan 18, 2012 at 14:21 UTC
Hi, Thanks again for your quick reply! I ran that gcc line and I indeed got an error. `ld: fatal: file /home/db2inst1/sqllib/lib/libdb2.so: wrong ELF class: +ELFCLASS64` [download] After researching that a bit, i beleive i'm using the wrong version of the DB2 client (64 bits). I checked my perl version and it looks 32 bits, so i'll install DB2 (32 bits) and then i'll give you all some feedback on how it went.	[reply] [d/l]