Sql Ledger Install Guide | Best Free Open Source ERP

Sql-Ledger is an open-source web-based ERP system with over 20 years of development behind it. This Sql Ledger install guide goes through installing Sql-Ledger on Ubuntu.

There are 5 main parts to installing Sql-Ledger

• Install Packages (Apache, Postgres, libdbd-pg)
• Configuring Apache
• Editing pg_hba.conf
• Download, Extract & Fix Perms for Sql-Ledger
• First Time Configuration

Install Packages

Before installing packages we update our ubuntu with:

 sudo apt-get update 

To Install the required packages, you can run the following commands:

sudo apt-get install apache2 postgresql libdbd-pg-perl -y

Configure Apache

With our packages installed we go onto configuring apache for Sql-Ledger. This requires allowing for CGI-Scripts to run with Sql-Ledger uses.

Open the following file in your favorite text editor (I like nano, which comes default with ubuntu; you can use it by typing nano before the file path. Make sure you use sudo to do this.

/etc/apache2/sites-enabled/000-default.conf

Add the following lines after the Server Admin & Document Root Lines

<Directory /var/www/html>
        AllowOverride All
	Options ExecCGI FollowSymLinks
	AddHandler cgi-scripts .pl
</Directory>

Save file and exit out of text editor

Run the following commands:

sudo a2enmod cgi
sudo service apache2 restart

sudo service apache2 restart

Edit pg_hba.conf

Editing the conf file is similar to editing the apache conf. Use any text editor and open the following file

sudo nano /etc/postgresql/12/main/pg_hba.conf

Add the following lines as the first two lines after comments:

local 			all 			all			      trust		
 

host			all			all	127.0.0.1/32          trust	

Exit out of the text editor and run:

sudo service postgresql restart

Downloading & Installing Sql Ledger

You can download Sql-Ledger from the official website https://sql-ledger.com/cgi-bin/nav.pl?page=source/index.html&title=Download

After this all that is needed is extracting and fixing permissions for Sql-Ledger to run properly.

You will need to replace [user] with your ubuntu username.

cd /var/www/html
sudo wget http://sql-ledger.com/source/sql-ledger-3.2.11.tar.gz
sudo tar xzvf sql-ledger-3.2.11.tar.gz
sudo rm sql-ledger-3.2.11.tar.gz
sudo chown -R [user]:www-data sql-ledger
cd sql-ledger
sudo chown -R www-data:www-data users

At the time of this tutorial, the latest version is 3.2.11. You can change your version name accordingly.

With this Sql-Ledger is now installed on your system. But before you can use Sql-Ledger you will need to go through a first time configuration.

First Time Configuration

First you will need to setup the admin password. If you’ve followed this guide on a local installation that would be

localhost/sql-ledger/admin.pl

After setting the password, you can just click on Add Dataset on the next page. You can also create a new database, when needed, from here.

On the next page use “localhost” as the host and the user will be “postgres”

With this you just need to enter information for the database, such as the database name, company name and your installation of Sql-Ledger will be ready.

---

If you’d like a worry-free Sql-Ledger experience with extra features such as E-Commerce Integration, we offer cloud-hosted Sql-Ledger with 24 hour support. You can learn more from here. If you have any questions or issues with the installation, you can comment or reach out to us through here.