Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D508163270C for ; Fri, 9 Jan 2009 13:26:03 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04961-02 for ; Fri, 9 Jan 2009 13:25:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web31306.mail.mud.yahoo.com (web31306.mail.mud.yahoo.com [68.142.198.101]) by mail.postgresql.org (Postfix) with SMTP id CCC1E632700 for ; Fri, 9 Jan 2009 13:25:50 -0400 (AST) Received: (qmail 83672 invoked by uid 60001); 9 Jan 2009 17:25:49 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=5VaLK74WZ2zpUShlKt+vIYGErmYxZ9yoFYhxXB5SN1H4+QYqCBQrg8GrWDKGR6nn/RXqGEbnFnA26tKOGouebrxdIlZvunzHlg8EEq4mwBT+lOEEEnWEH02irVtcytkV+YYlj1173xaG6oC41xZlj5xk76ofGV29YTJqKJ1CNIs=; X-YMail-OSG: _Q95ZKAVM1nl8zTqNE4K6pfasCivjdYTLMJjSgnchV6q2Tz.qN4YcQy3tQk2gIPBiJZ4Y_vZGS3JU5DSQAIs1S_ED4ub_Zx8zK8fu2XVXsU2337s_aBfWhJ30qZcHVWfJPfaJ1JNfq4ThanSANXa_jOaLEkVDqKeCilfH35ADuzEhiUvh8xV9bDinL5SyJf82p2XzIJLAbNRUnb.rYq2CFIdyaBE3Utvc2Pb5DU- Received: from [206.190.70.135] by web31306.mail.mud.yahoo.com via HTTP; Fri, 09 Jan 2009 09:25:48 PST X-Mailer: YahooMailRC/1155.45 YahooMailWebService/0.7.260.1 References: <230332.37017.qm@web31304.mail.mud.yahoo.com> <4966BA4D.9050304@gmail.com> Date: Fri, 9 Jan 2009 09:25:48 -0800 (PST) From: "L. Zhao" Subject: Re: Question on libpq.so To: Chris Cc: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1115237705-1231521948=:83424" Message-ID: <77946.83424.qm@web31306.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200901/7 X-Sequence-Number: 3962 --0-1115237705-1231521948=:83424 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable The server had postgres 7.4 installed, when I tried to upgrade to 8.2.10, I= got error on failed dependencies:=0Arpm -Uvh --test postgresql-*.rpm=0Aerr= or: Failed dependencies:=0A=A0=A0=A0=A0=A0=A0=A0 libpq.so.3 is needed by (i= nstalled) mod_auth_pgsql-2.0.1-7.1.i386=0A=A0=A0=A0=A0=A0=A0=A0 libpq.so.3 = is needed by (installed) perl-DBD-Pg-1.31-6.i386=0A=A0=A0=A0=A0=A0=A0=A0 li= bpq.so.3 is needed by (installed) libdbi-dbd-pgsql-0.6.5-10.RHEL4.1.i386=0A= =A0=A0=A0=A0=A0=A0=A0 libpq.so.3 is needed by (installed) freeradius-postgr= esql-1.0.1-3.RHEL4.5.i386=0A=A0=A0=A0=A0=A0=A0=A0 libpq.so.3 is needed by (= installed) postgresql-tcl-7.4.19-1.el4_6.1.i386=0A=A0=A0=A0=A0=A0=A0=A0 lib= pq.so.3 is needed by (installed) cyrus-sasl-sql-2.1.19-14.i386=0A=A0=A0=A0= =A0=A0=A0=A0 libpq.so.3 is needed by (installed) postgresql-python-7.4.19-1= .el4_6.1.i386=0A=A0=A0=A0=A0=A0=A0=A0 libpq.so.3 is needed by (installed) q= t-PostgreSQL-3.3.3-13.RHEL4.i386=0A=A0=A0=A0=A0=A0=A0=A0 libpq.so.3 is need= ed by (installed) dovecot-0.99.11-9.EL4.i386=0A=A0=A0=A0=A0=A0=A0=A0 libpq.= so.3 is needed by (installed) php-pgsql-4.3.9-3.22.12.i386=0A=0A=0AThat is = why I use the --nodeps, expecting that I will rebuild php rpm afterwards.= =0Arpm -Uvh --nodeps postgresql-*.rpm=0APreparing...=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 ########################################### [100%]= =0A=A0=A0 1:postgresql-test=A0=A0=A0=A0=A0=A0=A0 ##########################= ################# [=A0 9%]=0A=A0=A0 2:postgresql=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 ########################################### [ 18%]=0A=A0=A0 3:pos= tgresql-contrib=A0=A0=A0=A0 ########################################### [ 2= 7%]=0A=A0=A0 4:postgresql-debuginfo=A0=A0 #################################= ########## [ 36%]=0A=A0=A0 5:postgresql-devel=A0=A0=A0=A0=A0=A0 ###########= ################################ [ 45%]=0A=A0=A0 6:postgresql-docs=A0=A0=A0= =A0=A0=A0=A0 ########################################### [ 55%]=0A=A0=A0 7:= postgresql-libs=A0=A0=A0=A0=A0=A0=A0 ######################################= ##### [ 64%]=0A=A0=A0 8:postgresql-plperl=A0=A0=A0=A0=A0 ##################= ######################### [ 73%]=0A=A0=A0 9:postgresql-plpython=A0=A0=A0 ##= ######################################### [ 82%]=0A=A0 10:postgresql-pltcl= =A0=A0=A0=A0=A0=A0 ########################################### [ 91%]=0A=A0= 11:postgresql-server=A0=A0=A0=A0=A0 ######################################= ##### [100%]=0A=0AWhen I tried to rebuild PHP rpms, which is php 4.3.9 on E= S4.=A0 It failed:=0A......=0A001+ PHP Warning:=A0 Unknown(): Unable to load= dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared = object file: No such file or directory in Unknown on line 0=0A002- md5(line= 1)=3D e84debf3a1d132871d7fe45c1c04c566 (length 20000)=0A002+ md5(line 0)= =3D e86410fa2d6e2634fd8ac5f4b3afe7f3 (length 10)=0A003- md5(line 2)=3D c33b= 4d2f86908eea5d75ee5a61fd81f4 (length 10000)=0A003+ md5(line 1)=3D e84debf3a= 1d132871d7fe45c1c04c566 (length 20000)=0A004- md5(line 3)=3D 2ecdde3959051d= 913f61b14579ea136d (length 5)=0A004+ md5(line 2)=3D c33b4d2f86908eea5d75ee5= a61fd81f4 (length 10000)=0A005- md5(line 4)=3D c33b4d2f86908eea5d75ee5a61fd= 81f4 (length 10000)=0A005+ md5(line 3)=3D 2ecdde3959051d913f61b14579ea136d = (length 5)=0A006- md5(line 5)=3D 902fbdd2b1df0c4f70b4a5d23525e932 (length 3= )=0A006+ md5(line 4)=3D c33b4d2f86908eea5d75ee5a61fd81f4 (length 10000)=0A0= 07+ md5(line 5)=3D 902fbdd2b1df0c4f70b4a5d23525e932 (length 3)=0A<< ../ext/= standard/tests/file/bug26938.diff result ends.=0Aerror: Bad exit status fro= m /var/tmp/rpm-tmp.12911 (%check)=0A=0ARPM build errors:=0A=A0=A0=A0 Bad ex= it status from /var/tmp/rpm-tmp.12911 (%check)=0A=0AI look into php.spec, i= t does not specify the usage of libpq.so.3.=A0 So I am wondering why librar= y pgsql.so requires libpq.so.3, and if there is any compatibility issue.=0A= =0AThanks.=0A=0A=0A=0A=0A________________________________=0AFrom: Chris =0ATo: L. Zhao =0ACc: pgsql-php@postgres= ql.org=0ASent: Thursday, January 8, 2009 6:45:33 PM=0ASubject: Re: [PHP] Qu= estion on libpq.so=0A=0AL. Zhao wrote:=0A> We are in the process of upgradi= ng our postgres database from 7.4 to 8.2 on Redhat ES4 server.=A0 Postgresq= l uses libpq.so.5.0, while libpq.so.3 was initially installed and is needed= by php.=A0 I did the postgresql 8.2.10 installation without dependency:=0A= > rpm -Uvh --nodeps postgresql-*.rpm=0A=0AWas there a reason why you had to= use --nodeps? Exactly which rpms did you install?=0A=0A> Then I try to rec= ompile PHP 4.3.9 rpm, hoping that it will point to the new postgres so.=A0 = The compilation failed with the error:=0A> Unable to load dynamic library '= /usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object file: No su= ch file or directory in Unknown on line 0=0A=0AAs Alan pointed out, this is= a runtime error not a compile error. How did you rebuild the php 4.3.9 rpm= ? Any errors during that process?=0A=0A> Can PHP 4.3 work with postgresql 8= .2, and how can I point PHP rpm to use libpq.so.5?=A0 Thanks.=0A=0AOnce you= have it compiled properly it should work fine.=0A=0A-- Postgresql & php tu= torials=0Ahttp://www.designmagick.com/=0A=0A=0A-- Sent via pgsql-php mailin= g list (pgsql-php@postgresql.org)=0ATo make changes to your subscription:= =0Ahttp://www.postgresql.org/mailpref/pgsql-php=0A=0A=0A=0A --0-1115237705-1231521948=:83424 Content-Type: text/html; charset=us-ascii
The server had postgres 7.4 installed, when I tried to upgrade to 8.2.10, I got error on failed dependencies:
rpm -Uvh --test postgresql-*.rpm
error: Failed dependencies:
        libpq.so.3 is needed by (installed) mod_auth_pgsql-2.0.1-7.1.i386
        libpq.so.3 is needed by (installed) perl-DBD-Pg-1.31-6.i386
        libpq.so.3 is needed by (installed) libdbi-dbd-pgsql-0.6.5-10.RHEL4.1.i386
        libpq.so.3 is needed by (installed) freeradius-postgresql-1.0.1-3.RHEL4.5.i386
        libpq.so.3 is needed by (installed) postgresql-tcl-7.4.19-1.el4_6.1.i386
        libpq.so.3 is needed by (installed) cyrus-sasl-sql-2.1.19-14.i386
        libpq.so.3 is needed by (installed) postgresql-python-7.4.19-1.el4_6.1.i386
        libpq.so.3 is needed by (installed) qt-PostgreSQL-3.3.3-13.RHEL4.i386
        libpq.so.3 is needed by (installed) dovecot-0.99.11-9.EL4.i386
        libpq.so.3 is needed by (installed) php-pgsql-4.3.9-3.22.12.i386
 
