Re: Trying to use PGSql with PHP

on 10/8/00 2:56 AM, Frank Joerdens at frank(at)joerdens(dot)de wrote:

> How did you install PHP & Apache? Did you configure & compile the
> sources or get the rpm's from somewhere? If you're compiling PHP from
> the sources, you need to configure PHP with the --with-pgsql switch. You
> can check whether this is the problem (i.e. missing pgsql support) by
> making a page that just contains <? phpinfo(); ?> which, if opened in a
> browser, should show all the options your PHP supports.
>
> Also, in the Support section of the PHP homepage at www.php.net, you can
> subscribe to a list that is devoted entirely to PHP installation issues.
>
> Regards, Frank
>
> On Sun, Oct 08, 2000 at 01:20:21AM -0400, John Tsombakos wrote:
>> I'm trying to setup PostgreSQL on Redhat Linux 6.2 and access it with PHP. I
>> have Apache installed and working, PHP installed and working, and PostgreSQL
>> installed and working. However, I'm trying to get PHP to talk to the
>> PostgreSQL system. I believe I need to install php-pgsql-3.0.15-2.rpm, but
>> when I try, I get an error saying the that package depends on
>> 'libpq.so.2.0'. I have PostgreSQL v7.0.2 (all of the RPMS's) and PHP 3.0.15
>> installed.
>>
>> What am I missing? I'm a bit of a newbie with Linux, so any help will be
>> grateful!
>>
>> Thanks,
>> --------------------------------
>> John Tsombakos
>> johnts(at)ziplink(dot)net <*>

No, I installed PostgreSQL and PHP with the RPM's, and I believe Apache was
already installed when I installed Redhat.

Please note that PHP _does_ work. I can use PHP commands and it works fine.
It's just when I try to use the PostgreSQL commands, I get an error.

For example, if I do something like:

<?php
$connection=ph_connect("dbname=testdb")
?>

I get an error: "Fatal error: Call to unsupported or undefined function
pg_connect in /home/httpd/html/mypage.php on line 10"

So, PHP works, Apache works, PSQL works by itself, it's just PHP and PSql
don't work and I can't get what I assume is the "missing link"
(php-pgsql-3.0.15-2.rpm) to install.

--------------------------------
John Tsombakos
johnts(at)ziplink(dot)net <*>