From: Chris Travers <chris@travelamericas.com>
To: Jessica Blank <jessica@starchefs.com>
Cc: Philip Hallstrom <philip@adhesivemedia.com>
Cc: John Chapman <johnc@cniconsulting.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
Date: Mon, 03 Feb 2003 20:46:35 -0800
Message-ID: <3E3F45AB.8090306@travelamericas.com> (raw)
References: <Pine.GSO.4.05.10302032255430.14859-100000@knife.starchefs.com>
Hi Jessica--
What I would do is--
cd /path/to/php/dir
./configure --with-pgsql=/path/to/postresql/source
make
make install
Then restart apache.
It may be finding the old PgSQL libs, headers, etc.
Best Wishes,
Chris
Jessica Blank wrote:
>Quite odd. Maybe, as someone suggested, it is an issue of library path...
>am looking into that now.
>
>On Mon, 3 Feb 2003, Philip Hallstrom wrote:
>
>
>
>>I just installed postgres 7.3.1 and php 4.3.0 on a fresh server a couple
>>of days ago and didn't get your error... I haven't used it much, but "php
>>-i" returns:
>>
>>pgsql
>>
>>PostgreSQL Support => enabled
>>PostgreSQL(libpq) Version => 7.3.1
>>Multibyte character support => enabled
>>SSL support => disabled
>>Active Persistent Links => 0
>>Active Links => 0
>>
>>
>>and I do not have a libpq.so.2 (I have .3)
>>
>>On Mon, 3 Feb 2003, Jessica Blank wrote:
>>
>>
>>
>>>I am happy for you-- you got YOUR copy of PHP 4.3.0 working with YOUR copy
>>>of PostgreSQL 7.3.1. However, two questions:
>>>
>>>1) How can I do the same?
>>>2) Were you previously using PostgreSQL 7.3.0? If so, you most likely HAD
>>>A COPY of libpq.so.2 still floating about in /usr/local/postgres/lib or
>>>wherever... A mediocre and kluge-y solution at best. (So everyone
>>>installing PostgreSQL 7.3.x with PHP for the first time is required to
>>>FIRST install 7.3.0, THEN install 7.3.1 atop it, to get both versions of
>>>libpq.so? That would be a horrendous band-aid-ish solution. C'mon, we're
>>>all above that sort of rubbish. This is PostgreSQL, not Microsoft SQL
>>>Server. ;) )
>>>
>>>Can you show me the output of 'ls' on your PostgreSQL libs directory
>>>please?
>>>
>>>--Jessica
>>>
>>>On Mon, 3 Feb 2003, John Chapman wrote:
>>>
>>>
>>>
>>>>
>>>>
>>>>>The latest PHP4 (php-4.3.0) WILL NOT work with 7.3.1, since it (PHP)
>>>>>expects there to be libpq.so.2, whereas 7.3.1 only provides libpq.so.3
>>>>>...
>>>>>
>>>>>... I am really astonished that I could not find anyone else who had
>>>>>this problem. Am I doing something horridly wrong?
>>>>>
>>>>>
>>>>I don't know the answer. However, I do not agree with your assertion
>>>>above. Note the following:
>>>>
>>>>
>>>>root@db:/usr/local/apache/htdocs# psql -V
>>>>psql (PostgreSQL) 7.3.1
>>>>contains support for command-line editing
>>>>root@db:/usr/local/apache/htdocs# telnet localhost 80
>>>>Trying 127.0.0.1...
>>>>Connected to localhost.
>>>>Escape character is '^]'.
>>>>HEAD / HTTP/1.0
>>>>
>>>>HTTP/1.1 200 OK
>>>>Date: Tue, 04 Feb 2003 03:20:20 GMT
>>>>Server: Apache/1.3.27 (Unix) PHP/4.3.0
>>>>Last-Modified: Thu, 30 Jan 2003 21:30:19 GMT
>>>>ETag: "20cef-0-3e39996b"
>>>>Accept-Ranges: bytes
>>>>Content-Length: 0
>>>>Connection: close
>>>>Content-Type: text/html
>>>>
>>>>Connection closed by foreign host.
>>>>
>>>>
>>>>
>>>>***********************************
>>>>
>>>>John Chapman
>>>>CNI Consulting
>>>>johnc@cniconsulting.com
>>>>www.cniemail.com
>>>>817-774-0369
>>>>
>>>>---------------------------(end of broadcast)---------------------------
>>>>TIP 3: if posting/reading through Usenet, please send an appropriate
>>>>subscribe-nomail command to majordomo@postgresql.org so that your
>>>>message can get through to the mailing list cleanly
>>>>
>>>>
>>>>
>>> --Jessica
>>>
>>> --
>>> Jessica L. Blank, Systems Administrator & Programmer
>>>
>>> www.starchefs.com
>>> 9 East 19th St., 9th Floor / New York, NY 10003
>>> Jessica@StarChefs.com - (973) 485-0684
>>> Pager (917) 675-6618
>>>
>>>
>>> Help Wanted. Help Found.
>>> www.helpwantedhelpfound.com, a division of StarChefs
>>>
>>>
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 4: Don't 'kill -9' the postmaster
>>>
>>>
>>>
>>
>>
>
>
> --Jessica
>
> --
> Jessica L. Blank, Systems Administrator & Programmer
>
> www.starchefs.com
> 9 East 19th St., 9th Floor / New York, NY 10003
> Jessica@StarChefs.com - (973) 485-0684
> Pager (917) 675-6618
>
>
> Help Wanted. Help Found.
> www.helpwantedhelpfound.com, a division of StarChefs
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: chris@travelamericas.com, jessica@starchefs.com, philip@adhesivemedia.com, johnc@cniconsulting.com, pgsql-general@postgresql.org
Subject: Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
In-Reply-To: <3E3F45AB.8090306@travelamericas.com>
References: <Pine.GSO.4.05.10302032255430.14859-100000@knife.starchefs.com> <3E3F45AB.8090306@travelamericas.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox