pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])
29+ messages / 14 participants
[nested] [flat]

* 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])
@ 2003-02-04 03:12  Jessica Blank <jessica@starchefs.com>
  0 siblings, 4 replies; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 03:12 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-php

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?

What can I do? I try ./configure'ing PHP, but it tells me:                      
gcc -o conftest -g -O2  -I/usr/pkg/include  -L/usr/pkg/lib
-R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c -lpq -lcrypt
-lm  -lcrypt 1>&5
Shared object "libpq.so.2" not found                                

Complete debug.log installed.

PLEASE help...

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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to
@ 2003-02-04 03:13  Jessica Blank <jessica@starchefs.com>
  parent: Jessica Blank <jessica@starchefs.com>
  3 siblings, 0 replies; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 03:13 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-php

Forgot the debug.log. It is attached. Also, below:

CONFIGURE:   './configure' '--with-apache=../apache_1.3.27' '--with-pgsql=/usr/local/pgsql/'
CC:         gcc
CFLAGS:     -g -O2
CPPFLAGS:    -I/usr/pkg/include
CXX:        
CXXFLAGS:   
INCLUDES:    -I$(top_builddir)/Zend -I/usr/local/pgsql//include
LDFLAGS:     -L/usr/pkg/lib -R/usr/local/pgsql//lib -L/usr/local/pgsql//lib
LIBS:       -lpq -lcrypt -lm  -lcrypt
DLIBS:      
SAPI:       apache
PHP_RPATHS:  /usr/local/pgsql//lib
uname -a:   NetBSD fortitude 1.6 NetBSD 1.6 (fortitude) #0: Tue Dec 31 21:36:31 EST 2002     root@fortitude:/usr/src/sys/arch/macppc/compile/fortitude macppc

gcc -o conftest -g -O2  -I/usr/pkg/include  -L/usr/pkg/lib -R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c -lpq -lcrypt -lm  -lcrypt 1>&5
Shared object "libpq.so.2" not found

On Mon, 3 Feb 2003, Jessica Blank 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?
> 
> What can I do? I try ./configure'ing PHP, but it tells me:                      
> gcc -o conftest -g -O2  -I/usr/pkg/include  -L/usr/pkg/lib
> -R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c -lpq -lcrypt
> -lm  -lcrypt 1>&5
> Shared object "libpq.so.2" not found                                
> 
> Complete debug.log installed.
> 
> PLEASE help...
> 
> 							--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 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 


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

Attachments:

debug.log (text/plain, 792B) download CONFIGURE: './configure' '--with-apache=../apache_1.3.27' '--with-pgsql=/usr/local/pgsql/' CC: gcc CFLAGS: -g -O2 CPPFLAGS: -I/usr/pkg/include CXX: CXXFLAGS: INCLUDES: -I$(top_builddir)/Zend -I/usr/local/pgsql//include LDFLAGS: -L/usr/pkg/lib -R/usr/local/pgsql//lib -L/usr/local/pgsql//lib LIBS: -lpq -lcrypt -lm -lcrypt DLIBS: SAPI: apache PHP_RPATHS: /usr/local/pgsql//lib uname -a: NetBSD fortitude 1.6 NetBSD 1.6 (fortitude) #0: Tue Dec 31 21:36:31 EST 2002 root@fortitude:/usr/src/sys/arch/macppc/compile/fortitude macppc gcc -o conftest -g -O2 -I/usr/pkg/include -L/usr/pkg/lib -R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c -lpq -lcrypt -lm -lcrypt 1>&5 Shared object "libpq.so.2" not found
^ permalink raw reply [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])
@ 2003-02-04 03:23  John Chapman <johnc@cniconsulting.com>
  parent: Jessica Blank <jessica@starchefs.com>
  3 siblings, 2 replies; 29+ messages in thread

From: John Chapman @ 2003-02-04 03:23 UTC (permalink / raw)
  To: pgsql-general@postgresql.org



> 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



^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 03:28  Jessica Blank <jessica@starchefs.com>
  parent: John Chapman <johnc@cniconsulting.com>
  1 sibling, 6 replies; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 03:28 UTC (permalink / raw)
  To: John Chapman <johnc@cniconsulting.com>; +Cc: pgsql-general@postgresql.org

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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 03:34  Timothy Brier <briert@cepu.ca>
  parent: Jessica Blank <jessica@starchefs.com>
  5 siblings, 2 replies; 29+ messages in thread

From: Timothy Brier @ 2003-02-04 03:34 UTC (permalink / raw)
  To: pgsql <pgsql-general@postgresql.org>

I had this problem when I upgraded from 7.3.0 to 7.3.1.  
I use RedHat 8.0.  I do not have libpq.so.2 on the system.

I used the following command:

ln /usr/lib/libpg.so.3   /usr/lib/libpg.so.2 -s

Restarted Apache, and everything worked fine.


Tim.


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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to
@ 2003-02-04 03:38  Rudi Starcevic <rudi@oasis.net.au>
  parent: Jessica Blank <jessica@starchefs.com>
  3 siblings, 2 replies; 29+ messages in thread

From: Rudi Starcevic @ 2003-02-04 03:38 UTC (permalink / raw)
  To: Jessica Blank <jessica@starchefs.com>; +Cc: pgsql-php

