Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cEeou-0002UB-GI for pgsql-interfaces@arkaria.postgresql.org; Wed, 07 Dec 2016 16:11:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cEeou-00059Y-3B for pgsql-interfaces@arkaria.postgresql.org; Wed, 07 Dec 2016 16:11:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cEYxa-0005ZI-A6 for pgsql-interfaces@postgresql.org; Wed, 07 Dec 2016 09:56:22 +0000 Received: from tp6i.keyweb.com ([70.85.44.59] helo=tp6.keyweb.com) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cEYxR-0003RU-DB for pgsql-interfaces@postgresql.org; Wed, 07 Dec 2016 09:56:21 +0000 Received: from [47.204.241.141] (helo=robertnicksmbp.home) by tp6.keyweb.com (envelope-from bnick@keyweb.com) with esmtpa (Exim) id 1cEYxK-0003gU-7j for pgsql-interfaces@postgresql.org; Wed, 07 Dec 2016 03:56:06 -0600 From: Bob Nick Content-Type: multipart/alternative; boundary="Apple-Mail=_996334E0-BC0A-4DAA-BFA6-87A173A3A313" Mime-Version: 1.0 (Mac OS X Mail 10.1 \(3251\)) Subject: help with pgsql_perl5-1.9.0 Message-Id: <5772C3C8-8767-497B-9B25-F5668272F526@keyweb.com> Date: Wed, 7 Dec 2016 04:56:08 -0500 To: pgsql-interfaces@postgresql.org X-Mailer: Apple Mail (2.3251) X-Pg-Spam-Score: -4.9 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-interfaces Precedence: bulk Sender: pgsql-interfaces-owner@postgresql.org --Apple-Mail=_996334E0-BC0A-4DAA-BFA6-87A173A3A313 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii I have been attempting to install pgsql so I can make use of the old Pg = commands, otherwise I have thousands of lines of code in hundreds of cgi = scripts which I am going to have to modify. I successfully installed = this same version on another Centos 6 server about a year ago and it = compiled and works correctly. This is on a new server I am attempting = to put into service, and need to get it running ASAP. =20 I have been unable to do a successful make on the software, I get LD_RUN_PATH=3D"/usr/lib/../lib64" cc -shared -O2 -L/usr/local/lib = -fstack-protector Pg.o -o blib/arch/auto/Pg/Pg.so \ -L/usr/local/pgsql/include -lpq \ =20 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make: *** [blib/arch/auto/Pg/Pg.so] Error 1 After getting the error the first time, I removed the old perl and = installed the latest version per the instructions in the README pgsql_perl5-1.9.0 perl -v This is perl 5, version 24, subversion 0 (v5.24.0) built for = x86_64-linux perl -V Summary of my perl5 (revision 5 version 24 subversion 0) configuration: =20 Platform: osname=3Dlinux, osvers=3D2.6.32-642.11.1.el6.x86_64, = archname=3Dx86_64-linux uname=3D'linux tp2.keyweb.com 2.6.32-642.11.1.el6.x86_64 #1 smp fri = nov 18 19:25:05 utc 2016 x86_64 x86_64 x86_64 gnulinux ' config_args=3D'-de' hint=3Dprevious, useposix=3Dtrue, d_sigaction=3Ddefine useithreads=3Dundef, usemultiplicity=3Dundef use64bitint=3Ddefine, use64bitall=3Ddefine, uselongdouble=3Dundef usemymalloc=3Dn, bincompat5005=3Dundef Compiler: cc=3D'cc', ccflags =3D'-fwrapv -fno-strict-aliasing -pipe = -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE = -D_FILE_OFFSET_BITS=3D64 -D_FORTIFY_SOURCE=3D2', optimize=3D'-O2', cppflags=3D'-fwrapv -fno-strict-aliasing -pipe -fstack-protector = -I/usr/local/include' ccversion=3D'', gccversion=3D'4.4.7 20120313 (Red Hat 4.4.7-17)', = gccosandvers=3D'' intsize=3D4, longsize=3D8, ptrsize=3D8, doublesize=3D8, = byteorder=3D12345678, doublekind=3D3 d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, = longdblsize=3D16, longdblkind=3D3 ivtype=3D'long', ivsize=3D8, nvtype=3D'double', nvsize=3D8, = Off_t=3D'off_t', lseeksize=3D8 alignbytes=3D8, prototype=3Ddefine Linker and Libraries: ld=3D'cc', ldflags =3D' -fstack-protector -L/usr/local/lib' libpth=3D/usr/local/lib /usr/lib /lib/../lib64 /usr/lib/../lib64 = /lib /lib64 /usr/lib64 /usr/local/lib64 /usr/local/lib /usr/lib libs=3D-lpthread -lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc perllibs=3D-lpthread -lnsl -ldl -lm -lcrypt -lutil -lc libc=3Dlibc-2.12.so, so=3Dso, useshrplib=3Dfalse, libperl=3Dlibperl.a gnulibc_version=3D'2.12' Dynamic Linking: dlsrc=3Ddl_dlopen.xs, dlext=3Dso, d_dlsymun=3Dundef, = ccdlflags=3D'-Wl,-E' cccdlflags=3D'-fPIC', lddlflags=3D'-shared -O2 -L/usr/local/lib = -fstack-protector' Characteristics of this binary (from libperl):=20 Compile-time options: HAS_TIMES PERLIO_LAYERS PERL_COPY_ON_WRITE PERL_DONT_CREATE_GVSV PERL_HASH_FUNC_ONE_AT_A_TIME_HARD = PERL_MALLOC_WRAP PERL_PRESERVE_IVUV USE_64_BIT_ALL USE_64_BIT_INT USE_LARGE_FILES USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE USE_LOCALE_NUMERIC = USE_LOCALE_TIME USE_PERLIO USE_PERL_ATOF Built under linux Compiled at Dec 7 2016 04:18:40 @INC: /usr/local/lib/perl5/site_perl/5.24.0/x86_64-linux /usr/local/lib/perl5/site_perl/5.24.0 /usr/local/lib/perl5/5.24.0/x86_64-linux /usr/local/lib/perl5/5.24.0 Thank you, Bob Nick bnick@keyweb.com www.keyweb.com --Apple-Mail=_996334E0-BC0A-4DAA-BFA6-87A173A3A313 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
I have been attempting to install pgsql so I = can make use of the old Pg commands, otherwise I have thousands of lines = of code in hundreds of cgi scripts which I am going to have to modify. =  I successfully installed this same version  on another Centos = 6 server about a year ago  and it compiled and works correctly. =  This is on a new server I am attempting to put into service, and = need to get it running ASAP.  

