How To Install SQL-Ledger on Windows 7

This set of instructions assumes several software versions.

• Strawberry perl 5.12.2
• PostgreSQL 9.0
• Apache 2.2
• SQL Ledger 3.0

1. Download SQL-Ledger
2. untar in c:/Program Files (x86)/Apache Software Foundation/Apache2.2/htdocs
   all the files should now be in the folder "c:/Program Files (x86)/Apache Software Foundation/Apache2.2/htdocs/sql-ledger"
3. rename sql-ledger.conf.default to sql-ledger.conf
4. edit sql-ledger.conf
   comment the following variables
   $sendmail, $latex, $gzip, $dvipdf, $ENV{PATH}
5. create a .htaccess file in "c:/Program Files (x86)/Apache Software Foundation/Apache2.2/htdocs/sql-ledger" and enter
   Options +ExecCGI
6. download the file shebang and save it in "c:/Program Files (x86)/Apache Software Foundation/Apache2.2/htdocs/sql-ledger"
7. if perl.exe is not "c:/strawberry/perl/bin/perl.exe" edit the file and change it to point to the proper location
8. open a CMD console
9. switch directory to "c:/Program Files (x86)/Apache Software Foundation/Apache2.2/htdocs/sql-ledger"
10. enter the command "perl shebang"

1. change access rights from 'md5' to 'password'

Apache

Edit the Apache httpd.conf Configuration File

1. go to the section <Directory "C:/Program Files (x86)/Apache Software Foundation/Apache2.2/htdocs"> and change "AllowOverride None" to "AllowOverride Options"
2. search for "AddHandler cgi-script .cgi" and add another line below
   AddHandler cgi-script .pl

This will get you going however I strongly recommend to look into securing certain directories to disallow access or move these directories and their contents to another location out of reach for the webserver and specify the locations in sql-ledger.conf.

Please see the FAQ for more details.