Jessica,

Maybe all you need to do is create a soft link ?

Eg. ln -s libpq.so.3 libpq.so.2

Hope this helps
Regards
Rudi.

Jessica Blank 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?
>
>What can I do? I try ./configure'ing PHP, but it tells me:                      
>gcc -o conftest -g -O2  -I/usr/pkg/include  -L/usr/pkg/lib
>-R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c -lpq -lcrypt
>-lm  -lcrypt 1>&5
>Shared object "libpq.so.2" not found                                
>
>Complete debug.log installed.
>
>PLEASE help...
>
>							--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 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>  
>






^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to
@ 2003-02-04 03:42  Jessica Blank <jessica@starchefs.com>
  parent: Rudi Starcevic <rudi@oasis.net.au>
  1 sibling, 1 reply; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 03:42 UTC (permalink / raw)
  To: Rudi Starcevic <rudi@oasis.net.au>; +Cc: pgsql-php

I considered that, but I am afraid to do it. What if libpq.so.3 and
libpq.so.2 are not compatible?

On Tue, 4 Feb 2003, Rudi Starcevic wrote:

> Jessica,
> 
> Maybe all you need to do is create a soft link ?
> 
> Eg. ln -s libpq.so.3 libpq.so.2
> 
> Hope this helps
> Regards
> Rudi.
> 
> Jessica Blank 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?
> >
> >What can I do? I try ./configure'ing PHP, but it tells me:                      
> >gcc -o conftest -g -O2  -I/usr/pkg/include  -L/usr/pkg/lib
> >-R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c -lpq -lcrypt
> >-lm  -lcrypt 1>&5
> >Shared object "libpq.so.2" not found                                
> >
> >Complete debug.log installed.
> >
> >PLEASE help...
> >
> >							--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 2: you can get off all lists at once with the unregister command
> >    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
> >  
> >
> 
> 
> 
> 


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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 03:44  Jessica Blank <jessica@starchefs.com>
  parent: Timothy Brier <briert@cepu.ca>
  1 sibling, 0 replies; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 03:44 UTC (permalink / raw)
  To: Timothy Brier <briert@cepu.ca>; +Cc: pgsql <pgsql-general@postgresql.org>

So this is safe?

...Shouldn't PostgreSQL-latest work *OUT OF THE BOX* with PHP-latest (and
ideally several previous versions as well)??? If all that's needed for a
fix is a symlink, shouldn't the symlink be made by the install process
itself?


On Mon, 3 Feb 2003, Timothy Brier wrote:

