From owner-freebsd-questions  Thu May 27 13: 0:11 1999
Delivered-To: freebsd-questions@freebsd.org
Received: from lexmark.lexmark.com (interlock2.lexmark.com [192.146.101.10])
	by hub.freebsd.org (Postfix) with SMTP id 4DBAD15901
	for <freebsd-questions@freebsd.org>; Thu, 27 May 1999 12:59:58 -0700 (PDT)
	(envelope-from jfreeze@lexmark.com)
Received: by interlock2.lexmark.com id AA18949
  (InterLock SMTP Gateway 3.0 for freebsd-questions@freebsd.org);
  Thu, 27 May 1999 15:59:56 -0400
Message-Id: <199905271959.AA18949@interlock2.lexmark.com>
Received: by interlock2.lexmark.com (Protected-side Proxy Mail Agent-1);
  Thu, 27 May 1999 15:59:56 -0400
X-Lotus-Fromdomain: LEXMARK@LEXMTA
From: jfreeze@lexmark.com
To: freebsd-questions@freebsd.org
Date: Thu, 27 May 1999 15:58:58 -0400
Subject: How to install Apache+Php3+PostreSQL?
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

With much support from the group I have been able to install postgresql.
apache-php3-1.3.4 was installed with FreeBSD 3.1 from the wccdrom 4 cd set.
I have also been able to access my postgres databases via pgaccess.

Now that I have most of the pieces installed, I have tried to connect to my pg
database using php from within a web page.

Within my simple page I have the following script.

<?php
     echo "In Php<br>";
     $db = pg_connect("","","","mydb");
     $dbName = pg_dbname($db);
     echo $dbName , "\n";
?>

Accessing this page in my browser gives

============
In Php

Fatal error: Call to unsupported or undefined function pg_connect() in
/usr/local/www/data/php1.php3 on line 9.
============

This appears to me that the php module does not have pg db connection compiled
in.
My guess is that the php module needs to be compiled with a pg_ functions
library  or
that there is a seperate module to allow php to access pg databases.
Can someone explain the fundamentals here to me. I would really like to
understand
what is going on.

To upgrade this, I have collected the following files.

apache-php3-1.3.4.tgz   (wccdrom)
apache-1.3.6.tar.gz
php-3.0.7.tar.gz

It doesn't matter to me if I install apache 1.3.6 or 1.3.4. However, I would
like php and pgsql to be
installed as a module.

I have spent several hours reading docs, but installing apache+php+pgsql is
proving to be elusive.

Thanks for any help.

Jim Freeze
jim@freeze.org




To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message