That is why I use the --nodeps, expecting that I will rebuild php rpm afterwards.
rpm -Uvh --nodeps postgresql-*.rpm
Preparing...                ########################################### [100%]
   1:postgresql-test        ########################################### [  9%]
   2:postgresql             ########################################### [ 18%]
   3:postgresql-contrib     ########################################### [ 27%]
   4:postgresql-debuginfo   ########################################### [ 36%]
   5:postgresql-devel       ########################################### [ 45%]
   6:postgresql-docs        ########################################### [ 55%]
   7:postgresql-libs        ########################################### [ 64%]
   8:postgresql-plperl      ########################################### [ 73%]
   9:postgresql-plpython    ########################################### [ 82%]
  10:postgresql-pltcl       ########################################### [ 91%]
  11:postgresql-server      ########################################### [100%]

When I tried to rebuild PHP rpms, which is php 4.3.9 on ES4.  It failed:
......
001+ PHP Warning:  Unknown(): Unable to load dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object file: No such file or directory in Unknown on line 0
002- md5(line 1)= e84debf3a1d132871d7fe45c1c04c566 (length 20000)
002+ md5(line 0)= e86410fa2d6e2634fd8ac5f4b3afe7f3 (length 10)
003- md5(line 2)= c33b4d2f86908eea5d75ee5a61fd81f4 (length 10000)
003+ md5(line 1)= e84debf3a1d132871d7fe45c1c04c566 (length 20000)
004- md5(line 3)= 2ecdde3959051d913f61b14579ea136d (length 5)
004+ md5(line 2)= c33b4d2f86908eea5d75ee5a61fd81f4 (length 10000)
005- md5(line 4)= c33b4d2f86908eea5d75ee5a61fd81f4 (length 10000)
005+ md5(line 3)= 2ecdde3959051d913f61b14579ea136d (length 5)
006- md5(line 5)= 902fbdd2b1df0c4f70b4a5d23525e932 (length 3)
006+ md5(line 4)= c33b4d2f86908eea5d75ee5a61fd81f4 (length 10000)
007+ md5(line 5)= 902fbdd2b1df0c4f70b4a5d23525e932 (length 3)
<< ../ext/standard/tests/file/bug26938.diff result ends.
error: Bad exit status from /var/tmp/rpm-tmp.12911 (%check)