> I had this problem when I upgraded from 7.3.0 to 7.3.1.  
> I use RedHat 8.0.  I do not have libpq.so.2 on the system.
> 
> I used the following command:
> 
> ln /usr/lib/libpg.so.3   /usr/lib/libpg.so.2 -s
> 
> Restarted Apache, and everything worked fine.
> 
> 
> Tim.
> 
> 
> 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
> >
> >  
> >
> 
> 
> 
> ---------------------------(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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to
@ 2003-02-04 03:47  Rudi Starcevic <rudi@oasis.net.au>
  parent: Jessica Blank <jessica@starchefs.com>
  0 siblings, 1 reply; 29+ messages in thread

From: Rudi Starcevic @ 2003-02-04 03:47 UTC (permalink / raw)
  To: Jessica Blank <jessica@starchefs.com>; +Cc: pgsql-php

Jessica,

I think they will be compatible.
It won't hurt to try.

It there is a problem just remove the link you created and try something 
else.

Regards
Rudi.


Jessica Blank wrote:

>I considered that, but I am afraid to do it. What if libpq.so.3 and
>libpq.so.2 are not compatible?
>
>On Tue, 4 Feb 2003, Rudi Starcevic wrote:
>
>  
>
>>Jessica,
>>
>>Maybe all you need to do is create a soft link ?
>>
>>Eg. ln -s libpq.so.3 libpq.so.2
>>
>>Hope this helps
>>Regards
>>Rudi.
>>
>>Jessica Blank 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?
>>>
>>>What can I do? I try ./configure'ing PHP, but it tells me:                      
>>>gcc -o conftest -g -O2  -I/usr/pkg/include  -L/usr/pkg/lib
>>>-R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c -lpq -lcrypt
>>>-lm  -lcrypt 1>&5
>>>Shared object "libpq.so.2" not found                                
>>>
>>>Complete debug.log installed.
>>>
>>>PLEASE help...
>>>
>>>							--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 2: you can get off all lists at once with the unregister command
>>>   (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>>>
>>> 
>>>
>>>      
>>>
>>
>>
>>    
>>
>
>
>							--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
>
>
>  
>






^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 03:47  Jeff Ross <jross@openvistas.net>
  parent: Jessica Blank <jessica@starchefs.com>
  5 siblings, 1 reply; 29+ messages in thread

From: Jeff Ross @ 2003-02-04 03:47 UTC (permalink / raw)
  To: Jessica Blank <jessica@starchefs.com>; +Cc: John Chapman <johnc@cniconsulting.com>; pgsql-general@postgresql.org

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
>
[jross@rand.openvistas.net] $  ls -al /usr/local/pgsql/lib/
total 7364
drwxr-xr-x  2 root  wheel     1024 Jan 24 21:12 .
drwxr-xr-x  8 root  wheel      512 Jan 24 21:11 ..
-rwxr-xr-x  1 root  wheel     8430 Jan 24 21:11 ascii_and_mic.so
-rwxr-xr-x  1 root  wheel    13640 Jan 24 21:11 cyrillic_and_mic.so
-rwxr-xr-x  1 root  wheel     8434 Jan 24 21:11 euc_cn_and_mic.so
-rwxr-xr-x  1 root  wheel     8682 Jan 24 21:11 euc_jp_and_sjis.so
-rwxr-xr-x  1 root  wheel     8434 Jan 24 21:11 euc_kr_and_mic.so
-rwxr-xr-x  1 root  wheel     8728 Jan 24 21:11 euc_tw_and_big5.so
-rwxr-xr-x  1 root  wheel     8706 Jan 24 21:11 latin2_and_win1250.so
-rwxr-xr-x  1 root  wheel     8686 Jan 24 21:11 latin_and_mic.so
-rw-r--r--  1 root  wheel    42336 Jan 24 21:11 libecpg.a
lrwxr-xr-x  1 root  wheel       16 Jan 24 21:11 libecpg.so ->
libecpg.so.3.4.1
lrwxr-xr-x  1 root  wheel       16 Jan 24 21:11 libecpg.so.3 ->
libecpg.so.3.4.1
-rwxr-xr-x  1 root  wheel    37950 Jan 24 21:11 libecpg.so.3.4.1
-rw-r--r--  1 root  wheel    92182 Jan 24 21:11 libpq.a
lrwxr-xr-x  1 root  wheel       12 Jan 24 21:11 libpq.so -> libpq.so.3.0
lrwxr-xr-x  1 root  wheel       12 Jan 24 21:11 libpq.so.3 -> libpq.so.3.0
-rwxr-xr-x  1 root  wheel    77866 Jan 24 21:11 libpq.so.3.0
-rwxr-xr-x  1 root  wheel    88277 Jan 24 21:12 plpgsql.so
-rwxr-xr-x  1 root  wheel     8434 Jan 24 21:11 utf8_and_ascii.so
-rwxr-xr-x  1 root  wheel   225518 Jan 24 21:11 utf8_and_big5.so
-rwxr-xr-x  1 root  wheel    12782 Jan 24 21:11 utf8_and_cyrillic.so
-rwxr-xr-x  1 root  wheel   127222 Jan 24 21:11 utf8_and_euc_cn.so
-rwxr-xr-x  1 root  wheel   217334 Jan 24 21:11 utf8_and_euc_jp.so
-rwxr-xr-x  1 root  wheel   139510 Jan 24 21:11 utf8_and_euc_kr.so
-rwxr-xr-x  1 root  wheel   336118 Jan 24 21:11 utf8_and_euc_tw.so
-rwxr-xr-x  1 root  wheel  1020154 Jan 24 21:11 utf8_and_gb18030.so
-rwxr-xr-x  1 root  wheel   356586 Jan 24 21:11 utf8_and_gbk.so
-rwxr-xr-x  1 root  wheel    33018 Jan 24 21:11 utf8_and_iso8859.so
-rwxr-xr-x  1 root  wheel     8450 Jan 24 21:11 utf8_and_iso8859_1.so
-rwxr-xr-x  1 root  wheel   278770 Jan 24 21:11 utf8_and_johab.so
-rwxr-xr-x  1 root  wheel   127214 Jan 24 21:11 utf8_and_sjis.so
-rwxr-xr-x  1 root  wheel     8430 Jan 24 21:11 utf8_and_tcvn.so
-rwxr-xr-x  1 root  wheel   278762 Jan 24 21:11 utf8_and_uhc.so
-rwxr-xr-x  1 root  wheel     8438 Jan 24 21:11 utf8_and_win1250.so
-rwxr-xr-x  1 root  wheel     8438 Jan 24 21:11 utf8_and_win1256.so
-rwxr-xr-x  1 root  wheel     8434 Jan 24 21:11 utf8_and_win874.so


[jross@rand.openvistas.net] $ php -v
PHP 4.3.0 (cgi), Copyright (c) 1997-2002 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2002 Zend Technologies

[jross@rand.openvistas.net] $ uname -a
OpenBSD rand.openvistas.net 3.2 GENERIC#0 i386

This is a fresh install, compiling both from source.  Working great in CGI
versions, since I don't run Apache.


-- 
Jeff Ross
Open Vistas Networking, Inc.
http://www.openvistas.net





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 03:48  Mitch <postgresql@karboneye.com>
  parent: Jessica Blank <jessica@starchefs.com>
  5 siblings, 0 replies; 29+ messages in thread

From: Mitch @ 2003-02-04 03:48 UTC (permalink / raw)
  To: Jessica Blank <jessica@starchefs.com>; +Cc: pgsql-general@postgresql.org

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

Compile and install PostgreSQL 7.3.1

ldconfig -m /usr/local/pgsql/lib (or whatever)
(If you're on FreeBSD. If not,  look up the right command for your OS)

compile and install PHP :-)

> 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. ;) )

