<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi all,<br>
<br>
I got a problem with the compilation of DBD::Pg 2.15.1 on AIX 5.3 TL9.<br>
I have did a 64-bit compilation / installation of PostgreSQL 8.3.8 at
the beginning. <br>
<br>
As the "postgres" user, I managed to execute "perl Makefile.PL"
successfully :<br>
<font face="Courier New" size="-1">Configuring DBD::Pg 2.15.1<br>
PostgreSQL version: 80308 (default port: 5432)<br>
POSTGRES_HOME: (not set)<br>
POSTGRES_INCLUDE: /usr/local/pgsql/include<br>
POSTGRES_LIB: /usr/local/pgsql/lib<br>
OS: aix<br>
Using DBI 1.609 (for perl 5.008002 on aix-thread-multi) installed in
/usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi/auto/DBI/<br>
Writing Makefile for DBD::Pg</font><br>
<br>
but the "make" step failed :<br>
<font face="Courier New" size="-1">$ <font color="#3333ff">make</font><br>
cp lib/Bundle/DBD/Pg.pm blib/lib/Bundle/DBD/Pg.pm<br>
cp Pg.pm blib/lib/DBD/Pg.pm<br>
/usr/bin/perl -e 'use ExtUtils::Mksymlists; Mksymlists("NAME"
=> "DBD::Pg", "DL_FUNCS" => { }, "FUNCLIST" => [], "DL_VARS"
=> []);'<br>
/usr/bin/perl -p -e "s/~DRIVER~/Pg/g; s/^do\(/dontdo\(/"
/usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi/auto/DBI/Driver.xst
> Pg.xsi<br>
/usr/bin/perl /usr/opt/perl5/lib/5.8.2/ExtUtils/xsubpp
-typemap /usr/opt/perl5/lib/5.8.2/ExtUtils/typemap Pg.xs > Pg.xsc
&& mv Pg.xsc Pg.c<br>
cc_r -c -I/usr/local/pgsql/include
-I/usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi/auto/DBI
-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384
-qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES -qlonglong -DPGLIBVERSION=80308 -DPGDEFPORT=5432 -O
-DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree
-Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.15.1\"
-DXS_VERSION=\"2.15.1\"
"-I/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE" Pg.c<br>
cc_r -c -I/usr/local/pgsql/include
-I/usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi/auto/DBI
-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384
-qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES -qlonglong -DPGLIBVERSION=80308 -DPGDEFPORT=5432 -O
-DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree
-Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.15.1\"
-DXS_VERSION=\"2.15.1\"
"-I/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE" dbdimp.c<br>
cc_r -c -I/usr/local/pgsql/include
-I/usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi/auto/DBI
-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384
-qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES -qlonglong -DPGLIBVERSION=80308 -DPGDEFPORT=5432 -O
-DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree
-Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.15.1\"
-DXS_VERSION=\"2.15.1\"
"-I/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE" quote.c<br>
"quote.c", line 334.16: 1506-068 (W) Operation between types "char*"
and "const char*" is not allowed.<br>
cc_r -c -I/usr/local/pgsql/include
-I/usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi/auto/DBI
-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384
-qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES -qlonglong -DPGLIBVERSION=80308 -DPGDEFPORT=5432 -O
-DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree
-Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\"2.15.1\"
-DXS_VERSION=\"2.15.1\"
"-I/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE" types.c<br>
Running Mkbootstrap for DBD::Pg ()<br>
chmod 644 Pg.bs<br>
rm -f blib/arch/auto/DBD/Pg/Pg.so<br>
LD_RUN_PATH="" ld -bhalt:4 -bM:SRE
-bI:/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/perl.exp -bE:Pg.exp
-bnoentry -lpthreads -lc_r Pg.o dbdimp.o quote.o types.o -o
blib/arch/auto/DBD/Pg/Pg.so -L/usr/local/pgsql/lib -lpq -lm <br>
<font color="#ff0000">ld: 0711-317 ERROR: Undefined symbol:
.PQerrorMessage<br>
ld: 0711-317 ERROR: Undefined symbol: .PQgetResult<br>
ld: 0711-317 ERROR: Undefined symbol: .PQclear<br>
... ... ...<br>
ld: 0711-317 ERROR: Undefined symbol: .PQserverVersion<br>
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.<br>
make: 1254-004 The error code from the last command is 8.</font></font><br>
<br>
<br>
I use perl5 (revision 5.0 version 8 subversion 2) :<br>
<font face="Courier New" size="-1">$ <font color="#3333ff">perl -V</font><br>
Summary of my perl5 (revision 5.0 version 8 subversion 2) configuration:<br>
Platform:<br>
osname=aix, osvers=5.2.0.0, archname=aix-thread-multi<br>
uname='aix animals 2 5 000709cf4c00 '<br>
config_args=''<br>
hint=previous, useposix=true, d_sigaction=define<br>
usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define<br>
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef<br>
use64bitint=undef use64bitall=undef uselongdouble=undef<br>
usemymalloc=n, bincompat5005=undef<br>
Compiler:<br>
cc='cc_r', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT
-q32 -D_LARGE_FILES -qlonglong',<br>
optimize='-O',<br>
cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT
-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384
-qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES -qlonglong -D_ALL_SOURCE -D_ANSI_C_SOURCE
-D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias
-DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong
-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384
-qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32
-D_LARGE_FILES -qlonglong -D_ALL_SOURCE -D_ANSI_C_SOURCE
-D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN
-DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias
-DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES -qlonglong'<br>
ccversion='5.0.2.0', gccversion='', gccosandvers=''<br>
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321<br>
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8<br>
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8<br>
alignbytes=8, prototype=define<br>
Linker and Libraries:<br>
ld='ld', ldflags =' -brtl -b32 -bmaxdata:0x80000000'<br>
libpth=/lib /usr/lib /usr/ccs/lib<br>
libs=-lbind -lnsl -ldbm -ldl -lld -lm -lpthreads -lc_r -lcrypt
-lbsd -lPW<br>
perllibs=-lbind -lnsl -ldl -lld -lm -lpthreads -lc_r -lcrypt -lbsd
-lPW<br>
libc=/lib/libc.a, so=a, useshrplib=true, libperl=libperl.a<br>
gnulibc_version=''<br>
Dynamic Linking:<br>
dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef,
ccdlflags='-bE:/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/perl.exp
-bE:/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/perl.exp
-bE:/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/perl.exp
-bE:/usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/perl.exp'<br>
cccdlflags=' ', lddlflags='-bhalt:4 -bM:SRE
-bI:$(PERL_INC)/perl.exp -bE:$(BASEEXT).exp -bnoentry -lpthreads -lc_r'<br>
<br>
<br>
Characteristics of this binary (from libperl): <br>
Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
PERL_IMPLICIT_CONTEXT<br>
Locally applied patches:<br>
SUIDPERLIO1 - fix PERLIO_DEBUG buffer overflow (CAN-2005-0156)<br>
SPRINTF0 - fixes for sprintf formatting issues - CVE-2005-3962<br>
REGCOMP0 - buffer overflow in regexp engine for UTF8
(CVE-2007-5116)<br>
Built under aix<br>
Compiled at Dec 5 2007 16:08:49<br>
@INC:<br>
/usr/opt/perl5/lib/5.8.2/aix-thread-multi<br>
/usr/opt/perl5/lib/5.8.2<br>
/usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi<br>
/usr/opt/perl5/lib/site_perl/5.8.2<br>
/usr/opt/perl5/lib/site_perl<br>
.</font><br>
<br>
<br>
Any suggestion ? <br>
<br>
Thank you for your help.<br>
Regards, <br>
Alexandra<br>
<div class="moz-signature"><font color="grey"><br>
</font>
</div>
</body>
</html>