Skip Menu |

This queue is for tickets about the DBD-DB2 CPAN distribution.

Report information
The Basics
Id: 46650
Status: resolved
Priority: 0/
Queue: DBD-DB2

People
Owner: opendev [...] us.ibm.com
Requestors: info [...] peter.st
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: DBD-DB2-1.71 - dbdimp.c does not compile on Ubuntu 9.04
Date: Wed, 03 Jun 2009 19:08:48 +0200
To: bug-DBD-DB2 [...] rt.cpan.org
From: Peter Stoehr <info [...] peter.st>
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I found following problem according to dbdimp.c ### perl Makefile.PL ### Configuring DBD::DB2... Remember to actually read the README and CAVEATS files! Using DB2 in "/opt/IBM/db2/V8.1" System: perl5.010000 DBI1.607 linux palmer 2.6.24-19-server #1 smp sat jul 12 00:40:01 utc 2008 i686 gnulinux i486-linux-gnu-thread-multi dl_dlopen.xs Compiler: cc -O2 -g -D_REENTRANT -D_GNU_SOURCE -DDEBIAN - -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE - -D_FILE_OFFSET_BITS=64 Includes: -I"/opt/IBM/db2/V8.1/include" - -I"/usr/local/lib/perl/5.10.0/auto/DBI" -I"/usr/lib/perl5/auto/DBI" Libraries: -L/opt/IBM/db2/V8.1/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 ### make ### cp DB2.pm blib/lib/DBD/DB2.pm cp lib/Bundle/DBD/DB2.pm blib/lib/Bundle/DBD/DB2.pm cp DB2.pod blib/lib/DBD/DB2.pod make[1]: Entering directory `/tmp/DBD-DB2-1.71/Constants' cp Constants.pm ../blib/lib/DBD/DB2/Constants.pm AutoSplitting ../blib/lib/DBD/DB2/Constants.pm (../blib/lib/auto/DBD/DB2/Constants) /usr/bin/perl /usr/share/perl/5.10.0/ExtUtils/xsubpp -typemap /usr/share/perl/5.10/ExtUtils/typemap Constants.xs > Constants.xsc && mv Constants.xsc Constants.c cc -c -I"/opt/IBM/db2/V8.1/include" -D_REENTRANT -D_GNU_SOURCE -DDEBIAN - -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE - -D_FILE_OFFSET_BITS=64 -O2 -g -DVERSION=\"1.71\" -DXS_VERSION=\"1.71\" - -fPIC "-I/usr/lib/perl/5.10/CORE" Constants.c Running Mkbootstrap for DBD::DB2::Constants () chmod 644 Constants.bs rm -f ../blib/arch/auto/DBD/DB2/Constants/Constants.so cc -shared -O2 -g -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 `/tmp/DBD-DB2-1.71/Constants' /usr/bin/perl /usr/share/perl/5.10/ExtUtils/xsubpp -typemap /usr/share/perl/5.10/ExtUtils/typemap DB2.xs > DB2.xsc && mv DB2.xsc DB2.c cc -c -I"/opt/IBM/db2/V8.1/include" - -I"/usr/local/lib/perl/5.10.0/auto/DBI" -I"/usr/lib/perl5/auto/DBI" - -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing -pipe - -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -DVERSION=\"1.71\" -DXS_VERSION=\"1.71\" -fPIC "-I/usr/lib/perl/5.10/CORE" -DDB2_CACHE_FIX DB2.c cc -c -I"/opt/IBM/db2/V8.1/include" - -I"/usr/local/lib/perl/5.10.0/auto/DBI" -I"/usr/lib/perl5/auto/DBI" - -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing -pipe - -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -DVERSION=\"1.71\" -DXS_VERSION=\"1.71\" -fPIC "-I/usr/lib/perl/5.10/CORE" -DDB2_CACHE_FIX dbdimp.c dbdimp.c: In function ‘fbh_dump’: dbdimp.c:130: warning: too few arguments for format dbdimp.c:132: warning: format ‘%d’ expects type ‘int’, but argument 5 has type ‘SQLINTEGER’ dbdimp.c:132: warning: format ‘%d’ expects type ‘int’, but argument 6 has type ‘SQLINTEGER’ dbdimp.c: In function ‘dbd_db_connect’: dbdimp.c:324: error: ‘SQL_ATTR_INFO_PROGRAMNAME’ undeclared (first use in this function) dbdimp.c:324: error: (Each undeclared identifier is reported only once dbdimp.c:324: error: for each function it appears in.) dbdimp.c: In function ‘getConnectAttr’: dbdimp.c:770: error: ‘SQL_ATTR_INFO_PROGRAMNAME’ undeclared (first use in this function) dbdimp.c: In function ‘db2_db_STORE_attrib’: dbdimp.c:835: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘SQLPOINTER’ dbdimp.c:849: error: ‘SQL_ATTR_INFO_PROGRAMNAME’ undeclared (first use in this function) dbdimp.c: In function ‘db2_db_FETCH_attrib’: dbdimp.c:953: warning: format not a string literal and no format arguments dbdimp.c:994: error: ‘SQL_ATTR_INFO_PROGRAMNAME’ undeclared (first use in this function) dbdimp.c: In function ‘db2_describe’: dbdimp.c:1097: warning: format not a string literal and no format arguments dbdimp.c:1099: warning: format not a string literal and no format arguments dbdimp.c:1105: warning: format not a string literal and no format arguments dbdimp.c:1110: warning: format not a string literal and no format arguments dbdimp.c:1203: error: ‘SQL_DATABASE_CODEPAGE’ undeclared (first use in this function) dbdimp.c:1217: warning: format not a string literal and no format arguments dbdimp.c:1218: warning: format not a string literal and no format arguments dbdimp.c:1235: error: ‘SQL_APPLICATION_CODEPAGE’ undeclared (first use in this function) dbdimp.c:1250: warning: format not a string literal and no format arguments dbdimp.c:1251: warning: format not a string literal and no format arguments dbdimp.c:1294: warning: format not a string literal and no format arguments dbdimp.c:1306: warning: too few arguments for format dbdimp.c: In function ‘dbd_preparse’: dbdimp.c:1443: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘long int’ dbdimp.c: In function ‘db2_db_get_info’: dbdimp.c:1839: warning: format not a string literal and no format arguments dbdimp.c:1840: warning: format not a string literal and no format arguments dbdimp.c:1899: warning: format not a string literal and no format arguments dbdimp.c:1900: warning: format not a string literal and no format arguments dbdimp.c:1960: warning: format not a string literal and no format arguments dbdimp.c:1961: warning: format not a string literal and no format arguments dbdimp.c: In function ‘db2_st_prepare’: dbdimp.c:2109: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘SQLHSTMT’ dbdimp.c: In function ‘db2_bind_ph’: dbdimp.c:2297: warning: format not a string literal and no format arguments dbdimp.c:2299: warning: format not a string literal and no format arguments dbdimp.c:2310: warning: format not a string literal and no format arguments dbdimp.c:2312: warning: format not a string literal and no format arguments dbdimp.c:2344: warning: format ‘%d’ expects type ‘int’, but argument 6 has type ‘IV’ dbdimp.c:2344: warning: format ‘%d’ expects type ‘int’, but argument 9 has type ‘IV’ dbdimp.c: In function ‘db2_st_fetch’: dbdimp.c:2599: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘SQLINTEGER’ dbdimp.c:2643: warning: format not a string literal and no format arguments dbdimp.c:2644: warning: format not a string literal and no format arguments dbdimp.c:2668: warning: format ‘%d’ expects type ‘int’, but argument 4 has type ‘SQLINTEGER’ dbdimp.c:2668: warning: format ‘%d’ expects type ‘int’, but argument 5 has type ‘long int’ dbdimp.c:2668: warning: format ‘%d’ expects type ‘int’, but argument 6 has type ‘SQLINTEGER’ dbdimp.c:2671: warning: format not a string literal and no format arguments dbdimp.c:2673: warning: format not a string literal and no format arguments dbdimp.c:2695: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘SQLINTEGER’ dbdimp.c: In function ‘db2_st_FETCH_attrib’: dbdimp.c:3170: warning: format not a string literal and no format arguments make: *** [dbdimp.o] Error 1 ### gcc -v ### Using built-in specs. Target: i486-linux-gnu Configured with: ../src/configure -v --with-pkgversion='Ubuntu 4.3.3-5ubuntu4' --with-bugurl=file:///usr/share/doc/gcc-4.3/README.Bugs - --enable-languages=c,c++,fortran,objc,obj-c++ --prefix=/usr - --enable-shared --with-system-zlib --libexecdir=/usr/lib - --without-included-gettext --enable-threads=posix --enable-nls - --with-gxx-include-dir=/usr/include/c++/4.3 --program-suffix=-4.3 - --enable-clocale=gnu --enable-libstdcxx-debug --enable-objc-gc - --enable-mpfr --enable-targets=all --with-tune=generic - --enable-checking=release --build=i486-linux-gnu --host=i486-linux-gnu - --target=i486-linux-gnu Thread model: posix gcc version 4.3.3 (Ubuntu 4.3.3-5ubuntu4) ### perl -V ### Summary of my perl5 (revision 5 version 10 subversion 0) configuration: Platform: osname=linux, osvers=2.6.24-19-server, archname=i486-linux-gnu-thread-multi uname='linux palmer 2.6.24-19-server #1 smp sat jul 12 00:40:01 utc 2008 i686 gnulinux ' config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN - -Dcccdlflags=-fPIC -Darchname=i486-linux-gnu -Dprefix=/usr - -Dprivlib=/usr/share/perl/5.10 -Darchlib=/usr/lib/perl/5.10 - -Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5 - -Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local - -Dsitelib=/usr/local/share/perl/5.10.0 - -Dsitearch=/usr/local/lib/perl/5.10.0 -Dman1dir=/usr/share/man/man1 - -Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1 - -Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl - -Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio - -Uusenm -DDEBUGGING=-g -Doptimize=-O2 -Duseshrplib - -Dlibperl=libperl.so.5.10.0 -Dd_dosuid -des' hint=recommended, useposix=true, d_sigaction=define useithreads=define, usemultiplicity=define useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef use64bitint=undef, use64bitall=undef, uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN - -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE - -D_FILE_OFFSET_BITS=64', optimize='-O2 -g', cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing - -pipe -I/usr/local/include' ccversion='', gccversion='4.3.3 20081217 (prerelease)', gccosandvers='' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=4, prototype=define Linker and Libraries: ld='cc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib /usr/lib64 libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt perllibs=-ldl -lm -lpthread -lc -lcrypt libc=/lib/libc-2.9.so, so=so, useshrplib=true, libperl=libperl.so.5.10.0 gnulibc_version='2.9' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E' cccdlflags='-fPIC', lddlflags='-shared -O2 -g -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP USE_ITHREADS USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API Built under linux Compiled at Jan 5 2009 19:47:06 @INC: /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . ### uname -srvm ### Linux 2.6.28-11-generic #42-Ubuntu SMP Fri Apr 17 01:57:59 UTC 2009 i686 ### db2level ### DB21085I Instance "db2sship" uses "32" bits and DB2 code release "SQL08013" with level identifier "02040106". Informational tokens are "DB2 v8.1.0.24", "s030728", "MI00054", and FixPak "3". Product is installed at "/opt/IBM/db2/V8.1". <snip> FYI Peter -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkomrhoACgkQvnDnNEbp4LnJiQCePpVu7v4jrOGVYL48KKdNI1bP FPUAniiJGva3iqk2s9UkOMB3NQPDPM1y =JR5P -----END PGP SIGNATURE-----
From: praveendrl [...] in.ibm.com
Hi Peter, Seems like the include file sqlcli1.h is not present in the include directory /opt/IBM/db2/V8.1/include. The constant SQL_ATTR_xxxx [the ones being complained] are defined in sqlcli1.h and seems like you are missing this file. Could you re-check the file sqlcli1.h in the mentioned directory and then try installing. Let me know how it goes. Thanks Praveen
RT-Send-CC: opendev [...] us.ibm.com
Hi Peter, As Praveen correctly mentioned that the variables on which you are getting the errors are DB2 Constants that were added on version 9.1 and above. We completely support our drivers starting version 9.1 and above. I would thereby request you to install a licensed copy of the latest DB2 that you have(if v95 still better). If you do not have a copy of the same, kindly let us know and we would help you to initiate a dialogue with the DB2 guys to get the latest release. -- Thanks Tarun Pasrija IBM OpenSource Application Development Team India Software Labs, Bangalore (India)
Subject: Re: [rt.cpan.org #46650] DBD-DB2-1.71 - dbdimp.c does not compile on Ubuntu 9.04
Date: Fri, 05 Jun 2009 17:13:07 +0200
To: bug-DBD-DB2 [...] rt.cpan.org
From: Peter Stoehr <info [...] peter.st>
Hello, I've checked my DB2 installation and have found sqlcli1.h in the include path. I found a "newer" installation of DB2 V8.1 with fixpak 11. With this version, DBD::DB2 compiles with many warnings, but without errors. Upgrading to V9 is not possible for various reasons. However, I think it's not a bug regarding DBD::DB2 and you can close/reject this bug. Thanks, Peter
Closing the issue. Thanks -- Thanks IBM OpenSource Application Development Team India Software Labs, Bangalore (India)