If the older lib is getting in your way - remove it..

I'm almost positive that in the 7.3.1 install docs was very clear about 
having to recompile everything that linked to libpq.

Good luck!

-Mitch




^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to
@ 2003-02-04 03:49  Jessica Blank <jessica@starchefs.com>
  parent: Rudi Starcevic <rudi@oasis.net.au>
  0 siblings, 0 replies; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 03:49 UTC (permalink / raw)
  To: Rudi Starcevic <rudi@oasis.net.au>; +Cc: pgsql-php

On Tue, 4 Feb 2003, Rudi Starcevic wrote:

> Jessica,
> 
> I think they will be compatible.
> It won't hurt to try.
> 
> It there is a problem just remove the link you created and try something 
> else.

I don't know what else I COULD try... besides compiling 7.3.0 and
installing ITS libpq.so.2 as well as 7.3.1's libpq.so.3 .... a real
"Band-aid" solution.

> 
> Regards
> Rudi.
> 
> 
> Jessica Blank wrote:
> 
> >I considered that, but I am afraid to do it. What if libpq.so.3 and
> >libpq.so.2 are not compatible?
> >
> >On Tue, 4 Feb 2003, Rudi Starcevic wrote:
> >
> >  
> >
> >>Jessica,
> >>
> >>Maybe all you need to do is create a soft link ?
> >>
> >>Eg. ln -s libpq.so.3 libpq.so.2
> >>
> >>Hope this helps
> >>Regards
> >>Rudi.
> >>
> >>Jessica Blank 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?
> >>>
> >>>What can I do? I try ./configure'ing PHP, but it tells me:                      
> >>>gcc -o conftest -g -O2  -I/usr/pkg/include  -L/usr/pkg/lib
> >>>-R/usr/local/pgsql//lib -L/usr/local/pgsql//lib conftest.c -lpq -lcrypt
> >>>-lm  -lcrypt 1>&5
> >>>Shared object "libpq.so.2" not found                                
> >>>
> >>>Complete debug.log installed.
> >>>
> >>>PLEASE help...
> >>>
> >>>							--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 2: you can get off all lists at once with the unregister command
> >>>   (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >>>
> >>> 
> >>>
> >>>      
> >>>
> >>
> >>
> >>    
> >>
> >
> >
> >							--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
> >
> >
> >  
> >
> 
> 
> 
> 


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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 03:49  Jessica Blank <jessica@starchefs.com>
  parent: Jeff Ross <jross@openvistas.net>
  0 siblings, 0 replies; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 03:49 UTC (permalink / raw)
  To: Jeff Ross <jross@openvistas.net>; +Cc: John Chapman <johnc@cniconsulting.com>; pgsql-general@postgresql.org

That is quite bizarre. Do you by any chance have record of the parameters
you used for ./configure on PHP and on PostgreSQL?

On Mon, 3 Feb 2003, Jeff Ross wrote:

> 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
> >
> [jross@rand.openvistas.net] $  ls -al /usr/local/pgsql/lib/
> total 7364
> drwxr-xr-x  2 root  wheel     1024 Jan 24 21:12 .
> drwxr-xr-x  8 root  wheel      512 Jan 24 21:11 ..
> -rwxr-xr-x  1 root  wheel     8430 Jan 24 21:11 ascii_and_mic.so
> -rwxr-xr-x  1 root  wheel    13640 Jan 24 21:11 cyrillic_and_mic.so
> -rwxr-xr-x  1 root  wheel     8434 Jan 24 21:11 euc_cn_and_mic.so
> -rwxr-xr-x  1 root  wheel     8682 Jan 24 21:11 euc_jp_and_sjis.so
> -rwxr-xr-x  1 root  wheel     8434 Jan 24 21:11 euc_kr_and_mic.so
> -rwxr-xr-x  1 root  wheel     8728 Jan 24 21:11 euc_tw_and_big5.so
> -rwxr-xr-x  1 root  wheel     8706 Jan 24 21:11 latin2_and_win1250.so
> -rwxr-xr-x  1 root  wheel     8686 Jan 24 21:11 latin_and_mic.so
> -rw-r--r--  1 root  wheel    42336 Jan 24 21:11 libecpg.a
> lrwxr-xr-x  1 root  wheel       16 Jan 24 21:11 libecpg.so ->
> libecpg.so.3.4.1
> lrwxr-xr-x  1 root  wheel       16 Jan 24 21:11 libecpg.so.3 ->
> libecpg.so.3.4.1
> -rwxr-xr-x  1 root  wheel    37950 Jan 24 21:11 libecpg.so.3.4.1
> -rw-r--r--  1 root  wheel    92182 Jan 24 21:11 libpq.a
> lrwxr-xr-x  1 root  wheel       12 Jan 24 21:11 libpq.so -> libpq.so.3.0
> lrwxr-xr-x  1 root  wheel       12 Jan 24 21:11 libpq.so.3 -> libpq.so.3.0
> -rwxr-xr-x  1 root  wheel    77866 Jan 24 21:11 libpq.so.3.0
> -rwxr-xr-x  1 root  wheel    88277 Jan 24 21:12 plpgsql.so
> -rwxr-xr-x  1 root  wheel     8434 Jan 24 21:11 utf8_and_ascii.so
> -rwxr-xr-x  1 root  wheel   225518 Jan 24 21:11 utf8_and_big5.so
> -rwxr-xr-x  1 root  wheel    12782 Jan 24 21:11 utf8_and_cyrillic.so
> -rwxr-xr-x  1 root  wheel   127222 Jan 24 21:11 utf8_and_euc_cn.so
> -rwxr-xr-x  1 root  wheel   217334 Jan 24 21:11 utf8_and_euc_jp.so
> -rwxr-xr-x  1 root  wheel   139510 Jan 24 21:11 utf8_and_euc_kr.so
> -rwxr-xr-x  1 root  wheel   336118 Jan 24 21:11 utf8_and_euc_tw.so
> -rwxr-xr-x  1 root  wheel  1020154 Jan 24 21:11 utf8_and_gb18030.so
> -rwxr-xr-x  1 root  wheel   356586 Jan 24 21:11 utf8_and_gbk.so
> -rwxr-xr-x  1 root  wheel    33018 Jan 24 21:11 utf8_and_iso8859.so
> -rwxr-xr-x  1 root  wheel     8450 Jan 24 21:11 utf8_and_iso8859_1.so
> -rwxr-xr-x  1 root  wheel   278770 Jan 24 21:11 utf8_and_johab.so
> -rwxr-xr-x  1 root  wheel   127214 Jan 24 21:11 utf8_and_sjis.so
> -rwxr-xr-x  1 root  wheel     8430 Jan 24 21:11 utf8_and_tcvn.so
> -rwxr-xr-x  1 root  wheel   278762 Jan 24 21:11 utf8_and_uhc.so
> -rwxr-xr-x  1 root  wheel     8438 Jan 24 21:11 utf8_and_win1250.so
> -rwxr-xr-x  1 root  wheel     8438 Jan 24 21:11 utf8_and_win1256.so
> -rwxr-xr-x  1 root  wheel     8434 Jan 24 21:11 utf8_and_win874.so
> 
> 
> [jross@rand.openvistas.net] $ php -v
> PHP 4.3.0 (cgi), Copyright (c) 1997-2002 The PHP Group
> Zend Engine v1.3.0, Copyright (c) 1998-2002 Zend Technologies
> 
> [jross@rand.openvistas.net] $ uname -a
> OpenBSD rand.openvistas.net 3.2 GENERIC#0 i386
> 
> This is a fresh install, compiling both from source.  Working great in CGI
> versions, since I don't run Apache.
> 
> 
> -- 
> Jeff Ross
> Open Vistas Networking, Inc.
> http://www.openvistas.net
> 
> 
> 


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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 03:52  Mitch <postgresql@karboneye.com>
  parent: Timothy Brier <briert@cepu.ca>
  1 sibling, 0 replies; 29+ messages in thread

From: Mitch @ 2003-02-04 03:52 UTC (permalink / raw)
  To: Timothy Brier <briert@cepu.ca>; +Cc: pgsql <pgsql-general@postgresql.org>

That's a pretty bad idea.. You need to recompile everything that links 
to libpq (as stated in the 7.3.1 docs).

They wouldn't have changed the version number if they hadn't changed 
the API...

> I had this problem when I upgraded from 7.3.0 to 7.3.1.  I use RedHat 
> 8.0.  I do not have libpq.so.2 on the system.
>
> I used the following command:
>
> ln /usr/lib/libpg.so.3   /usr/lib/libpg.so.2 -s
>
> Restarted Apache, and everything worked fine.
>
>
> Tim.
>

-Mitch




^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 03:52  Philip Hallstrom <philip@adhesivemedia.com>
  parent: Jessica Blank <jessica@starchefs.com>
  5 siblings, 1 reply; 29+ messages in thread

From: Philip Hallstrom @ 2003-02-04 03:52 UTC (permalink / raw)
  To: Jessica Blank <jessica@starchefs.com>; +Cc: John Chapman <johnc@cniconsulting.com>; pgsql-general@postgresql.org

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
>




^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 03:56  Jessica Blank <jessica@starchefs.com>
  parent: Philip Hallstrom <philip@adhesivemedia.com>
  0 siblings, 1 reply; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 03:56 UTC (permalink / raw)
  To: Philip Hallstrom <philip@adhesivemedia.com>; +Cc: John Chapman <johnc@cniconsulting.com>; pgsql-general@postgresql.org

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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])
@ 2003-02-04 03:57  Lamar Owen <lamar.owen@wgcr.org>
  parent: Jessica Blank <jessica@starchefs.com>
  3 siblings, 1 reply; 29+ messages in thread