RPM build errors:
    Bad exit status from /var/tmp/rpm-tmp.12911 (%check)

I look into php.spec, it does not specify the usage of libpq.so.3.  So I am wondering why library pgsql.so requires libpq.so.3, and if there is any compatibility issue.
 
Thanks.
 
 
 

From: Chris <dmagick@gmail.com>
To: L. Zhao <lzhao86@yahoo.com>
Cc: pgsql-php@postgresql.org
Sent: Thursday, January 8, 2009 6:45:33 PM
Subject: Re: [PHP] Question on libpq.so

L. Zhao wrote:
> We are in the process of upgrading our postgres database from 7.4 to 8.2 on Redhat ES4 server.  Postgresql uses libpq.so.5.0, while libpq.so.3 was initially installed and is needed by php.  I did the postgresql 8.2.10 installation without dependency:
> rpm -Uvh --nodeps postgresql-*.rpm

Was there a reason why you had to use --nodeps? Exactly which rpms did you install?

> Then I try to recompile PHP 4.3.9 rpm, hoping that it will point to the new postgres so.  The compilation failed with the error:
> Unable to load dynamic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object file: No such file or directory in Unknown on line 0

As Alan pointed out, this is a runtime error not a compile error. How did you rebuild the php 4.3.9 rpm? Any errors during that process?

> Can PHP 4.3 work with postgresql 8.2, and how can I point PHP rpm to use libpq.so.5?  Thanks.

Once you have it compiled properly it should work fine.

-- Postgresql & php tutorials
http://www.designmagick.com/


-- Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

--0-1115237705-1231521948=:83424--