Re: Can't get PHP to work with postgres

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