From: Lamar Owen @ 2003-02-04 03:57 UTC (permalink / raw)
  To: Jessica Blank <jessica@starchefs.com>; pgsql-general@postgresql.org; pgsql-php

On Monday 03 February 2003 22:12, Jessica Blank 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
> ...

Recompile PHP, and it will work.  If you got it as an RPM, get the source 
(src.rpm) RPM and issue a 'rpmbuild --rebuild php....src.rpm' (substitute the 
version and other information for the dots above...).
-- 
Lamar Owen
WGCR Internet Radio
1 Peter 4:11




^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 03:57  John Chapman <johnc@cniconsulting.com>
  parent: John Chapman <johnc@cniconsulting.com>
  1 sibling, 0 replies; 29+ messages in thread

From: John Chapman @ 2003-02-04 03:57 UTC (permalink / raw)
  To: pgsql-general@postgresql.org



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

It illustrates that they are compatible.

> 
> 1) How can I do the same?

I don't know.

> 2) Were you previously using PostgreSQL 7.3.0?

No.

 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. ;) )
> 


You are jumping to assumptions here. Probably in your troubleshooting 
as well. However, this was a fresh install of Slackware 8.1, fresh 
install of apache, fresh install of php. I merely followed the 
documentation. 


John Chapman
CNI Consulting
johnc@cniconsulting.com
www.cniemail.com
817-774-0369



