Henry den Hengst's picture
Henry den Hengst - Mon, 2013/04/01 - 10:08

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?

 

Forum: 
General
Tags: 
tklpatch
appliance
suggestion
sqlledger
blueprint
Jeremy Davis's picture

Jeremy Davis - Wed, 2013/04/03 - 05:44

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

Henry den Hengst - Wed, 2013/04/03 - 15:04

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

Henry den Hengst's picture

Henry den Hengst - Tue, 2014/05/06 - 12:49

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

Jeremy Davis - Tue, 2014/05/06 - 14:36

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

Henry den Hengst - Fri, 2013/04/26 - 21:17

use this howto article!

SQL-ledger

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
 
Status
 
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
 
  /etc/apache2/sql-ledger-httpd.conf
 
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
 
  /etc/apache2/sql-ledger-httpd.conf
 
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