Re: [PHP-INSTALL] Can't get PHP to work with postgres

[Barry C . Hawkins]

On Nov 18, 2003, at 7:04 PM, Bengt Hammarlin wrote:

On Tue, 2003-11-18 at 18:28, Barry C.Hawkins wrote:
On Nov 18, 2003, at 5:07 PM, Bengt Hammarlin wrote:

This is getting interesting. It has mysql libraries installed, I must
be
dreaming...
Any idea?
Bengt

On Tue, 2003-11-18 at 15:04, Barry C.Hawkins wrote:
On Nov 18, 2003, at 2:51 PM, Bengt Hammarlin wrote:

Thanx Barry,
but, that did not help at all. The pg_pconnect() function is still
undefined.
Bengt

On Mon, 2003-11-17 at 14:40, Barry C.Hawkins wrote:
On Nov 16, 2003, at 8:51 PM, Bengt Hammarlin wrote:

This is what I do:

cd httpd-2.0.48/                 (apache)
configure
make
cd ../postgresql-7.3.4/
configure
make
make install
cd ../php-4.3.4/
./configure --with-apxs2=/usr/local/apache2/bin/apxs
--with-postgres
make
make install
libtool --finish {path}/php-4.3.4/libs
Then I tar up /usr/local/apache2 and copy to my target machine 
that
does
not have compilers and stuff.
for good measure i toss in /usr/local/postgres as well

When trying my page (that works well in a 
install-from-an-old-RH-CD
environment) I get
Fatal error: Call to undefined function: pg_pconnect() in
{other-path}/connect_db.php on line

I would very much appreciate some good advice.

Bengt Hammarlin



Bengt,
        It looks like you might not have the PostgreSQL configure switch
correct.  If you issue:
	$>./configure --help > phpConfigOptions.txt

and search through the text of that file that is produced, you 
will
find:

   --with-pgsql[=DIR]      Include PostgreSQL support.  DIR is the
PostgreSQL
                           base install directory, defaults to
/usr/local/pgsql.
I used that and my PostgeSQL support is working.

Best wishes,

Bengt,
        Have you tried looking at the results of phpinfo() to see if the
library information matches up with you PostgreSQL installation?
Maybe
that would provide some info.
Regards,
--  
Barry C. Hawkins
All Things Computed
site: www.allthingscomputed.com
weblog: www.yepthatsme.com






What distro and version of Linux are you running?
I am running Mandrake 9.0
Are you able to connect to PostgreSQL with the psql utility?

I believe that specifying --with-pgsql without the =[DIR] (defaults to
/usr/local/pgsql) causes PHP to use its included client libraries for
PostgreSQL similar to MySQL, but I am not certain of that.
I tried with and without specifying [DIR] with no difference whatsoever

Thanx a bunch for trying to help me figure this out

Bengt




Bengt,
	Just to confirm, what was the path you entered for your --with-pgsql 
directive, and have you confirmed that your PostgreSQL is installed 
there?  Also, has your Mandrake install excluded PostgreSQL libraries 
to save space?  This issue reminds me of a problem I had with OpenSSL 
libraries which were excluded on Mac OS X.  I could configure, compile, 
and install, but it would not run.

Keep at it,
--
Barry C. Hawkins
All Things Computed
site: www.allthingscomputed.com
weblog: www.yepthatsme.com