^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due
@ 2003-02-04 03:59  Jessica Blank <jessica@starchefs.com>
  parent: Lamar Owen <lamar.owen@wgcr.org>
  0 siblings, 1 reply; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 03:59 UTC (permalink / raw)
  To: Lamar Owen <lamar.owen@wgcr.org>; +Cc: pgsql-general@postgresql.org; pgsql-php

I am using NetBSD 1.6 on a PowerMac. ;)

And I did compile PHP -after- Postgres. :/

On Mon, 3 Feb 2003, Lamar Owen wrote:

> On Monday 03 February 2003 22:12, Jessica Blank 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
> > ...
> 
> Recompile PHP, and it will work.  If you got it as an RPM, get the source 
> (src.rpm) RPM and issue a 'rpmbuild --rebuild php....src.rpm' (substitute the 
> version and other information for the dots above...).
> -- 
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11
> 
> 


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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 04:00  Justin Clift <justin@postgresql.org>
  parent: Jessica Blank <jessica@starchefs.com>
  5 siblings, 2 replies; 29+ messages in thread

From: Justin Clift @ 2003-02-04 04:00 UTC (permalink / raw)
  To: Jessica Blank <jessica@starchefs.com>; +Cc: John Chapman <johnc@cniconsulting.com>; pgsql-general@postgresql.org

Hi Jessica,

Timothy's solution of creating a symlink from the expected file to the 
actual file should work for you.

# ln  -s [the path to the libpg.so.3 file] [the path to where the 
libpg.so.3 is, but with libpg.so.2 instead]

i.e.
# ln -s /usr/local/lib/libpg.so.3 /usr/local/lib/libpg.so.2
or
# ln -s /usr/lib/libpg.so.3 /usr/lib/libpg.so.2
or
# ln -s /opt/pgsql/lib/libpg.so.3 /opt/pgsql/lib/libpg.so.2

You get the idea.

:-)

Regards and best wishes,

Justin Clift

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi




^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])
@ 2003-02-04 04:05  Lamar Owen <lamar.owen@wgcr.org>
  parent: Jessica Blank <jessica@starchefs.com>
  0 siblings, 2 replies; 29+ messages in thread

From: Lamar Owen @ 2003-02-04 04:05 UTC (permalink / raw)
  To: Jessica Blank <jessica@starchefs.com>; +Cc: pgsql-general@postgresql.org; pgsql-php

On Monday 03 February 2003 22:59, Jessica Blank wrote:
> I am using NetBSD 1.6 on a PowerMac. ;)
>
> And I did compile PHP -after- Postgres. :/

Are you sure it picked up the right headers?  Is there an older PostgreSQL on 
the system?  Are you absolutely sure that you compiled PHP against PostgreSQL 
7.3.1?  The fact is that others aren't able to reproduce the problem; further 
it is a known fact that prior to 7.3.1 the right version was .2, but at 7.3.1 
the version number was bumped to .3.  So at some point in your PHP build the 
linker linked against the development headers/libs for .2 instead of .3.  
Something is telling the PHP build to look for the older version.

As no one else can reproduce it, it must be something unique to your 
installation, at some point.

Do a 'find / -name 'libpq*' -print' and see if libpq-fe.h shows up in more 
than one place.
-- 
Lamar Owen
WGCR Internet Radio
1 Peter 4:11




^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 04:07  Jessica Blank <jessica@starchefs.com>
  parent: Justin Clift <justin@postgresql.org>
  1 sibling, 0 replies; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 04:07 UTC (permalink / raw)
  To: Justin Clift <justin@postgresql.org>; +Cc: John Chapman <johnc@cniconsulting.com>; pgsql-general@postgresql.org

Thank you! Yes, I do know how to symlink ;) I have been using Unix for
many many years. I am just continually amazed at how often I try using
$MAJOR_OSS/FS_SOFTWARE_PACKAGE_X together with
$MAJOR_OSS/FS_SOFTWARE_PACKAGE_Y, and they puke, right out of the box. And
then I need to figure out why.

Of course, you don't have this problem if you just use Red Hat for x86
like the rest of everyone, but ... why? Anyhow. End rant mode.

On Tue, 4 Feb 2003, Justin Clift wrote:

