Horton

Thread

  1. 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T03:12:11Z

    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

  2. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T03:13:55Z

    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

  3. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])

    John Chapman <johnc@cniconsulting.com> — 2003-02-04T03:23:07Z

    
> 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

  4. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T03:28:47Z

    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

  5. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Tim Brier <briert@cepu.ca> — 2003-02-04T03:34:58Z

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

  6. Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to

    Rudi Starcevic <rudi@oasis.net.au> — 2003-02-04T03:38:33Z

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

  7. Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T03:42:50Z

    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

  8. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T03:44:07Z

    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

  9. Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to

    Rudi Starcevic <rudi@oasis.net.au> — 2003-02-04T03:47:03Z

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

  10. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Jeff Ross <jross@openvistas.net> — 2003-02-04T03:47:53Z

    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

  11. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Mitch <postgresql@karboneye.com> — 2003-02-04T03:48:32Z

    > 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

  12. Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T03:49:08Z

    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

  13. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T03:49:59Z

    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

  14. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Mitch <postgresql@karboneye.com> — 2003-02-04T03:52:18Z

    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

  15. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Philip Hallstrom <philip@adhesivemedia.com> — 2003-02-04T03:52:29Z

    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
>

  16. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T03:56:04Z

    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

  17. Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])

    Lamar Owen <lamar.owen@wgcr.org> — 2003-02-04T03:57:21Z

    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

  18. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    John Chapman <johnc@cniconsulting.com> — 2003-02-04T03:57:33Z

    
> 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

  19. Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T03:59:18Z

    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

  20. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Justin Clift <justin@postgresql.org> — 2003-02-04T04:00:31Z

    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

  21. Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to libpq.so.[23])

    Lamar Owen <lamar.owen@wgcr.org> — 2003-02-04T04:05:42Z

    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

  22. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T04:07:06Z

    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

  23. Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T04:09:08Z

    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

  24. Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due

    Jessica Blank <jessica@starchefs.com> — 2003-02-04T04:10:03Z

    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

  25. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Chris Travers <chris@travelamericas.com> — 2003-02-04T04:46:35Z

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

  26. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Lee Harr <missive@frontiernet.net> — 2003-02-04T04:51:41Z

    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.

  27. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Neil Conway <neilc@samurai.com> — 2003-02-04T06:30:55Z

    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

  28. Re: [PHP] 7.3.1 BREAKS COMPATIBILITY with the latest PHP4

    Nigel J. Andrews <nandrews@investsystems.co.uk> — 2003-02-04T07:43:42Z

    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

  29. Re: 7.3.1 BREAKS COMPATIBILITY with the latest PHP4 (due to

    Martin Marques <martin@bugs.unl.edu.ar> — 2003-02-05T12:43:31Z

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