Henry den Hengst's picture

I would like to make a suggestion to make a SQLLEDGER appliance (http://www.sql-ledger.com/) to put on the website.

Here is a blueprint so the rest of the community can give their 2 cents?


Jeremy Davis's picture

And would probably make a great appliance. I think that TKL LAPP appliance would make a good base for it.

From my very brief glance at the documentation it should be really easy to create a patch for. Should only need the install perl file. The additional extras (like Latex and PDF creation) would be nice too.

Henry den Hengst's picture

Do you have the experience to build an turnkey appliance, and are you interested building it?

Henry den Hengst's picture

Use the TKL LAPP ISO and use this script: http://pastebin.com/Gq49NzTi

Hopefully TKL will recorgize this as a far better ERP solution than currently available on TKL.

Jeremy Davis's picture

I have updated the Appliance Candidate entry a little and created a new SQL-Ledger Whiteboard/

Bottom line is though, at this point unless you want to work on developing a TKLDev based appliance build I'm not sure when it will make it's way into the Library. As you can see on the Appliance Candidate page there are HEAPS of great suggestions for new appliances...

Henry den Hengst's picture

use this howto article!


Login as root 

sudo -i
Download SQL-Ledger.
(sql-ledger-2.8.30 is the stable version, but 3.0 is on the way)
Untar the files 
cp sql-ledger-2.8.30.tar.gz /usr/local 
cd /usr/local 
tar zxvf sql-ledger-2.8.30.tar.gz
Setup SQL-Ledger 
cd /usr/local/sql-ledger
perl setup.pl
Checking for latest version number ....
SQL-Ledger ERP Installation
(i)nstall 2.8.30 (from Internet)
(d)ownload 2.8.30 (no installation)
Enter: i
Enter httpd owner [] : www-data
Enter httpd group [] : www-data
Downloading sql-ledger-2.8.30.tar.gz ....
Decompressing sql-ledger-2.8.30.tar.gz ... done
Unpacking sql-ledger-2.8.30.tar ... done
cleaning up ... done
This is a new installation.
Webserver directives were written to
Please add
# SQL-Ledger
Include /etc/apache2/sql-ledger-httpd.conf
to your httpd configuration file and restart the web server.
Display README (Y/n) : n
Apache Configuration. Looking at the last step, 
#Webserver directives were written to
Please add
# SQL-Ledger
Include /etc/apache2/sql-ledger-httpd.conf
to your httpd configuration file and restart the web server.
Display README (Y/n) : n
In Ubuntu/Debian, the configurations are entered in the file /etc/apache2/apache2.conf. So open the file and add the line as instructed above.
vim /etc/apache2/apache2.conf
Locate other incldues and add the SQL-Ledger Include. See how my apache2.conf file.
Change permissions of some of the files so that the Apache Server can write to them.
cd /usr/local/sql-ledger  
chown -hR www-data.www-data users templates css spool
Restart Your Apache Server 
/etc/init.d/apache2 restart
Install PostgreSQL 
apt-get install postgresql postgresql-client
Create a new user and database for sql-ledge
su postgres
createuser -d -P sql-ledger
createdb sql-ledger
createlang plpgsql template1
Setup the database and tables. Fire up your browser and point to http://localhost/sql-ledger/admin.pl. Initial Password is admin.  Select the "Database Administration" link, enter the user you created in the previous step.  The "Create Dataset" link queries the server for existing datasets and displays them in a table. Enter a name for the new dataset (use lowercase letters only!) and select one of the Chart of Accounts and click on Continue.
Create the User. Click "Add User"and remember to use the dataset you have just created.
Start Your Accounting by pointing your browser to http://localhost/sql-ledger/login.pl

Add new comment