> Hi Jessica,
> 
> Timothy's solution of creating a symlink from the expected file to the 
> actual file should work for you.
> 
> # ln  -s [the path to the libpg.so.3 file] [the path to where the 
> libpg.so.3 is, but with libpg.so.2 instead]
> 
> i.e.
> # ln -s /usr/local/lib/libpg.so.3 /usr/local/lib/libpg.so.2
> or
> # ln -s /usr/lib/libpg.so.3 /usr/lib/libpg.so.2
> or
> # ln -s /opt/pgsql/lib/libpg.so.3 /opt/pgsql/lib/libpg.so.2
> 
> You get the idea.
> 
> :-)
> 
> Regards and best wishes,
> 
> Justin Clift
> 
> -- 
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
> - Indira Gandhi
> 
> 


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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due
@ 2003-02-04 04:09  Jessica Blank <jessica@starchefs.com>
  parent: Lamar Owen <lamar.owen@wgcr.org>
  1 sibling, 0 replies; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 04:09 UTC (permalink / raw)
  To: Lamar Owen <lamar.owen@wgcr.org>; +Cc: pgsql-general@postgresql.org; pgsql-php

On Mon, 3 Feb 2003, Lamar Owen wrote:

> On Monday 03 February 2003 22:59, Jessica Blank wrote:
> > I am using NetBSD 1.6 on a PowerMac. ;)
> >
> > And I did compile PHP -after- Postgres. :/
> 
> Are you sure it picked up the right headers?  Is there an older PostgreSQL on 
> the system?  Are you absolutely sure that you compiled PHP against PostgreSQL 
> 7.3.1?  The fact is that others aren't able to reproduce the problem; further 
> it is a known fact that prior to 7.3.1 the right version was .2, but at 7.3.1 
> the version number was bumped to .3.  So at some point in your PHP build the 
> linker linked against the development headers/libs for .2 instead of .3.  
> Something is telling the PHP build to look for the older version.
> 

Shouldn't be. I think this is the only version of PostgreSQL on the
system...

> As no one else can reproduce it, it must be something unique to your 
> installation, at some point.
> 
> Do a 'find / -name 'libpq*' -print' and see if libpq-fe.h shows up in more 
> than one place.

Glug.

> -- 
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11
> 
> 


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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due
@ 2003-02-04 04:10  Jessica Blank <jessica@starchefs.com>
  parent: Lamar Owen <lamar.owen@wgcr.org>
  1 sibling, 0 replies; 29+ messages in thread

From: Jessica Blank @ 2003-02-04 04:10 UTC (permalink / raw)
  To: Lamar Owen <lamar.owen@wgcr.org>; +Cc: pgsql-general@postgresql.org; pgsql-php

Inexplicably, it works now, out of nowhere. >sigh< Go figure.

My thanks to those who responded to my problem so quickly! Y'all are
wonderful. I just wish modern software weren't so insanely complex...

On Mon, 3 Feb 2003, Lamar Owen wrote:

> On Monday 03 February 2003 22:59, Jessica Blank wrote:
> > I am using NetBSD 1.6 on a PowerMac. ;)
> >
> > And I did compile PHP -after- Postgres. :/
> 
> Are you sure it picked up the right headers?  Is there an older PostgreSQL on 
> the system?  Are you absolutely sure that you compiled PHP against PostgreSQL 
> 7.3.1?  The fact is that others aren't able to reproduce the problem; further 
> it is a known fact that prior to 7.3.1 the right version was .2, but at 7.3.1 
> the version number was bumped to .3.  So at some point in your PHP build the 
> linker linked against the development headers/libs for .2 instead of .3.  
> Something is telling the PHP build to look for the older version.
> 
> As no one else can reproduce it, it must be something unique to your 
> installation, at some point.
> 
> Do a 'find / -name 'libpq*' -print' and see if libpq-fe.h shows up in more 
> than one place.
> -- 
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11
> 
> 


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





^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 04:46  Chris Travers <chris@travelamericas.com>
  parent: Jessica Blank <jessica@starchefs.com>
  0 siblings, 0 replies; 29+ messages in thread

From: Chris Travers @ 2003-02-04 04:46 UTC (permalink / raw)
  To: Jessica Blank <jessica@starchefs.com>; +Cc: Philip Hallstrom <philip@adhesivemedia.com>; John Chapman <johnc@cniconsulting.com>; pgsql-general@postgresql.org

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






^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 04:51  Lee Harr <missive@frontiernet.net>
  parent: Jessica Blank <jessica@starchefs.com>
  5 siblings, 0 replies; 29+ messages in thread

From: Lee Harr @ 2003-02-04 04:51 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

In article <Pine.GSO.4.05.10302032225270.14859-100000@knife.starchefs.com>:
> 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?

I do not run php, but how about rebuilding it from source?
That will probably pick up the new library and link it in.




^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 06:30  Neil Conway <neilc@samurai.com>
  parent: Justin Clift <justin@postgresql.org>
  1 sibling, 1 reply; 29+ messages in thread

From: Neil Conway @ 2003-02-04 06:30 UTC (permalink / raw)
  To: Justin Clift <justin@postgresql.org>; +Cc: Jessica Blank <jessica@starchefs.com>; John Chapman <johnc@cniconsulting.com>; PostgreSQL General <pgsql-general@postgresql.org>

