Home > Archive > PHP with PostgreSQL > May 2005 > php5 and Pg 8.0.3 install from sources - problem









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author php5 and Pg 8.0.3 install from sources - problem
michael@softasap.net

2005-05-18, 7:24 am

Environment I am running is as follows:
OS: Fedora Core 3
php5.0.4
Pg 8.0.3


Here is what I did:

1) uninstalled postgres rpm
2) unistalled php rpm

3) compiled from source postgre (more recent version)
4) compiled from source php (more recent version)
5) installed zend optimizer

During step 4, namely when I did make install of php I have got an error of
libpq.so.4 was not found. I copied then it to /usr/lib and make worked. But
when I tried to start apache it has failed to start complaining on libpq.so.4
something like "can't open shared segment: Permission Denied.".

Did anyone experience such problem?

P.S. Postgres itself installed from source just without any problem or warning.
But looks like a problem with its lib libpq.so

Thank you for any help!


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Volkan YAZICI

2005-05-18, 7:24 am

Hi,

On 5/18/05, michael@softasap.net <michael@softasap.net> wrote:
> Environment I am running is as follows:
> OS: Fedora Core 3
> php5.0.4
> Pg 8.0.3
>
> 3) compiled from source postgre (more recent version)
> 4) compiled from source php (more recent version)
> 5) installed zend optimizer
>
> During step 4, namely when I did make install of php I have got an error of
> libpq.so.4 was not found. I copied then it to /usr/lib and make worked. But
> when I tried to start apache it has failed to start complaining on libpq.so.4
> something like "can't open shared segment: Permission Denied.".


In PostgreSQL 8.0.3 release libpq major version number is changed and
this caused libpq dependent programs to break. (Further information:
http://pgfoundry.org/pipermail/pgsq...ril/000197.html)

If I'd return to your situation, it's not so feasible to just move the
libpq.so.4 shared file as a solution. AFAIC, you should re-compile PHP
using correct --with-pgsql directory.

Just pass the --prefix parameter of PostgreSQL ./configure script to
PHP's ./configure script. For instance:
postgresql-8.0.3# export PGSQL_PREFIX=/usr
postgresql-8.0.3# ./configure -- prefix=$PGSQL_PREFIX
...
...
php-5.0.4# ./configure ... --with-pgsql=$PGSQL_PREFIX

Hope this helps.
Regards.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com