SQL-Ledger - Install on Windows 7

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"


Edit c:/Program Files/PostgreSQL/9.0/data/pg_hba.conf
  1. change access rights from 'md5' to 'password'


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.