Installation

Note: Skip these instructions if your sql-ledger is hosted with us.

Step 1: Download and unpack the sql-ledger.tar.gz in /usr/local/ folder

   cd /usr/local/
   wget http://www.sql-ledger.com/source/sql-ledger-2.8.20.tar.gz
   tar xzvf sql-ledger-2.8.20.tar.gz

Step 2: Set permissions

   cd sql-ledger
   chmod -R 777 users templates

Step 3: Add the following at the end of your httpd.conf

  Alias /sql-ledger /usr/local/sql-ledger/
  <Directory /usr/local/sql-ledger>
    AllowOverride All
    AddHandler cgi-script .pl
    AddDefaultCharset On
    Options ExecCGI Includes FollowSymlinks
    Order Allow,Deny
    Allow from All
  </Directory>

  <Directory /usr/local/sql-ledger/users>
    Order Deny,Allow
    Deny from All
  </Directory>

Step 4: Restart apache

   service httpd restart # redhat systems
   /usr/local/etc/rc.d/apache2 restart # FreeBSD

Step 5: Prepare Postgresql

Make sure following line exists and is the first uncommented line in your pg_hba.conf file.

   local    all     all     trust

If not, add this line and restart postgresql.

Step 6: Create dataset/chart and Users

Point your browser to your installation.

 http://your.webserver.ip.address/sql-ledger/admin.pl

You should see administrative login screen.

Add a new dataset and a user.

Tips

The installation instructions here are simplified for the impatient from sql-ledger doc/README file . When you have successfully installed sql-ledger at least once and understand various bits and pieces of required for installation, you can read )README for additional information.

If you cannot locate the httpd.conf or pg_hba.conf files, use the following commands:

find / -name httpd.conf -print
find / -name pg_hba.conf -print

“Internal Server Error” is displayed due to many possibilies. To see the reason, view the apache log file.

tail /var/log/httpd/error.log