InterNetWorkingSolutions Support Site

Good Luck and remember that we offer convenient install and support services.

Installing SQL Ledger is within the realm of the novice user but not for the faint of heart. The installation requires one to be comfortable using a command line, modifying the apache webserver, and setting up and maintaining a database server. Are you still with me? Great, lets proceed to the next stage. The first step is to log into the machine that you will be installing SQL Ledger on via a Secure Shell. If you are on a Macintosh simply open the terminal application located in your Applications/Utilities folder. Windows users will need to download an SSH application. I would recommend Putty (http://www.chiark.greenend.org.uk/~sgtatham/putty/). Once logged in you will need to have either access to the sudo command or the root account. We are going to explain how to install this via the sudo command. The second step is to create a user for the SQL Ledger application. This user should be used for nothing else. So as a user that has access to the sudo command type "sudo useradd -d /home/sqlledger -g apache -p YOURSECUREPASSWORD -u sql-ledger" Type in your password when prompted. At this point you have created a user account on your system for the SQL Ledger application with a home directory located in /home/sqlledger. That will be where you keep all of your files. The third step will be to actually install the application. Type the following commands:

"sudo su sql-ledger"

"cd"

"wget http://www.sql-ledger.com/source/setup.perl"

"mv setup.perl setup.pl" "chmod +x setup.pl" "sudo perl setup.pl" "sudo su postgres" "createuser -d -P sql-ledger" For the safety of your data please use a non-trivial password. You will be asked if the user can create databases and create new users. Answer "y" to both. "createlang plpgsql template1" "exit" In your web browser go to http://YOURSERVERNAME/sql-ledger/admin.pl Select the "Database Administration" link then enter the host, port and the user you created previously. The "Create Dataset" link queries the server for existing datasets and displays them in a table. Ent

er a name for the new dataset (use lowercase

letters only!) and select one of the Chart of Accounts and click on Continue. Your new dataset and the tables will be created and the selected Chart of Accounts loaded. The owner of the tables will be the user you entered in the previous screen as the "User". The "Delete Dataset" link queries the server for datasets which are in use by SQL-Ledger and are not used by any members. This might take a while to figure out. "Be patient". If there are any datasets not in use, you get a list of datasets. You cannot manage any other datasets from this interface, only the datasets used by SQL-Ledger.

STILL IN PROGRESS.