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

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

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

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

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:

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:

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

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

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:

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

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

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

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

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

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:

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

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

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

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

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