Thread: Installation of Postgres + PHP

Hi, I followed the instructions at
http://users1.50megs.com/tomcat/postgresql-tutorial/
which describe in very simple terms how to install Postgres and Apache with
PHP support.

It didn't work! The main thing is that PHP didn't have the postgres support
listed in the additional support info.

Does anyone know of similar step by step tutorials for the computer
challenged like myself?
Thanks!

When I installed Apache with PHP support I did the following:
1. Install PostgreSQL RPM's
2. Download apache and PHP source
3. Follow the instructions in the PHP INSTALL file.

By default PHP is NOT compiled with PostgreSQL support, so you have to
remember to do that when you run the configure script in PHP.

Poul L. Christiansen

James Snelling wrote:
>
> Hi, I followed the instructions at
> http://users1.50megs.com/tomcat/postgresql-tutorial/
> which describe in very simple terms how to install Postgres and Apache with
> PHP support.
>
> It didn't work! The main thing is that PHP didn't have the postgres support
> listed in the additional support info.
>
> Does anyone know of similar step by step tutorials for the computer
> challenged like myself?
> Thanks!

On Monday 30 October 2000 08:09, James Snelling wrote:
> Hi, I followed the instructions at
> http://users1.50megs.com/tomcat/postgresql-tutorial/
> which describe in very simple terms how to install Postgres and Apache with
> PHP support.
>
> It didn't work! The main thing is that PHP didn't have the postgres support
> listed in the additional support info.
>
> Does anyone know of similar step by step tutorials for the computer
> challenged like myself?
> Thanks!


1. Install Apache as normal.
2. Install PostgreSQL as normal.
3. Compile and install PHP as an Apache Extension DSO:
(the following is some notes I made when I was installing it)

    APXS (preferred way) - Apache Extension.
        Note: If you use this option, you cannot build the httpd itself
        as a DSO.  I tried it and it would not start when this was
        loaded with it.  If httpd is compiled normally, this works fine
        and is preferrable since it eliminates the need to have to
        recompile apache too just to change database version or
        add some package to php.

    If building as an apache DSO, run ./configure with:
        Note: This assumes that apache is already installed
                (probably with only mod_ssl and mod_rewrite already
                    in there)
        --with-apxs        # Apache eXension utility enables modules
                        # to be compiled independent of the Apache
                        # source.  It should have been installed
                        # in the ../apache/bin directory and should be
                        # in the PATH, else you must use
                        # --with-apxs=/usr/local/apache/bin/apxs
        --with-pgsql
        --without-mysql            #otherwise it gets included by default
        --with-xml
        --enable-track-vars


        Note: postgresql (and/or mysql) must be installed
            first.
    make
    make install

    After making it as a DSO, you must edit the apache httpd.conf
    and check for/add:

        LoadModule php4_module libexec/libphp4.so
        AddType application/x-httpd-php .php
        AddType application/x-httpd-php-source .phps

    Edit /usr/local/lib/php.ini:
        Set the path to sendmail.


--
-------- Robert B. Easter  reaster@comptechnews.com ---------
- CompTechNews Message Board   http://www.comptechnews.com/ -
- CompTechServ Tech Services   http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------