From lzhao86@yahoo.com Fri Jan 9 00:34:44 2009 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B3993632734 for ; Thu, 8 Jan 2009 20:34:44 -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 25862-03 for ; Thu, 8 Jan 2009 20:34:39 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web31304.mail.mud.yahoo.com (web31304.mail.mud.yahoo.com [68.142.198.99]) by mail.postgresql.org (Postfix) with SMTP id 36857632726 for ; Thu, 8 Jan 2009 20:34:39 -0400 (AST) Received: (qmail 37511 invoked by uid 60001); 9 Jan 2009 00:34:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=4T/8xsD/S0SLuXCSa6UfrcDaiUpjPKSdsd9pHozVVusTWseSojaZ1/HB7joBNtfGfFW6wiq6SpaFEPZWeaTb94JpT0OjvO1RGysdRjDbMDt+ZODtMKSIXGxLZRSAWrFM2w8WxGEqy9CcvqYQdVQrKsSyRfr2NUl7MPxsNUPoK6A=; X-YMail-OSG: DQYnKAEVM1mRw.XPvkwolxBHgmu07v5mkQoHYHCxZNxfhdoKUWsJE7rQEJrpO8sQCc2ZyanIfyRvV5.BUcrvUtzJpXFu9ez5odCO0muBVsJ14zYDytuzXnI_2arCp807eRwH7EJaeijjTspxikOJR6yFpU7gNDyAlNFYbr764q6UfHiXFccItCQY_MHtKZHD3dpMxoMNWMVZ_84P9p0dZ4PKknKmz27rxzBfog-- Received: from [206.190.70.135] by web31304.mail.mud.yahoo.com via HTTP; Thu, 08 Jan 2009 16:34:37 PST X-Mailer: YahooMailRC/1155.45 YahooMailWebService/0.7.260.1 Date: Thu, 8 Jan 2009 16:34:37 -0800 (PST) From: "L. Zhao" Subject: Question on libpq.so To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-509622779-1231461277=:37017" Message-ID: <230332.37017.qm@web31304.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/4 X-Sequence-Number: 3959 --0-509622779-1231461277=:37017 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable We are in the process of upgrading our postgres database from 7.4 to 8.2 on= Redhat ES4 server.=A0 Postgresql uses libpq.so.5.0, while libpq.so.3 was i= nitially installed and=A0is needed by php.=A0 I did the postgresql 8.2.10 i= nstallation without dependency:=0Arpm -Uvh --nodeps postgresql-*.rpm=0AThen= I try to recompile PHP 4.3.9 rpm, hoping that it will point to the new pos= tgres so.=A0 The compilation failed with the error: =0AUnable to load dynam= ic library '/usr/lib/php4/pgsql.so' - libpq.so.3: cannot open shared object= file: No such file or directory in Unknown on line 0=0A=0ACan PHP 4.3 work= with postgresql 8.2, and how can I point PHP rpm to use libpq.so.5?=A0 Tha= nks.=0A=0A=0ALawrence=0A=0A=0A --0-509622779-1231461277=:37017 Content-Type: text/html; charset=us-ascii
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
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
 
Can PHP 4.3 work with postgresql 8.2, and how can I point PHP rpm to use libpq.so.5?  Thanks.
 
 
Lawrence

