sql-ledger requires some specific changes to your Apache config files in order
to work
Please add the following directives to your virtual host config
(usually /etc/apache2/httpd.conf )
echo 'Include /etc/apache2/sql-ledger-httpd.conf' >> /etc/apache2/httpd.conf
Create File in nano /etc/apache2/sql-ledger-httpd.conf:
Alias /sql-ledger /var/www/localhost/htdocs/sql-ledger
AllowOverride All
AddHandler cgi-script .pl
AddDefaultCharset On
Options ExecCGI Includes FollowSymlinks
Order Allow,Deny
Allow from All
Order Deny,Allow
Deny from All
Please then double check that you can't directly access the files via a
webbrowser in the /users directory
NOTE: also that you need to create/edit sql-ledger.conf; the prototype
can be found at ${MY_INSTALLDIR}/sql-ledger.conf.default
Necessary Postgres setup:
su postgres -c 'createuser -d -a sql-ledger'
su postgres -c 'createlang plpgsql template1'
From here, you need to load /sql-ledger/admin.pl . Follow
the instructions at http://www.sql-ledger.com/cgi-bin/nav.pl?page=source/readme.txt&title=README
Revised by turtle 12/30/07