On Mon, 2003-02-03 at 23:00, Justin Clift wrote:
> Timothy's solution of creating a symlink from the expected file to the 
> actual file should work for you.

That doesn't make it any less of a bad idea: the .so version number was
bumped for a reason (namely, that libpq.so.2 and libpq.so.3 aren't
binary compatible).

Cheers,

Neil
-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC






^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4
@ 2003-02-04 07:43  Nigel J. Andrews <nandrews@investsystems.co.uk>
  parent: Neil Conway <neilc@samurai.com>
  0 siblings, 0 replies; 29+ messages in thread

From: Nigel J. Andrews @ 2003-02-04 07:43 UTC (permalink / raw)
  To: Neil Conway <neilc@samurai.com>; +Cc: Justin Clift <justin@postgresql.org>; Jessica Blank <jessica@starchefs.com>; John Chapman <johnc@cniconsulting.com>; PostgreSQL General <pgsql-general@postgresql.org>

On 4 Feb 2003, Neil Conway wrote:

> On Mon, 2003-02-03 at 23:00, Justin Clift wrote:
> > Timothy's solution of creating a symlink from the expected file to the 
> > actual file should work for you.
> 
> That doesn't make it any less of a bad idea: the .so version number was
> bumped for a reason (namely, that libpq.so.2 and libpq.so.3 aren't
> binary compatible).
> 
> Cheers,
> 
> Neil

But to complicate matters; the libpq.so.2 from 7.3.0 _is_ compatible with
libpq.so.3 isn't it? I thought the version number bump was an oversight in 7.3.


-- 
Nigel J. Andrews




^ permalink  raw  reply  [nested|flat] 29+ messages in thread

* Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to
@ 2003-02-05 12:43  Martin Marques <martin@bugs.unl.edu.ar>
  parent: Rudi Starcevic <rudi@oasis.net.au>
  1 sibling, 0 replies; 29+ messages in thread

From: Martin Marques @ 2003-02-05 12:43 UTC (permalink / raw)
  To: Rudi Starcevic <rudi@oasis.net.au>; Jessica Blank <jessica@starchefs.com>; +Cc: pgsql-php

On Mar 04 Feb 2003 00:38, Rudi Starcevic wrote:
> Jessica,
>
> Maybe all you need to do is create a soft link ?
>
> Eg. ln -s libpq.so.3 libpq.so.2

This will not work. libpq changed (that's why there's a change in the version 
too). Recompile PHP, as was told in the announcemente of PostgreSQL-7.3

Saludos... :-)

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------




^ permalink  raw  reply  [nested|flat] 29+ messages in thread


end of thread, other threads:[~2003-02-05 12:43 UTC | newest]

Thread overview: 29+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-04 03:12 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23]) Jessica Blank <jessica@starchefs.com>
2003-02-04 03:13 ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to Jessica Blank <jessica@starchefs.com>
2003-02-04 03:23 ` John Chapman <johnc@cniconsulting.com>
2003-02-04 03:28   ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Jessica Blank <jessica@starchefs.com>
2003-02-04 03:34     ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Timothy Brier <briert@cepu.ca>
2003-02-04 03:44       ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Jessica Blank <jessica@starchefs.com>
2003-02-04 03:52       ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Mitch <postgresql@karboneye.com>
2003-02-04 03:47     ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Jeff Ross <jross@openvistas.net>
2003-02-04 03:49       ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Jessica Blank <jessica@starchefs.com>
2003-02-04 03:48     ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Mitch <postgresql@karboneye.com>
2003-02-04 03:52     ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Philip Hallstrom <philip@adhesivemedia.com>
2003-02-04 03:56       ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Jessica Blank <jessica@starchefs.com>
2003-02-04 04:46         ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Chris Travers <chris@travelamericas.com>
2003-02-04 04:00     ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Justin Clift <justin@postgresql.org>
2003-02-04 04:07       ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Jessica Blank <jessica@starchefs.com>
2003-02-04 06:30       ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Neil Conway <neilc@samurai.com>
2003-02-04 07:43         ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Nigel J. Andrews <nandrews@investsystems.co.uk>
2003-02-04 04:51     ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 Lee Harr <missive@frontiernet.net>
2003-02-04 03:57   ` Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 John Chapman <johnc@cniconsulting.com>
2003-02-04 03:38 ` Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to Rudi Starcevic <rudi@oasis.net.au>
2003-02-04 03:42   ` Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to Jessica Blank <jessica@starchefs.com>
2003-02-04 03:47     ` Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to Rudi Starcevic <rudi@oasis.net.au>
2003-02-04 03:49       ` Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to Jessica Blank <jessica@starchefs.com>
2003-02-05 12:43   ` Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to Martin Marques <martin@bugs.unl.edu.ar>
2003-02-04 03:57 ` Lamar Owen <lamar.owen@wgcr.org>
2003-02-04 03:59   ` Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due Jessica Blank <jessica@starchefs.com>
2003-02-04 04:05     ` Lamar Owen <lamar.owen@wgcr.org>
2003-02-04 04:09       ` Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due Jessica Blank <jessica@starchefs.com>
2003-02-04 04:10       ` Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due Jessica Blank <jessica@starchefs.com>

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