|
From: Admin <ad...@qu...> - 2001-10-10 22:23:18
|
---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
|