--0-509622779-1231461277=:37017-- From ahodgson@simkin.ca Fri Jan 9 01:12:10 2009 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9251C63278B for ; Thu, 8 Jan 2009 21:12:10 -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 32314-01-3 for ; Thu, 8 Jan 2009 21:12:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117]) by mail.postgresql.org (Postfix) with ESMTP id 21E8A632531 for ; Thu, 8 Jan 2009 21:08:45 -0400 (AST) Received: from charon.medialogik.com (unknown [10.10.2.229]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id 6612B4A63 for ; Thu, 8 Jan 2009 17:08:41 -0800 (PST) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-php@postgresql.org Subject: Re: Question on libpq.so Date: Thu, 8 Jan 2009 17:08:40 -0800 User-Agent: KMail/1.9.10 References: <230332.37017.qm@web31304.mail.mud.yahoo.com> In-Reply-To: <230332.37017.qm@web31304.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200901081708.40787@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/5 X-Sequence-Number: 3960 On Thursday 08 January 2009, "L. Zhao" wrote: > new postgres so.=C2=A0 The compilation failed with the error: Unable to l= oad > 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 That appears to be a runtime message, not a compile error. Did the=20 compilation system have only the new PostgreSQL installed? What does rpm=20 show for dependencies for your new RPMs? Did you actually install the new=20 RPMs? =2D-=20 Current Peeve: The mindset that the Internet is some sort of school for novice sysadmins and that everyone -not- doing stupid dangerous things should act like patient teachers with the ones who are. -- Bill Cole, NANAE= =20 From dmagick@gmail.com Fri Jan 9 02:45:46 2009 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 41FD363234F for ; Thu, 8 Jan 2009 22:45:46 -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 47660-01 for ; Thu, 8 Jan 2009 22:45:42 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.231]) by mail.postgresql.org (Postfix) with ESMTP id 874B7632378 for ; Thu, 8 Jan 2009 22:45:42 -0400 (AST) Received: by rv-out-0506.google.com with SMTP id b25so10584727rvf.43 for ; Thu, 08 Jan 2009 18:45:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=zFZUdgIY69VvaYqwqO821TmgVnjugKUqfUZGBiYB0VQ=; b=XjdIVcEkJ4efB1Aaz0G2WywHaADgstDFXID7DoJhD/7vKD2ZbTSqlOw75N98ziinV+ He1evm1juiscEPP8DukT7uJzf2Oj8zqDcM3vRlmqG1Ckuzqmtl++qMsDiJR+pnqoFgnU aMtFt30EBAYShrLqFEVnJA9nW7QH3hB9/Sbow= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=RQLoaGE/1g1Dajff6M5GVwjlTVLqtRRo7zRyMibE4rFXR3j7rAwQvMJwzo8zTz/lRp uVmKEJ95u+3hN6NtyuqxG08wh+JA7mL88yZ4KrhI3ZQuV2zd2n1GRPNS6jZAfVDrPZWO +MnoogCXUAeH5PqBhCjLxE0iTV/d2/JAloGhA= Received: by 10.141.33.19 with SMTP id l19mr12443795rvj.294.1231469140587; Thu, 08 Jan 2009 18:45:40 -0800 (PST) Received: from ?192.168.0.220? (office.squiz.net [203.206.128.174]) by mx.google.com with ESMTPS id k37sm598194rvb.1.2009.01.08.18.45.36 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 08 Jan 2009 18:45:39 -0800 (PST) Message-ID: <4966BA4D.9050304@gmail.com> Date: Fri, 09 Jan 2009 13:45:33 +1100 From: Chris User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: "L. Zhao" CC: pgsql-php@postgresql.org Subject: Re: Question on libpq.so References: <230332.37017.qm@web31304.mail.mud.yahoo.com> In-Reply-To: <230332.37017.qm@web31304.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/6 X-Sequence-Number: 3961 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/ From lzhao86@yahoo.com Fri Jan 9 17:26:03 2009 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-- From ahodgson@simkin.ca Fri Jan 9 17:43:01 2009 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 42F0562E68C for ; Fri, 9 Jan 2009 13:43:01 -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 08311-04 for ; Fri, 9 Jan 2009 13:42:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117]) by mail.postgresql.org (Postfix) with ESMTP id 24D4F62DBE1 for ; Fri, 9 Jan 2009 13:42:56 -0400 (AST) Received: from charon.medialogik.com (unknown [10.10.2.229]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id 663C0400B for ; Fri, 9 Jan 2009 09:42:53 -0800 (PST) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-php@postgresql.org Subject: Re: Question on libpq.so Date: Fri, 9 Jan 2009 09:42:52 -0800 User-Agent: KMail/1.9.10 References: <230332.37017.qm@web31304.mail.mud.yahoo.com> <4966BA4D.9050304@gmail.com> <77946.83424.qm@web31306.mail.mud.yahoo.com> In-Reply-To: <77946.83424.qm@web31306.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200901090942.52739@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/8 X-Sequence-Number: 3963 On Friday 09 January 2009, "L. Zhao" wrote: > RPM build errors: > =C2=A0=C2=A0=C2=A0 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.=C2=A0 = So I > am wondering why library pgsql.so requires libpq.so.3, and if there is > any compatibility issue. It looks like the test suite run during the RPM creation is trying to load= =20 the currently installed PHP pgsql.so library instead of the one just=20 compiled. You could try just commenting out the test options in the RPM=20 spec file. =2D-=20 Current Peeve: The mindset that the Internet is some sort of school for novice sysadmins and that everyone -not- doing stupid dangerous things should act like patient teachers with the ones who are. -- Bill Cole, NANAE= =20 From lzhao86@yahoo.com Fri Jan 9 18:28:29 2009 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B6BA66325F5 for ; Fri, 9 Jan 2009 14:28:29 -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 17563-03 for ; Fri, 9 Jan 2009 14:28:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web31303.mail.mud.yahoo.com (web31303.mail.mud.yahoo.com [68.142.198.98]) by mail.postgresql.org (Postfix) with SMTP id 204C1632603 for ; Fri, 9 Jan 2009 14:28:23 -0400 (AST) Received: (qmail 46632 invoked by uid 60001); 9 Jan 2009 18:28:21 -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:MIME-Version:Content-Type:Message-ID; b=XcX+mw5o8xdp3jGvGvf8kHS4Aw6B/+EAAslkxODn/lAzwTwSb7AVrGkeKQnUU0UvbJGH0ldS8bLMPdEgCl3dTptPBjeDAebQqfzmAsTrooj7JCbaI4FPLUCF4p0Y9ELoJsYOlCu20ZyYSD2XcRnp4PmR1WokKfafhoiKzg8NQoY=; X-YMail-OSG: ghL8BZ8VM1kWiIMbGRW9ynARpy.haLZykxy12DVhwGskblNLsXJwu3Vfsf5guD9dvXTtTO0HzMVQLN47qfoQ0jCmk_5M5mikzvC0tmed22wDUVgJMNl6dOoMbVxgvweo6e09.7qon0pwWVZ2zxXCm4Y445W8uN9UuuVtFKLfA1KG7m1p8zSE_rnF1blKFotrMA-- Received: from [206.190.70.135] by web31303.mail.mud.yahoo.com via HTTP; Fri, 09 Jan 2009 10:28:21 PST X-Mailer: YahooMailRC/1155.45 YahooMailWebService/0.7.260.1 References: <230332.37017.qm@web31304.mail.mud.yahoo.com> <4966BA4D.9050304@gmail.com> <77946.83424.qm@web31306.mail.mud.yahoo.com> <200901090942.52739@hal.medialogik.com> Date: Fri, 9 Jan 2009 10:28:21 -0800 (PST) From: "L. Zhao" Subject: Re: Question on libpq.so To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1075829546-1231525701=:46602" Message-ID: <797573.46602.qm@web31303.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/9 X-Sequence-Number: 3964 --0-1075829546-1231525701=:46602 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I am not familiar with the structure of php.spec.=A0 What should I look for= regarding the test suite run?=A0 Thanks.=0A=0A=0A=0A=0A___________________= _____________=0AFrom: Alan Hodgson =0ATo: pgsql-php@pos= tgresql.org=0ASent: Friday, January 9, 2009 9:42:52 AM=0ASubject: Re: [PHP]= Question on libpq.so=0A=0AOn Friday 09 January 2009, "L. Zhao" wrote:=0A> RPM build errors:=0A> =A0=A0=A0 Bad exit status from /v= ar/tmp/rpm-tmp.12911 (%check)=0A>=0A> I look into php.spec, it does not spe= cify the usage of libpq.so.3.=A0 So I=0A> am wondering why library pgsql.so= requires libpq.so.3, and if there is=0A> any compatibility issue.=0A=0AIt = looks like the test suite run during the RPM creation is trying to load =0A= the currently installed PHP pgsql.so library instead of the one just =0Acom= piled. You could try just commenting out the test options in the RPM =0Aspe= c file.=0A=0A-- =0ACurrent Peeve: The mindset that the Internet is some sor= t of school for=0Anovice sysadmins and that everyone -not- doing stupid dan= gerous things=0Ashould act like patient teachers with the ones who are. -- = Bill Cole, NANAE =0A=0A-- =0ASent via pgsql-php mailing list (pgsql-php@pos= tgresql.org)=0ATo make changes to your subscription:=0Ahttp://www.postgresq= l.org/mailpref/pgsql-php=0A=0A=0A=0A --0-1075829546-1231525701=:46602 Content-Type: text/html; charset=us-ascii
I am not familiar with the structure of php.spec.  What should I look for regarding the test suite run?  Thanks.


From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-php@postgresql.org
Sent: Friday, January 9, 2009 9:42:52 AM
Subject: Re: [PHP] Question on libpq.so

On Friday 09 January 2009, "L. Zhao" <lzhao86@yahoo.com> wrote:
> 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.

It looks like the test suite run during the RPM creation is trying to load
the currently installed PHP pgsql.so library instead of the one just
compiled. You could try just commenting out the test options in the RPM
spec file.

--
Current Peeve: The mindset that the Internet is some sort of school for
novice sysadmins and that everyone -not- doing stupid dangerous things
should act like patient teachers with the ones who are. -- Bill Cole, NANAE

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

--0-1075829546-1231525701=:46602-- From bernt.andreas.drange@imr.no Mon Jan 12 10:50:32 2009 Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 8C60D6323A2 for ; Mon, 12 Jan 2009 06:50:32 -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 53094-04 for ; Mon, 12 Jan 2009 06:50:27 -0400 (AST) X-Greylist: delayed 01:14:04.450959 by SQLgrey-1.7.6 Received: from ns.imr.no (ns.imr.no [82.134.28.194]) by mail.postgresql.org (Postfix) with ESMTP id 78E4A6323A6 for ; Mon, 12 Jan 2009 06:50:22 -0400 (AST) Received: from excas.imr.no ([10.1.2.116]) by ns.imr.no with esmtps (TLSv1:AES128-SHA:128) (Exim 4.67) (envelope-from ) id 1LMJDV-0002Ue-IX; Mon, 12 Jan 2009 10:36:17 +0100 Received: from post3.imr.no (10.1.2.138) by EXCAS.imr.no (10.1.2.116) with Microsoft SMTP Server id 8.1.311.2; Mon, 12 Jan 2009 10:36:17 +0100 x-mimeole: Produced By Microsoft Exchange V6.5 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C97499.37BF9C1D" Subject: Re: Question on libpq.so Date: Mon, 12 Jan 2009 10:36:17 +0100 Message-ID: In-Reply-To: <797573.46602.qm@web31303.mail.mud.yahoo.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PHP] Question on libpq.so Thread-Index: AclyiDJhtuyKdyCmRzm0urIQ84+bnACEO/BQ References: <230332.37017.qm@web31304.mail.mud.yahoo.com> <4966BA4D.9050304@gmail.com> <77946.83424.qm@web31306.mail.mud.yahoo.com> <200901090942.52739@hal.medialogik.com> <797573.46602.qm@web31303.mail.mud.yahoo.com> From: "Drange, Bernt Andreas" To: "L. Zhao" , 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/10 X-Sequence-Number: 3965 ------_=_NextPart_001_01C97499.37BF9C1D Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I suggest you try to see if there is a compatibility rpm you need to install.=20 =20 Kind regards, Bernt =20 From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org] On Behalf Of L. Zhao Sent: Friday, January 09, 2009 7:28 PM To: pgsql-php@postgresql.org Subject: Re: [PHP] Question on libpq.so =20 I am not familiar with the structure of php.spec. What should I look for regarding the test suite run? Thanks. =20 ________________________________ From: Alan Hodgson To: pgsql-php@postgresql.org Sent: Friday, January 9, 2009 9:42:52 AM Subject: Re: [PHP] Question on libpq.so On Friday 09 January 2009, "L. Zhao" wrote: > 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. It looks like the test suite run during the RPM creation is trying to load=20 the currently installed PHP pgsql.so library instead of the one just=20 compiled. You could try just commenting out the test options in the RPM=20 spec file. --=20 Current Peeve: The mindset that the Internet is some sort of school for novice sysadmins and that everyone -not- doing stupid dangerous things should act like patient teachers with the ones who are. -- Bill Cole, NANAE=20 --=20 Sent via pgsql-php mailing list (pgsql-php@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-php =20 ------_=_NextPart_001_01C97499.37BF9C1D Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I suggest you try to see if there is a compatibility rpm = you need to install.

 

Kind regards, Bernt

 

From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org] On Behalf Of L. Zhao
Sent: Friday, January 09, 2009 7:28 PM
To: pgsql-php@postgresql.org
Subject: Re: [PHP] Question on libpq.so

 

I am not familiar with the structure of php.spec.  What should I look = for regarding the test suite run?  Thanks.

 


From:= Alan = Hodgson <ahodgson@simkin.ca>
To: pgsql-php@postgresql.org
Sent: Friday, January 9, 2009 9:42:52 AM
Subject: Re: [PHP] Question on libpq.so

On Friday 09 January 2009, "L. Zhao" <lzhao86@yahoo.com> wrote:
> 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.

It looks like the test suite run during the RPM creation is trying to = load
the currently installed PHP pgsql.so library instead of the one just =
compiled. You could try just commenting out the test options in the RPM =
spec file.

--
Current Peeve: The mindset that the Internet is some sort of school = for
novice sysadmins and that everyone -not- doing stupid dangerous = things
should act like patient teachers with the ones who are. -- Bill Cole, = NANAE

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

 

------_=_NextPart_001_01C97499.37BF9C1D--