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

[Barry C . Hawkins]

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?

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.

Good luck,
--
Barry C. Hawkins
All Things Computed
site: www.allthingscomputed.com
weblog: www.yepthatsme.com