The information contained in this document describes where
to install the various components for SQL-Ledger.
Various variables are specified in a configuration file sql-ledger.conf.
If the configuration file itself should be in some other location
login.pl and am.pl must be changed to point to the new location.
All the other scripts in the root directory are symlinks,
either soft- or hard-linked, to am.pl.
When running under a SuExec environment the symlinks must be changed to
SQL-Ledger requires perl 5+, DBI, DBD-Pg, DBD-DB2 or DBD-Oracle,
PostgreSQL 7.1+, DB2 8.1 or Oracle 8+.
You will also need a web server such as Apache, thttpd, boa, AOLServer, ...
LaTeX is optional but required for creating forms in postscript
and PDF formats.
PLEASE DO NOT make a dependency for anything but DBI. If someone
runs Oracle and you specify a dependency for PostgreSQL the sysadmin
will be very unhappy!!! Or worse yet, if the SQL server is upgraded
because you specified version such and such. Please use common sense!
Installation paths are for the purpose of showing a configuration.
Follow the filesystem standard for your O/S. SQL-Ledger does
not depend on an absolute location and everything is relative to the
SQL-Ledger root directory.
Install the software somewhere
edit httpd.conf and add
add the file sql-ledger-httpd.conf in /etc/apache2
Contents of sql-ledger-httpd.conf for Apache
Alias /sql-ledger /usr/local/sql-ledger/
AddHandler cgi-script .pl
Options ExecCGI Includes FollowSymlinks
Allow from All
Deny from All
Newer Apache installations use a conf.d directory so the change for httpd.conf
is not required. If there is a conf.d directory simple
copy sql-ledger-httpd.conf into this directory.
The Alias is only used to shorten the URL and is not required if you install
SL in the web server's document root directory.
The AddHandler is not needed if there is already one in httpd.conf.
make the users, templates, css and spool directory writeable for the web
chown apache:apache users css templates spool
the users directory as specified by the variable $userspath is
for creating user specific configuration files and temporary files
for postscript documents.
specify the location for user configuration files and the temporary
create a database user with
"create database" privileges.
set authentication in pg_hba.conf to trust, password or md5
(DO NOT set to crypt)
please see the README.DB2 file
sql-ledger.conf is for the local configuration. If the file is missing
hardcoded defaults will be used instead. To use all the options copy
sql-ledger.conf.default to sql-ledger.conf. DO NOT symlink the file.
The 'members' file will be created when you load admin.pl for the first
The .default files are not required to run SQL-Ledger.