I have been unable to do a successful make on the = software, I get
LD_RUN_PATH=3D"/usr/lib/../lib64" cc  -shared -O2 = -L/usr/local/lib -fstack-protector Pg.o  -o blib/arch/auto/Pg/Pg.so = = \
  = -L/usr/local/pgsql/include -lpq  \
 
/usr/bin/ld: cannot find -lpq
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/Pg/Pg.so] Error = 1
After getting the error the first time, = I removed the old perl and installed the latest version
per the instructions in the README
pgsql_perl5-1.9.0

perl -v
This is perl 5, version 24, subversion 0 (v5.24.0) built for = x86_64-linux

perl -V
Summary of my perl5 (revision 5 version 24 subversion 0) = configuration:
   
  Platform:
    osname=3Dlinux, = osvers=3D2.6.32-642.11.1.el6.x86_64, = archname=3Dx86_64-linux
    uname=3D'linux tp2.keyweb.com 2.6.32-642.11.1.el6.x86_64 #1 smp fri nov = 18 19:25:05 utc 2016 x86_64 x86_64 x86_64 gnulinux = '
    = config_args=3D'-de'
    hint=3Dprevious, useposix=3Dtrue, = d_sigaction=3Ddefine
    useithreads=3Dundef, = usemultiplicity=3Dundef
    use64bitint=3Ddefine, use64bitall=3Ddefine, = uselongdouble=3Dundef
    usemymalloc=3Dn, = bincompat5005=3Dundef
  Compiler:
    cc=3D'cc', ccflags =3D'-fwrapv = -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include = -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64 = -D_FORTIFY_SOURCE=3D2',
    optimize=3D'-O2',
    cppflags=3D'-fwrapv -fno-strict-aliasing -pipe = -fstack-protector -I/usr/local/include'
    ccversion=3D'', gccversion=3D'4.4.7 20120313 = (Red Hat 4.4.7-17)', gccosandvers=3D''
    intsize=3D4, longsize=3D8, ptrsize=3D8, = doublesize=3D8, byteorder=3D12345678, doublekind=3D3
    d_longlong=3Ddefine, longlongsize=3D8, = d_longdbl=3Ddefine, longdblsize=3D16, longdblkind=3D3
    ivtype=3D'long', ivsize=3D8, = nvtype=3D'double', nvsize=3D8, Off_t=3D'off_t', = lseeksize=3D8
    = alignbytes=3D8, prototype=3Ddefine
  Linker and Libraries:
    ld=3D'cc', ldflags =3D' -fstack-protector = -L/usr/local/lib'
    = libpth=3D/usr/local/lib /usr/lib /lib/../lib64 /usr/lib/../lib64 /lib = /lib64 /usr/lib64 /usr/local/lib64 /usr/local/lib = /usr/lib
    = libs=3D-lpthread -lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil = -lc
    = perllibs=3D-lpthread -lnsl -ldl -lm -lcrypt -lutil = -lc
    = libc=3Dlibc-2.12.so, so=3Dso, useshrplib=3Dfalse, = libperl=3Dlibperl.a
    gnulibc_version=3D'2.12'
  Dynamic Linking:
    dlsrc=3Ddl_dlopen.xs, dlext=3Dso, = d_dlsymun=3Dundef, ccdlflags=3D'-Wl,-E'
    cccdlflags=3D'-fPIC', lddlflags=3D'-shared -O2 = -L/usr/local/lib -fstack-protector'


Characteristics of this binary (from = libperl): 
  Compile-time = options: HAS_TIMES PERLIO_LAYERS PERL_COPY_ON_WRITE
                =         PERL_DONT_CREATE_GVSV
                =         PERL_HASH_FUNC_ONE_AT_A_TIME_HARD = PERL_MALLOC_WRAP
      =                   = PERL_PRESERVE_IVUV USE_64_BIT_ALL USE_64_BIT_INT
                =         USE_LARGE_FILES USE_LOCALE = USE_LOCALE_COLLATE
      =                   = USE_LOCALE_CTYPE USE_LOCALE_NUMERIC USE_LOCALE_TIME
                =         USE_PERLIO = USE_PERL_ATOF
  Built under = linux
  Compiled at = Dec  7 2016 04:18:40
  @INC:
    = /usr/local/lib/perl5/site_perl/5.24.0/x86_64-linux
    = /usr/local/lib/perl5/site_perl/5.24.0
    = /usr/local/lib/perl5/5.24.0/x86_64-linux
    = /usr/local/lib/perl5/5.24.0

Thank you,
Bob Nick
bnick@keyweb.com
www.keyweb.com



= --Apple-Mail=_996334E0-BC0A-4DAA-BFA6-87A173A3A313--