Re: php5 and Pg 8.0.3 install from sources - problem - Mailing list pgsql-php

From Volkan YAZICI
Subject Re: php5 and Pg 8.0.3 install from sources - problem
Date
Msg-id 7104a7370505180446484395ea@mail.gmail.com
Whole thread Raw
In response to php5 and Pg 8.0.3 install from sources - problem  (michael@softasap.net)
List pgsql-php
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/pgsqlrpms-hackers/2005-April/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.

pgsql-php by date:

Previous
From: michael@softasap.net
Date:
Subject: php5 and Pg 8.0.3 install from sources - problem
Next
From: Ed Finkler
Date:
Subject: Effectiveness of pg_escape_string at blocking SQL injection attacks