Debian Install

[Admin <ad...@qu...>]

         ---While its still Fresh in my mind-----

                 DEBIAN INSTALL

                  SQL-LEDGER

unpack into /var/www/sql-ledger

                POSTGRESQL

INSTALL   POSTGRES   (Dselect)
INSTALL   LIBPG-DEV   (Dselect)
modify /etc/postgresql/postmaster.init=20
   PGALLOWTCPIP=3Dyes
   PGPORT=3D5432

postgres is default db admin

from root
su postgres

$createuser
name of user- (I created a postgres user who is also a Linux user
                     this user will be  an account manager
                     enable this user to create db and users )
  =20
                  DBD/DBI

DOWNLOAD DBI and DBD-Pg and unpack
my versions DBI-1.2
                  DBD-Pg-1.01=20

$ export POSTGREs_INCLUDE=3D/usr/include/postgresql (no spaces)
$ export POSTGRES_LIB=3D/var/lib/postgres(no spaces)

DB first
    perl Makefile.PL
    make
    make test
    make install

DBI-Pg next

login as account manager (above)
    perl Makefile.PL
    make
    make test
now login as root
    make install

                    APACHE

change /etc/apache/httpd.conf

add AddHandler cgi-script   .pl
        ScriptAlias /sql-ledger/  /var/www/sql-ledger/
        <Directory /var/www/sql-ledger>
         Options ExecCGI Includes FollowSymlinks
        </Directory>

From Browser http://my_domain/sql-ledger/admin.pl
Login as the postgres user (account manager) you have created (above)
Create a DB
Create users
then  http://my_domain/sql-ledger/login.pl
Login as one of the users you have just created

Dont forget to restart services throughout this procedure

Have Fun

Note: I have not used postgresql before and some of these steps
might not be according to Hoyle, but they worked for me

" You Know a propellor is to keep the pilot cool
  because when it stops he starts sweating "


   =20