Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 - Mailing list pgsql-general

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
>
>
>
>