diff options
Diffstat (limited to 'sql-ledger/doc/README')
-rw-r--r-- | sql-ledger/doc/README | 290 |
1 files changed, 290 insertions, 0 deletions
diff --git a/sql-ledger/doc/README b/sql-ledger/doc/README new file mode 100644 index 0000000..2050e85 --- /dev/null +++ b/sql-ledger/doc/README @@ -0,0 +1,290 @@ + SQL-Ledger Accounting + Version 2.4 + + +DESCRIPTION: +------------ +SQL-Ledger is a double-entry accounting system written +in perl. It has been tested with PostgreSQL, Apache, +Netscape, Mozilla, Galeon, Explorer, Links, Lynx, +Konqueror, Voyager, W3M and Opera clients on Linux, +FreeBSD, Solaris, Windows, Mac computers and PDA's. + +Data is stored in a SQL server, either locally or remote, +the display is through a text or GUI web browser. The system +is linked by a chart of accounts. All transactions for AR, +AP and GL are stored in a transaction table. Hyper-links +from the chart of accounts let you view transactions posted +through AR, AP and GL. + +Configuration files let you specify to which SQL server +to connect to, personal preferences such as company name, +language, number and date format, etc. + +With the admin script you can create, edit or delete users, +create and delete datasets and setup the Chart of Accounts +and templates needed for the system. + +You can have a group of users using the same dataset and +templates for generating Invoices, Income Statements and +Balance Sheets or a different set altogether. + +Templates are supplied in html and tex format to generate +most of the forms. Forms can be printed to screen, sent +to a printer or e-mailed. + + +COPYRIGHT: +---------- +Licensed under the terms of the GPL. + + +LATEST VERSION: +--------------- +available from http://www.sql-ledger.org + + +PLATFORMS: +---------- +Non specific, see requirements. + + +REQUIREMENTS: +------------- +1 - Perl, 5+ +2 - http server (Apache, NCSA, httpi, thttpd, ...) +3 - SQL Server (PostgreSQL 7.1+) +4 - DBD (DBD-Pg) +5 - DBI +6 - LaTeX (optional) + + +FOREIGN LANGUAGE SUPPORT: +------------------------- +25 languages are supported. Language files are +ordinary text files, no special software is +required to change or add new translations. + +Some of the translation files are not 100% complete. +If strings are missing, English is used instead. + + +INSTALLATION WITH setup.pl: +--------------------------- +Make a directory + + mkdir /usr/local/sql-ledger + +Copy setup.pl to /usr/local/sql-ledger + +run setup.pl as root and follow the prompts. + + perl setup.pl + +Go to the next step, "PREPARE YOUR SQL SERVER". + +NOTE: If you are behind a firewall and cannot download +the code with setup.pl, download the source code file +and specify the filename on the command line. + + perl setup.pl sql-ledger-2.4.0.tar.gz + + +INSTALLATION WITHOUT setup.pl: +------------------------------ +unpack the tar.gz file in /usr/local + + tar xzvf sql-ledger-x.x.x.tar.gz + +you should now have everything in /usr/local/sql-ledger + +copy sql-ledger.conf.default to sql-ledger.conf + +edit sql-ledger.conf + +create a file sql-ledger-httpd.conf in the same location +where your httpd.conf is and copy the next section into the file + + Alias /sql-ledger/ /usr/local/sql-ledger/ + <Directory /usr/local/sql-ledger> + AllowOverride All + AddHandler cgi-script .pl + Options ExecCGI Includes FollowSymlinks + Order Allow,Deny + Allow from All + </Directory> + + <Directory /usr/local/sql-ledger/users> + Order Deny,Allow + Deny from All + </Directory> + +edit httpd.conf and add + + # SQL-Ledger + Include /config_directory/sql-ledger-httpd.conf + +Note: use an absolute or relative path to include +the configuration in your httpd.conf file. + +i.e. /etc/httpd/sql-ledger-httpd.conf + etc/apache2/sql-ledger-httpd.conf + +restart your web server. + +Note: /usr/local/sql-ledger is only a suggested +path, you may install in any directory. + + +SET PERMISSION: +--------------- +change directory to /usr/local/sql-ledger + +# chown -R nobody:nogroup users templates css spool + +replace nobody:nogroup with the web server +user and group of your system. Some systems use +apache:apache, www, www-data, ... + + +PREPARE YOUR SQL SERVER: +------------------------ + + PostgreSQL: + ----------- + add one database user with create database and + create user privileges to manage the datasets + and tables for SQL-Ledger + + # su postgres + $ createuser -d sql-ledger + Shall the new user be allowed to create databases? (y/n) y + Shall the new user be allowed to create more new users? (y/n) y + + if you use passwords to access postgres use this command + $ createuser -d -P sql-ledger + + Install PL/PGSQL in template1 + + # su postgres + $ createlang plpgsql template1 + + + ORACLE: + ------- + not supported yet + + DB2: + ---- + not supported yet + + +SETUP A DATABASE AND THE TABLES: +-------------------------------- +Load your web browser and connect to +http://localhost/sql-ledger/admin.pl + +Select the "Database Administration" link, +enter a host, port and 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. +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 may +take a while to figure out. "Be patient". +If there are any datasets not in use, you get +a screen with the datasets listed where you +select the one you want to delete. + +You cannot manage any other datasets from this +interface, only the datasets used by SQL-Ledger. + +POSTGRESQL: template1 is only used to query +the server, none of the information stored +in template1 is manipulated in any way. + + +SETUP A USER: +------------- +Load your web browser and connect to +http://localhost/sql-ledger/admin.pl + +Click on "Add User". In the Database +section select the driver and enter +the user you used to create the dataset. + + +LOAD THE ACCOUNTING PROGRAM: +---------------------------- +Load your web browser and connect to +http://localhost/sql-ledger/login.pl + + +UPGRADING TO A NEWER VERSION: +----------------------------- +1. load admin.pl and lock the system +2. untar the new version over top +3. check the doc directory for specific notes +4. load admin.pl and unlock the system +5. log in + +NOTE: datasets are upgraded when you log in for +the first time. If an error occurs the system +will remain locked. Track down the error, fix it, +load admin.pl, unlock the system and log in again. + + +UPGRADING WITH setup.pl: +------------------------ +run setup.pl from the command line and follow +the prompts. + + +INSTALLATION CHECKLIST: +----------------------- +1. untar SL somewhere +2. change permission for the users, templates, css and spool directory +3. edit httpd.conf +4. edit sql-ledger.conf +5. add the database user sql-ledger +6. load admin.pl +7. create datasets for the companies +8. add users + + In the Database section enter + + a) PostgreSQL + + Host: for local connections leave blank + Dataset: the dataset created in step 7 + Port: for local connections leave blank + User: sql-ledger + Password: password for sql-ledger + + +IF SOMETHING DOESN'T WORK: +-------------------------- +There is a FAQ at http://www.sql-ledger.org/misc/faq.html +or read the one included in the doc directory. + +There are also several mailing lists at +http://www.sql-ledger.org/misc/mailinglist.html +where you can seek free help. + +To order commercial support see +http://www.sql-ledger.com/misc/support.html + + +===================================================================== +September 4, 2004 + |