From 58d093219cf60264550b8c34649d9f3190eda042 Mon Sep 17 00:00:00 2001 From: cvs2git Date: Wed, 23 Aug 2006 22:25:40 +0000 Subject: This commit was manufactured by cvs2svn to create tag 'AFTER_FINAL_MASONIZE'. --- sql-ledger/doc/COPYING | 355 ----------------------- sql-ledger/doc/COPYRIGHT | 23 -- sql-ledger/doc/README | 290 ------------------- sql-ledger/doc/README.DB2 | 82 ------ sql-ledger/doc/UPGRADE-1.6-1.8 | 61 ---- sql-ledger/doc/UPGRADE-1.8-1.8.3 | 23 -- sql-ledger/doc/UPGRADE-1.8.3-1.8.4 | 10 - sql-ledger/doc/UPGRADE-1.8.4-1.8.5 | 18 -- sql-ledger/doc/UPGRADE-1.8.5-1.8.7 | 6 - sql-ledger/doc/UPGRADE-1.8.7-2.0.0 | 20 -- sql-ledger/doc/UPGRADE-2.0-2.0.8 | 8 - sql-ledger/doc/UPGRADE-2.0.8-2.0.9 | 6 - sql-ledger/doc/UPGRADE-2.0.9-2.2.0 | 12 - sql-ledger/doc/UPGRADE-2.2.0-2.2.7 | 11 - sql-ledger/doc/UPGRADE-2.2.7-2.4.0 | 84 ------ sql-ledger/doc/UPGRADE-2.4.0-2.4.1 | 12 - sql-ledger/doc/UPGRADE-2.4.1-2.4.2 | 12 - sql-ledger/doc/UPGRADE-2.4.2-2.4.3 | 22 -- sql-ledger/doc/UPGRADE-2.4.3-2.4.4 | 12 - sql-ledger/doc/faq.html | 556 ------------------------------------- 20 files changed, 1623 deletions(-) delete mode 100644 sql-ledger/doc/COPYING delete mode 100644 sql-ledger/doc/COPYRIGHT delete mode 100644 sql-ledger/doc/README delete mode 100644 sql-ledger/doc/README.DB2 delete mode 100644 sql-ledger/doc/UPGRADE-1.6-1.8 delete mode 100644 sql-ledger/doc/UPGRADE-1.8-1.8.3 delete mode 100644 sql-ledger/doc/UPGRADE-1.8.3-1.8.4 delete mode 100644 sql-ledger/doc/UPGRADE-1.8.4-1.8.5 delete mode 100644 sql-ledger/doc/UPGRADE-1.8.5-1.8.7 delete mode 100644 sql-ledger/doc/UPGRADE-1.8.7-2.0.0 delete mode 100644 sql-ledger/doc/UPGRADE-2.0-2.0.8 delete mode 100644 sql-ledger/doc/UPGRADE-2.0.8-2.0.9 delete mode 100644 sql-ledger/doc/UPGRADE-2.0.9-2.2.0 delete mode 100644 sql-ledger/doc/UPGRADE-2.2.0-2.2.7 delete mode 100644 sql-ledger/doc/UPGRADE-2.2.7-2.4.0 delete mode 100644 sql-ledger/doc/UPGRADE-2.4.0-2.4.1 delete mode 100644 sql-ledger/doc/UPGRADE-2.4.1-2.4.2 delete mode 100644 sql-ledger/doc/UPGRADE-2.4.2-2.4.3 delete mode 100644 sql-ledger/doc/UPGRADE-2.4.3-2.4.4 delete mode 100644 sql-ledger/doc/faq.html (limited to 'sql-ledger/doc') diff --git a/sql-ledger/doc/COPYING b/sql-ledger/doc/COPYING deleted file mode 100644 index 083bb4150..000000000 --- a/sql-ledger/doc/COPYING +++ /dev/null @@ -1,355 +0,0 @@ - - - -GNU General Public License - - - - - -
-                    GNU GENERAL PUBLIC LICENSE
-                       Version 2, June 1991
-
- Copyright (C) 1989, 1991 Free Software Foundation, Inc.
- 675 Mass Ave, Cambridge, MA 02139, USA
-
- Everyone is permitted to copy and distribute verbatim copies
- of this license document, but changing it is not allowed.
-
-
-                            Preamble
-
-  The licenses for most software are designed to take away your
-freedom to share and change it.  By contrast, the GNU General Public
-License is intended to guarantee your freedom to share and change free
-software--to make sure the software is free for all its users.  This
-General Public License applies to most of the Free Software
-Foundation's software and to any other program whose authors commit to
-using it.  (Some other Free Software Foundation software is covered by
-the GNU Library General Public License instead.)  You can apply it to
-your programs, too.
-
-  When we speak of free software, we are referring to freedom, not
-price.  Our General Public Licenses are designed to make sure that you
-have the freedom to distribute copies of free software (and charge for
-this service if you wish), that you receive source code or can get it
-if you want it, that you can change the software or use pieces of it
-in new free programs; and that you know you can do these things.
-
-  To protect your rights, we need to make restrictions that forbid
-anyone to deny you these rights or to ask you to surrender the rights.
-These restrictions translate to certain responsibilities for you if you
-distribute copies of the software, or if you modify it.
-
-  For example, if you distribute copies of such a program, whether
-gratis or for a fee, you must give the recipients all the rights that
-you have.  You must make sure that they, too, receive or can get the
-source code.  And you must show them these terms so they know their
-rights.
-
-  We protect your rights with two steps: (1) copyright the software, and
-(2) offer you this license which gives you legal permission to copy,
-distribute and/or modify the software.
-
-  Also, for each author's protection and ours, we want to make certain
-that everyone understands that there is no warranty for this free
-software.  If the software is modified by someone else and passed on, we
-want its recipients to know that what they have is not the original, so
-that any problems introduced by others will not reflect on the original
-authors' reputations.
-
-  Finally, any free program is threatened constantly by software
-patents.  We wish to avoid the danger that redistributors of a free
-program will individually obtain patent licenses, in effect making the
-program proprietary.  To prevent this, we have made it clear that any
-patent must be licensed for everyone's free use or not licensed at all.
-
-  The precise terms and conditions for copying, distribution and
-modification follow.
-
-                    GNU GENERAL PUBLIC LICENSE
-   TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
-
-  0. This License applies to any program or other work which contains
-a notice placed by the copyright holder saying it may be distributed
-under the terms of this General Public License.  The "Program", below,
-refers to any such program or work, and a "work based on the Program"
-means either the Program or any derivative work under copyright law:
-that is to say, a work containing the Program or a portion of it,
-either verbatim or with modifications and/or translated into another
-language.  (Hereinafter, translation is included without limitation in
-the term "modification".)  Each licensee is addressed as "you".
-
-Activities other than copying, distribution and modification are not
-covered by this License; they are outside its scope.  The act of
-running the Program is not restricted, and the output from the Program
-is covered only if its contents constitute a work based on the
-Program (independent of having been made by running the Program).
-Whether that is true depends on what the Program does.
-
-  1. You may copy and distribute verbatim copies of the Program's
-source code as you receive it, in any medium, provided that you
-conspicuously and appropriately publish on each copy an appropriate
-copyright notice and disclaimer of warranty; keep intact all the
-notices that refer to this License and to the absence of any warranty;
-and give any other recipients of the Program a copy of this License
-along with the Program.
-
-You may charge a fee for the physical act of transferring a copy, and
-you may at your option offer warranty protection in exchange for a fee.
-
-  2. You may modify your copy or copies of the Program or any portion
-of it, thus forming a work based on the Program, and copy and
-distribute such modifications or work under the terms of Section 1
-above, provided that you also meet all of these conditions:
-
-    a) You must cause the modified files to carry prominent notices
-    stating that you changed the files and the date of any change.
-
-    b) You must cause any work that you distribute or publish, that in
-    whole or in part contains or is derived from the Program or any
-    part thereof, to be licensed as a whole at no charge to all third
-    parties under the terms of this License.
-
-    c) If the modified program normally reads commands interactively
-    when run, you must cause it, when started running for such
-    interactive use in the most ordinary way, to print or display an
-    announcement including an appropriate copyright notice and a
-    notice that there is no warranty (or else, saying that you provide
-    a warranty) and that users may redistribute the program under
-    these conditions, and telling the user how to view a copy of this
-    License.  (Exception: if the Program itself is interactive but
-    does not normally print such an announcement, your work based on
-    the Program is not required to print an announcement.)
-
-These requirements apply to the modified work as a whole.  If
-identifiable sections of that work are not derived from the Program,
-and can be reasonably considered independent and separate works in
-themselves, then this License, and its terms, do not apply to those
-sections when you distribute them as separate works.  But when you
-distribute the same sections as part of a whole which is a work based
-on the Program, the distribution of the whole must be on the terms of
-this License, whose permissions for other licensees extend to the
-entire whole, and thus to each and every part regardless of who wrote it.
-
-Thus, it is not the intent of this section to claim rights or contest
-your rights to work written entirely by you; rather, the intent is to
-exercise the right to control the distribution of derivative or
-collective works based on the Program.
-
-In addition, mere aggregation of another work not based on the Program
-with the Program (or with a work based on the Program) on a volume of
-a storage or distribution medium does not bring the other work under
-the scope of this License.
-
-  3. You may copy and distribute the Program (or a work based on it,
-under Section 2) in object code or executable form under the terms of
-Sections 1 and 2 above provided that you also do one of the following:
-
-    a) Accompany it with the complete corresponding machine-readable
-    source code, which must be distributed under the terms of Sections
-    1 and 2 above on a medium customarily used for software interchange; or,
-
-    b) Accompany it with a written offer, valid for at least three
-    years, to give any third party, for a charge no more than your
-    cost of physically performing source distribution, a complete
-    machine-readable copy of the corresponding source code, to be
-    distributed under the terms of Sections 1 and 2 above on a medium
-    customarily used for software interchange; or,
-
-    c) Accompany it with the information you received as to the offer
-    to distribute corresponding source code.  (This alternative is
-    allowed only for noncommercial distribution and only if you
-    received the program in object code or executable form with such
-    an offer, in accord with Subsection b above.)
-
-The source code for a work means the preferred form of the work for
-making modifications to it.  For an executable work, complete source
-code means all the source code for all modules it contains, plus any
-associated interface definition files, plus the scripts used to
-control compilation and installation of the executable.  However, as a
-special exception, the source code distributed need not include
-anything that is normally distributed (in either source or binary
-form) with the major components (compiler, kernel, and so on) of the
-operating system on which the executable runs, unless that component
-itself accompanies the executable.
-
-If distribution of executable or object code is made by offering
-access to copy from a designated place, then offering equivalent
-access to copy the source code from the same place counts as
-distribution of the source code, even though third parties are not
-compelled to copy the source along with the object code.
-
-  4. You may not copy, modify, sublicense, or distribute the Program
-except as expressly provided under this License.  Any attempt
-otherwise to copy, modify, sublicense or distribute the Program is
-void, and will automatically terminate your rights under this License.
-However, parties who have received copies, or rights, from you under
-this License will not have their licenses terminated so long as such
-parties remain in full compliance.
-
-  5. You are not required to accept this License, since you have not
-signed it.  However, nothing else grants you permission to modify or
-distribute the Program or its derivative works.  These actions are
-prohibited by law if you do not accept this License.  Therefore, by
-modifying or distributing the Program (or any work based on the
-Program), you indicate your acceptance of this License to do so, and
-all its terms and conditions for copying, distributing or modifying
-the Program or works based on it.
-
-  6. Each time you redistribute the Program (or any work based on the
-Program), the recipient automatically receives a license from the
-original licensor to copy, distribute or modify the Program subject to
-these terms and conditions.  You may not impose any further
-restrictions on the recipients' exercise of the rights granted herein.
-You are not responsible for enforcing compliance by third parties to
-this License.
-
-  7. If, as a consequence of a court judgment or allegation of patent
-infringement or for any other reason (not limited to patent issues),
-conditions are imposed on you (whether by court order, agreement or
-otherwise) that contradict the conditions of this License, they do not
-excuse you from the conditions of this License.  If you cannot
-distribute so as to satisfy simultaneously your obligations under this
-License and any other pertinent obligations, then as a consequence you
-may not distribute the Program at all.  For example, if a patent
-license would not permit royalty-free redistribution of the Program by
-all those who receive copies directly or indirectly through you, then
-the only way you could satisfy both it and this License would be to
-refrain entirely from distribution of the Program.
-
-If any portion of this section is held invalid or unenforceable under
-any particular circumstance, the balance of the section is intended to
-apply and the section as a whole is intended to apply in other
-circumstances.
-
-It is not the purpose of this section to induce you to infringe any
-patents or other property right claims or to contest validity of any
-such claims; this section has the sole purpose of protecting the
-integrity of the free software distribution system, which is
-implemented by public license practices.  Many people have made
-generous contributions to the wide range of software distributed
-through that system in reliance on consistent application of that
-system; it is up to the author/donor to decide if he or she is willing
-to distribute software through any other system and a licensee cannot
-impose that choice.
-
-This section is intended to make thoroughly clear what is believed to
-be a consequence of the rest of this License.
-
-  8. If the distribution and/or use of the Program is restricted in
-certain countries either by patents or by copyrighted interfaces, the
-original copyright holder who places the Program under this License
-may add an explicit geographical distribution limitation excluding
-those countries, so that distribution is permitted only in or among
-countries not thus excluded.  In such case, this License incorporates
-the limitation as if written in the body of this License.
-
-  9. The Free Software Foundation may publish revised and/or new versions
-of the General Public License from time to time.  Such new versions will
-be similar in spirit to the present version, but may differ in detail to
-address new problems or concerns.
-
-Each version is given a distinguishing version number.  If the Program
-specifies a version number of this License which applies to it and "any
-later version", you have the option of following the terms and conditions
-either of that version or of any later version published by the Free
-Software Foundation.  If the Program does not specify a version number of
-this License, you may choose any version ever published by the Free Software
-Foundation.
-
-  10. If you wish to incorporate parts of the Program into other free
-programs whose distribution conditions are different, write to the author
-to ask for permission.  For software which is copyrighted by the Free
-Software Foundation, write to the Free Software Foundation; we sometimes
-make exceptions for this.  Our decision will be guided by the two goals
-of preserving the free status of all derivatives of our free software and
-of promoting the sharing and reuse of software generally.
-
-                            NO WARRANTY
-
-  11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY
-FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW.  EXCEPT WHEN
-OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES
-PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED
-OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
-MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  THE ENTIRE RISK AS
-TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU.  SHOULD THE
-PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING,
-REPAIR OR CORRECTION.
-
-  12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING
-WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR
-REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES,
-INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING
-OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED
-TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY
-YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER
-PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE
-POSSIBILITY OF SUCH DAMAGES.
-
-                     END OF TERMS AND CONDITIONS
-        Appendix: How to Apply These Terms to Your New Programs
-
-  If you develop a new program, and you want it to be of the greatest
-possible use to the public, the best way to achieve this is to make it
-free software which everyone can redistribute and change under these terms.
-
-  To do so, attach the following notices to the program.  It is safest
-to attach them to the start of each source file to most effectively
-convey the exclusion of warranty; and each file should have at least
-the "copyright" line and a pointer to where the full notice is found.
-
-    <one line to give the program's name and a brief idea of what it does.>
-    Copyright (C) 19yy  <name of author>
-
-    This program is free software; you can redistribute it and/or modify
-    it under the terms of the GNU General Public License as published by
-    the Free Software Foundation; either version 2 of the License, or
-    (at your option) any later version.
-
-    This program is distributed in the hope that it will be useful,
-    but WITHOUT ANY WARRANTY; without even the implied warranty of
-    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-    GNU General Public License for more details.
-
-    You should have received a copy of the GNU General Public License
-    along with this program; if not, write to the Free Software
-    Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
-
-Also add information on how to contact you by electronic and paper mail.
-
-If the program is interactive, make it output a short notice like this
-when it starts in an interactive mode:
-
-    Gnomovision version 69, Copyright (C) 19yy name of author
-    Gnomovision comes with ABSOLUTELY NO WARRANTY; for details type `show w'.
-    This is free software, and you are welcome to redistribute it
-    under certain conditions; type `show c' for details.
-
-The hypothetical commands `show w' and `show c' should show the appropriate
-parts of the General Public License.  Of course, the commands you use may
-be called something other than `show w' and `show c'; they could even be
-mouse-clicks or menu items--whatever suits your program.
-
-You should also get your employer (if you work as a programmer) or your
-school, if any, to sign a "copyright disclaimer" for the program, if
-necessary.  Here is a sample; alter the names:
-
-  Yoyodyne, Inc., hereby disclaims all copyright interest in the program
-  `Gnomovision' (which makes passes at compilers) written by James Hacker.
-
-  <signature of Ty Coon>, 1 April 1989
-  Ty Coon, President of Vice
-
-This General Public License does not permit incorporating your program into
-proprietary programs.  If your program is a subroutine library, you may
-consider it more useful to permit linking proprietary applications with the
-library.  If this is what you want to do, use the GNU Library General
-Public License instead of this License.
-
-
-
-
-
diff --git a/sql-ledger/doc/COPYRIGHT b/sql-ledger/doc/COPYRIGHT
deleted file mode 100644
index d493a3d21..000000000
--- a/sql-ledger/doc/COPYRIGHT
+++ /dev/null
@@ -1,23 +0,0 @@
-######################################################################
-# SQL-Ledger Accounting
-# Copyright (c) 2003, Dieter Simader
-#
-#  Author: Dieter Simader
-#   Email: dsimader@sql-ledger.org
-#     Web: http://www.sql-ledger.org
-#
-# This program is free software; you can redistribute it and/or modify
-# it under the terms of the GNU General Public License as published by
-# the Free Software Foundation; either version 2 of the License, or
-# (at your option) any later version.
-#
-# This program is distributed in the hope that it will be useful,
-# but WITHOUT ANY WARRANTY; without even the implied warranty of
-# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-# GNU General Public License for more details.
-# You should have received a copy of the GNU General Public License
-# along with this program; if not, write to the Free Software
-# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
-#
-#######################################################################
-
diff --git a/sql-ledger/doc/README b/sql-ledger/doc/README
deleted file mode 100644
index 2050e8500..000000000
--- a/sql-ledger/doc/README
+++ /dev/null
@@ -1,290 +0,0 @@
-                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/
-  
-    AllowOverride All
-    AddHandler cgi-script .pl
-    Options ExecCGI Includes FollowSymlinks
-    Order Allow,Deny
-    Allow from All
-  
-
-  
-    Order Deny,Allow
-    Deny from All
-  
-
-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
-
diff --git a/sql-ledger/doc/README.DB2 b/sql-ledger/doc/README.DB2
deleted file mode 100644
index 2e5230a4d..000000000
--- a/sql-ledger/doc/README.DB2
+++ /dev/null
@@ -1,82 +0,0 @@
-To build and install the DBD::DB2 module, you need the following: 
-
-*Perl 5.004_04 or later 
-*DBI 0.93 or later 
-*DB2 Application Development Client 
-*A supported C compiler as documented under 
- 'Supported Operating Systems' 
- at the DB2 Application Development Web page:
-
-http://www-3.ibm.com/software/data/db2/udb/ad/index.html
-
-Install Notes:
-
-http://www.perl.com/CPAN-local/modules/by-module/DBD/DBD-DB2-0.76.readme
-
-Module:
-
-http://www.perl.com/CPAN-local/modules/by-module/DBD/DBD-DB2-0.76.tar.gz
-
-Notes:
------------------------------
-
-SQL-Ledger tested with IBM DB2 v7.2 and v8.1.
-Compiled for use with DBI 1.18 for all testing.
-
-DB2 Application Development Client used was with
-the DB2 Personal Developer's Edition (PDE). All
-databases and application code tested under RedHat
-Linux 7.2 kernel 2.4.7-10.
-
-ADDITIONAL NOTES: DB2 specific
-------------------------------
-
-1. DB2 installed under default owner, and group:
-   db2inst1 and db2grp1.
-   
-2. SQL-Ledger app owner (ledger) was added to DB2 group db2grp1
-   thereby given SYSADM authority.
-   
-3. SQL-Ledger app owner has same ENV variables as the db2inst1 user.
-   This can be added, or have:
-   . $DB_HOME/sqllib/db2profile  in the SQL-Ledger app owner .(bash_)profile.
-   
-4. SQL-Ledger app owner must have environment variable
-   DB2INSTANCE set.
-   
-5. SQL-Ledger app owner, now with SYSADM authority and PATH
-   containing DB2's bin should run the following:
-   
-   prompt>:  db2set -all    # To view instance and registry variables 
-   prompt>:  db2set DB2DBDFT=your_default_database_name i.e. LEDGER
-   prompt>:  db2set DB2CLIINIPATH=set_to_usually $DB_HOME/sqllib/cfg
-   
-   Now, cd to the DB2CLIINIPATH directory and edit the db2cli.ini
-   file.  Continuing with our use of LEDGER as the database that
-   will be created and used, add:
-   
-   [LEDGER]
-   AUTOCOMMIT=1
-   LONGDATACOMPAT=1
-   DBALIAS=LEDGER
-   DEFERREDPREPARE=1
-   
-   If DEFERREDPREPARE=1 is the last line, add a blank line.  A blank
-   line must be the last line.
-   
-6. Create the database, objects, and initialize by moving to the directory:
-   /where_you_installed_SQL-Ledger/sql , and review the file
-   DB2-sql-ledger.order.  The commands outlined are in the required order,
-   create a database called LEDGER using default SMS tablespaces.  The
-   last command-line creates the "Default" Chart-of-Accounts.  
-   
-   *Modify the files at will to: 
-   	create a different named database (make sure you review the 
-   	step where you -> db2set DB2DBDFT=your_default_database_name) 
-   	
-   	create DMS tablespaces
-   	
-   	different Chart-of-Accounts.  
-   	
-   If a 'gifi' sql script needs to be run, make sure the 
-   "db2 -tvf" is used so the ';' are accepted as command terminators.
diff --git a/sql-ledger/doc/UPGRADE-1.6-1.8 b/sql-ledger/doc/UPGRADE-1.6-1.8
deleted file mode 100644
index b5631b283..000000000
--- a/sql-ledger/doc/UPGRADE-1.6-1.8
+++ /dev/null
@@ -1,61 +0,0 @@
-Upgrading from version 1.6 to 1.8
-
-1. make a backup copy of your databases and SQL-Ledger, just in case!
-   $ cd /usr/local/www/sql-ledger
-   $ pg_dump database > db.out
-   $ tar cvf ~/sql-ledger.tar .
-   
-2. install SQL-Ledger over top of your old installation
-   $ cd /usr/local/www
-   $ tar zxvf sql-ledger-1.8.0.tar.gz
-   
-3. change the tables to the new layout
-   $ cd sql-ledger/sql
-   $ psql database < upgrade-1.6-1.8.sql
-
-4. copy the new master templates to your template directory
-   $ cd ../templates
-
-   $ cp Default-email_purchase_order.html your_template_dir/email_purchase_order.html
-   $ cp Default-purchase_order.html your_template_dir/purchase_order.html
-   $ cp Default-email_sales_order.html your_template_dir/email_sales_order.html
-   $ cp Default-sales_order.html your_template_dir/sales_order.html
- 
-5. Two new accounts were hopefully added to your chart of accounts
-   One account for Foreign Exchange Gains and one for
-   Foreign Exchange Losses
-   edit and change to suit your COA. You can safely change
-   the account number too.
-      
-6. Edit your preferences
-
-   In field 'Stylesheet' enter -> sql-ledger.css
-   Stylesheet is in the css directory
-
-   Add your foreign currencies in the Currencies field
-   The first currency in the list is your default
-   i.e CDN:USD:EUR:YEN
-   If you used a nativecurr than it should be listed in the
-   new currencies field.
-
-7. <%nativecurr%> has changed to <%currency%>
-   edit all your templates and change nativecurr to currency
-
-8. I also added four more variables which can be used in your templates.
-   <%contact%>, <%shiptocontact%>, <%shiptophone%>, <%shiptofax%>
-   
-9. Nameing convention for templates has changed from an
-   underscore to a minus sign. If you designed your own
-   master templates rename the templates from
-   industry_invoice.html to industry-invoice.html,
-   industry_packing_list.html to industry-packing_list.html, etc.
-   The minus sign is used to separate the name and list them in
-   the setup screen.
-   
-   This change only applies to the master templates in the
-   templates root directory NOT the individual templates which
-   are used by users.
-
-It looks more than it really is. Steps 1 to 4 are important,
-the rest is for fine tuning and info.
-
diff --git a/sql-ledger/doc/UPGRADE-1.8-1.8.3 b/sql-ledger/doc/UPGRADE-1.8-1.8.3
deleted file mode 100644
index babed3793..000000000
--- a/sql-ledger/doc/UPGRADE-1.8-1.8.3
+++ /dev/null
@@ -1,23 +0,0 @@
-Upgrading from version 1.8.(0-2) to 1.8.3
-
-1. install SQL-Ledger over top of your old installation
-   $ cd /usr/local
-   $ tar zxvf sql-ledger-1.8.3.tar.gz
-
-2. copy sql-ledger.conf.default to sql-ledger.conf
-   $ cp sql-ledger.conf.default sql-ledger.conf
-
-   if you modified sql-ledger.conf merge the changes from the
-   .default file rather than copying over top.
-
-3. copy the new master templates to your template directory
-   $ cd ../templates
-
-   $ cp Default-invoice.tex your_template_dir/invoice.tex
-   $ cp Default-packing_list.tex your_template_dir/packing_list.tex
-   $ cp Default-purchase_order.tex your_template_dir/purchase_order.tex
-   $ cp Default-sales_order.tex your_template_dir/sales_order.tex
- 
-4. edit sql-ledger.conf
-   instructions are in the file
-
diff --git a/sql-ledger/doc/UPGRADE-1.8.3-1.8.4 b/sql-ledger/doc/UPGRADE-1.8.3-1.8.4
deleted file mode 100644
index c3ecdf5af..000000000
--- a/sql-ledger/doc/UPGRADE-1.8.3-1.8.4
+++ /dev/null
@@ -1,10 +0,0 @@
-Upgrading from version 1.8.3 to 1.8.4
-
-1. install SQL-Ledger over top of your old installation
-   $ cd /usr/local
-   $ tar zxvf sql-ledger-1.8.4.tar.gz
-
-2. update the tables with the admin script
-
-   You will not be able to log in until you upgraded the tables.
-   
diff --git a/sql-ledger/doc/UPGRADE-1.8.4-1.8.5 b/sql-ledger/doc/UPGRADE-1.8.4-1.8.5
deleted file mode 100644
index e8c32e1bf..000000000
--- a/sql-ledger/doc/UPGRADE-1.8.4-1.8.5
+++ /dev/null
@@ -1,18 +0,0 @@
-Upgrading from version 1.8.4 to 1.8.5
-
-1. install SQL-Ledger over top of your old installation
-   $ cd /usr/local
-   $ tar zxvf sql-ledger-1.8.5.tar.gz
-
-2. update the tables with the admin script
-
-   You will not be able to log in until you upgraded the tables.
-
-
-There are two new variables (<%customernumber%> and <%vendornumber%>)
-which can be used in the forms. These may be used instead of the
-internally generated customer_id and vendor_id.
-
-Typically these numbers are used to retrieve a customer, vendor
-by some ID. In most counter operations the phone number is used.
-
diff --git a/sql-ledger/doc/UPGRADE-1.8.5-1.8.7 b/sql-ledger/doc/UPGRADE-1.8.5-1.8.7
deleted file mode 100644
index 992238c3a..000000000
--- a/sql-ledger/doc/UPGRADE-1.8.5-1.8.7
+++ /dev/null
@@ -1,6 +0,0 @@
-Upgrading from version 1.8.5 to 1.8.7
-
-1. install SQL-Ledger over top of your old installation
-   $ cd /usr/local
-   $ tar zxvf sql-ledger-1.8.7.tar.gz
-
diff --git a/sql-ledger/doc/UPGRADE-1.8.7-2.0.0 b/sql-ledger/doc/UPGRADE-1.8.7-2.0.0
deleted file mode 100644
index e16ba7556..000000000
--- a/sql-ledger/doc/UPGRADE-1.8.7-2.0.0
+++ /dev/null
@@ -1,20 +0,0 @@
-Upgrading to Version 2.0.0
-
-1. install SQL-Ledger over top of your old installation
-   $ cd /usr/local
-   $ tar zxvf sql-ledger-2.0.0.tar.gz
-
-2. load admin.pl and update the tables
-
-   You will not be able to log in until the tables are up to date.
-
-3. copy the new templates to your personal template directory
-
-   $ cd templates
-   $ cp Default-check.tex dir/check.tex
-   $ cp Default-receipt.tex dir/receipt.tex
-   $ cp Default-statement.html dir/statement.html
-   $ cp Default-statement.tex dir/statement.tex
-
-   replace 'dir' with your directory name
-
diff --git a/sql-ledger/doc/UPGRADE-2.0-2.0.8 b/sql-ledger/doc/UPGRADE-2.0-2.0.8
deleted file mode 100644
index 6ddff62ac..000000000
--- a/sql-ledger/doc/UPGRADE-2.0-2.0.8
+++ /dev/null
@@ -1,8 +0,0 @@
-Upgrading from version 2.0.[0-7] to 2.0.8
-
-1. install SQL-Ledger over top of your old installation
-   $ cd /usr/local
-   $ tar zxvf sql-ledger-2.0.8.tar.gz
-
-2. update your datasets with the admin script
-
diff --git a/sql-ledger/doc/UPGRADE-2.0.8-2.0.9 b/sql-ledger/doc/UPGRADE-2.0.8-2.0.9
deleted file mode 100644
index 0bdb7a022..000000000
--- a/sql-ledger/doc/UPGRADE-2.0.8-2.0.9
+++ /dev/null
@@ -1,6 +0,0 @@
-Upgrading from version 2.0.8 to 2.0.9
-
-1. install SQL-Ledger over top of your old installation
-   $ cd /usr/local
-   $ tar zxvf sql-ledger-2.0.9.tar.gz
-
diff --git a/sql-ledger/doc/UPGRADE-2.0.9-2.2.0 b/sql-ledger/doc/UPGRADE-2.0.9-2.2.0
deleted file mode 100644
index 9f9d779e0..000000000
--- a/sql-ledger/doc/UPGRADE-2.0.9-2.2.0
+++ /dev/null
@@ -1,12 +0,0 @@
-Upgrading from version 2.0.9 to 2.2.0
-
-1. backup your datasets. Always a good idea!
-
-2. install SQL-Ledger over top of your old installation
-   $ cd /usr/local
-   $ tar zxvf sql-ledger-2.2.0.tar.gz
-
-3. copy Default-pos_invoice.txt to
-   templates/your_private_directory/pos_invoice.txt
-   and edit to suit.
-
diff --git a/sql-ledger/doc/UPGRADE-2.2.0-2.2.7 b/sql-ledger/doc/UPGRADE-2.2.0-2.2.7
deleted file mode 100644
index 2a973a7ec..000000000
--- a/sql-ledger/doc/UPGRADE-2.2.0-2.2.7
+++ /dev/null
@@ -1,11 +0,0 @@
-Upgrading to version 2.2.7
-
-1. install SQL-Ledger over top
-   # cd /usr/local
-   # tar zxvf sql-ledger-2.2.7.tar.gz
-
-2. fix permissions
-   # chown -R nobody:nogroup *
-   # chmod 711 templates users
-
-Note: replace nobody:nogroup with your web server user and group
diff --git a/sql-ledger/doc/UPGRADE-2.2.7-2.4.0 b/sql-ledger/doc/UPGRADE-2.2.7-2.4.0
deleted file mode 100644
index c10bcbe49..000000000
--- a/sql-ledger/doc/UPGRADE-2.2.7-2.4.0
+++ /dev/null
@@ -1,84 +0,0 @@
-Upgrading to version 2.4.0
-
-1. install SQL-Ledger over top
-   # cd /usr/local
-   # tar zxvf sql-ledger-2.4.0.tar.gz
-
-2. fix permissions
-   # chown -hR nobody:nogroup *
-   # chmod 711 templates users spool
-
-replace nobody:nogroup with your web server user and group
-
-3. install the plpgsql language compiler for PostgreSQL
-   # createlang plpgsql 
-
-4. install plpgsql in template1
-   # createlang plpgsql template1
-
-5. Edit your templates! The old address fields are obsolete.
-
-The new fields are:
-  address1
-  address2
-  city
-  state
-  zipcode
-  country
-
-The same applies to the "shipto" addresses.
-
-Before you log in edit Pg-upgrade-2.3.4-2.3.5.sql and change the
-way addresses are rewritten if you don't want US style addresses.
-
-North-american addresses are usually in the form of
-
-Five Star Stables
-123 Horsehoe Blvd.
-Sweetgrass, MT 19867
-U.S.A
-
-addr1 --> address1
-addr2 --> city
-addr3 --> country
-addr4 --> state
-
-addr4 was put into the state field to bring the field forward
-to the new layout. To check if there is something in the field run
-a report and sort by the "State" field.
-
-Either edit the records or run the SQL queries below to take them apart.
-
-If you have anything in the "state" field change the records to match
-the others before you run the following queries.
-
-dbname=# update customer set state = substr(city,strpos(city,' ')+1);
-dbname=# update customer set zipcode = substr(state,strpos(state,' ')+1);
-dbname=# update customer set state = substr(state,1,strpos(state,' ')-1);
-dbname=# update customer set city = substr(city,1,strpos(city,',')-1);
-
-do the same with the vendor and shipto table.
-
-6. create a new set of templates
-
-  * load admin.pl and edit one of the user's
-  * in the "New Templates" field enter "new" and save the user
-  * go back in your browser so you have the same screen again
-    as before
-  * change the template directory back to what it was before
-    the change and save the user
-    
-  * drop into a shell window
-  * cd to sql-ledger/templates/new
-  * copy the additional templates to your private template directory
-  
-7. Printers
-
-printer setup has changed to multiple printers which allow
-users to choose a printer. Printers can be defined in sql-ledger.conf
-
-
-Oracle and DB2:
-===============
-There is no upgrade available for Oracle and DB2 yet.
-
diff --git a/sql-ledger/doc/UPGRADE-2.4.0-2.4.1 b/sql-ledger/doc/UPGRADE-2.4.0-2.4.1
deleted file mode 100644
index 82b1ec4c5..000000000
--- a/sql-ledger/doc/UPGRADE-2.4.0-2.4.1
+++ /dev/null
@@ -1,12 +0,0 @@
-Upgrading to version 2.4.1
-
-1. install SQL-Ledger over top
-   # cd /usr/local
-   # tar zxvf sql-ledger-2.4.1.tar.gz
-
-2. fix permissions
-   # chown -hR nobody:nogroup *
-   # chmod 711 templates users css spool
-
-Note: replace nobody:nogroup with your web server user and group
-
diff --git a/sql-ledger/doc/UPGRADE-2.4.1-2.4.2 b/sql-ledger/doc/UPGRADE-2.4.1-2.4.2
deleted file mode 100644
index 09aae92a4..000000000
--- a/sql-ledger/doc/UPGRADE-2.4.1-2.4.2
+++ /dev/null
@@ -1,12 +0,0 @@
-Upgrading to version 2.4.2
-
-1. install SQL-Ledger over top
-   # cd /usr/local
-   # tar zxvf sql-ledger-2.4.2.tar.gz
-
-2. fix permissions
-   # chown -hR nobody:nogroup *
-   # chmod 711 templates users css spool
-
-Note: replace nobody:nogroup with your web server user and group
-
diff --git a/sql-ledger/doc/UPGRADE-2.4.2-2.4.3 b/sql-ledger/doc/UPGRADE-2.4.2-2.4.3
deleted file mode 100644
index 48d849645..000000000
--- a/sql-ledger/doc/UPGRADE-2.4.2-2.4.3
+++ /dev/null
@@ -1,22 +0,0 @@
-Upgrading from version 2.4.(0-2) to 2.4.3
-
-1. install SQL-Ledger over top of your old installation
-   $ cd /usr/local
-   $ tar zxvf sql-ledger-2.4.3.tar.gz
-
-2. fix permissions
-   # chown -hR nobody:nogroup *
-   # chmod 711 templates users css spool
-
-   Note: replace nobody:nogroup with your web server user and group
-      
-3. copy the following templates to your template directory
-   $ cd templates
-
-   $ cp Default-ar_transaction.html your_template_dir/ar_transaction.html
-   $ cp Default-ar_transaction.tex your_template_dir/ar_transaction.tex
-   $ cp Default-ap_transaction.html your_template_dir/ap_transaction.html
-   $ cp Default-ap_transaction.tex your_template_dir/ap_transaction.tex
-
-4. log in
-
diff --git a/sql-ledger/doc/UPGRADE-2.4.3-2.4.4 b/sql-ledger/doc/UPGRADE-2.4.3-2.4.4
deleted file mode 100644
index a845e875d..000000000
--- a/sql-ledger/doc/UPGRADE-2.4.3-2.4.4
+++ /dev/null
@@ -1,12 +0,0 @@
-Upgrading to version 2.4.4
-
-1. install SQL-Ledger over top
-   # cd /usr/local
-   # tar zxvf sql-ledger-2.4.4.tar.gz
-
-2. fix permissions
-   # chown -hR nobody:nogroup *
-   # chmod 711 templates users css spool
-
-Note: replace nobody:nogroup with your web server user and group
-
diff --git a/sql-ledger/doc/faq.html b/sql-ledger/doc/faq.html
deleted file mode 100644
index 5a26f64e3..000000000
--- a/sql-ledger/doc/faq.html
+++ /dev/null
@@ -1,556 +0,0 @@
-
    -

  • lineitems not printing

    -Templates designed on a *NIX platform don't work on a DOS platform. -To make them work load the template either with the builtin template editor -or a text editor and save. Templates designed on a Windows platform have the -same problem and won't work on a *NIX platform. Once you strip the ^M's -the'll work just fine. - -

    Everybody now, "Who do we thank for this schlamassl". - -

  • UTF-8 character encoding

    -Most of the translations are in ISO format. To convert the translations -change directory to locale/cc and convert the files with iconv to UTF-8. -You should also convert the COAs too and make sure you select UTF-8 -encoding when you setup a new dataset. - - -

  • characterset problems

    -If you have problems displaying the correct characterset try adding -
    -  AddDefaultCharset On
    -in your httpd.conf file. - -

  • About installation

    -The easiest is to use the setup.pl script as root. -You don't need to know very much about your system, just login as root, -run 'perl setup.pl' and follow the prompts. -

    setup.pl does not check for missing software packages and it is your -responsibilite to make sure you have the required software -installed either from source or from a package supplied with your distro. - -

    Requirements are clearly indicated in the README file and on the -download page. - - -

  • cannot create function

    -
      -
    1. either run createlang and install the plpgsql language handler or -install yourself. For more information how to do that, visit -PostgreSQL and -read the interactive documentation for procedural languages. - -
    2. load admin.pl -
    3. unlock the system -
    4. login -
    - - -

  • The requested URL /sql-ledger/admin.pl was not found

    -Your webserver doesn't know where to find the script. Most commonly this -is from distributions hiding webserver configuration files in different -locations or files and setup.pl wasn't able to configure the location for -you. Find out which file (httpd.conf, httpdcommon.conf, ...) -controls your webserver configuration and add -
    -  # SQL-Ledger
    -  Include /etc/httpd/sql-ledger-httpd.conf
    - -Create a file 'sql-ledger-httpd.conf' in /etc/httpd and copy the next part -into the file. - -
    -  AddHandler cgi-script .pl
    -  Alias /sql-ledger/ /var/www/sql-ledger/
    -  <Directory /var/www/sql-ledger>
    -    Options ExecCGI Includes FollowSymlinks
    -  </Directory>
    -
    -  <Directory /var/www/sql-ledger/users>
    -    Order Deny,Allow
    -    Deny from All
    -  </Directory>
    -replace '/etc/httpd' and '/var/www' with the appropriate directories. - - -

  • users/members : Permission denied

    -Your webserver must have write access to the users directory. -If your server runs as user/group 'apache:apache' then set the -users directory to owner/group apache:apache. -
    -  # chown -R apache:apache users
    - - -

  • Dataset newer than version

    -You are trying to use an older version with a dataset which was -created with a newer version. - - -

  • PDF option not working

    -Check if you have latex and pdflatex installed. - - -

  • Apache 2.0 "error 500"

    -Some of the early versions of Apache 2.0 (< patchlevel 44) had a rewrite engine -which decoded escaped strings. This created a lot of problems and I worked -around it by escaping strings twice. -If you get a server 500 error 'filename too long' or if collapsed menus -don't expand you may have to adjusted the following code in -SL/Form.pm and change the number (44) on line 84. -
    -  # for Apache 2 we escape strings twice
    -  if (($ENV{SERVER_SIGNATURE} =~ /Apache\/2\.(\d+)\.(\d+)/) && !$beenthere) {
    -    $str = $self->escape($str, 1) if $2 < 44;
    -  }
    - - -

  • IDENT Authentication failed for user "sql-ledger"

    -Edit pg_hba.conf and change authentication to - -
    -  local           all              trust
    - -The file is in the 'data' directory of your postgresql installation. -This is different with every distribution so look for it. -
    -  # find / -name 'pg_hba.conf'
    - - -

  • DBD-Pg for Mandrake 9.0

    -Mandrake did not package a compiled DBD-Pg package again, so install DBD-Pg -from the source package. -Install perl-DBD-Pg-1.01-4mdk.i586.rpm from the 'contrib' area. -(Mandrake / 9.0 / contrib / RPMS) - - -

  • LaTeX error

    -If for some reason LaTeX produces an error message check for strange -characters in your account description and parts description -and use \usepackage[latin1]{inputenc} in the preamble. - - -

  • LaTeX templates

    -If you don't want to edit tex code by hand, -you could use Lyx, Abiword, or any WYSIWYG editor capable of exporting -latex code. -To do that you must change the tokens for the variables <% and %> to something -like << and >>. % is the comment character in tex. There is also a -pagebreak block which must be commented out. -When you are done with the changes -replace << and >> with <% and %> and uncomment the pagebreak block. - -

    LaTeX is difficult but it also offers a much superior environment -to produce professionally looking forms in postscript and PDF format. -Unfortunately with all that power there is also a steep learning curve. - - -

  • W3M

    -pass terminal=mozilla when you start w3m -
    -  $ w3m -F http://localhost/sql-ledger/login.pl?terminal=mozilla
    - -To use without frames -
    -  $ w3m http://localhost/sql-ledger/login.pl?terminal=lynx
    - -

  • PDF option disappeared

    -Edit sql-ledger.conf and set $latex = 1; -
    sql-ledger.conf is perl code, check if it compiles, if it does not, -the internal defaults are used which turn off $latex, hence no PDF option. - -

  • SQL-Ledger installation Mac Os X 10.3 (Panther)

    -Paul J. Teeter put together - -installation instructions to run SL on a Mac. -
    The instructions are for SL 2.2 but the will work for any of the later -releases too. - -

  • Installation on Windows (WIN32)

    -
      -
    • install Apache, perl, -Postgres -or Oracle, DBI and the appropriate DBD -module -
      if you can't compile DBD-Pg here is a precompiled -DBD-Pg module -
    • download the latest version of SQL-Ledger -
    • extract the files to c:\apache\sql-ledger -
    • run 'perl shebang' to change the first line of the scripts. If perl -is not in c:\perl\bin' change '#!c:\\perl\\bin\\perl' to the location where -your perl binary is. -
    • edit c:\apache\conf\httpd.conf and add -
      -Alias /sql-ledger/ "c:/apache/sql-ledger/"
      -<Directory "c:/apache/sql-ledger">
      -  AllowOverride All
      -  AddHandler cgi-script .pl
      -  Options +ExecCGI
      -  Order Allow,Deny
      -  Allow from All
      -</Directory>
      -
      -<Directory "c:/apache/sql-ledger/users">
      -  Order Deny,Allow
      -  Deny from All
      -</Directory>
      -
      - -
    • start Apache -
    • start Postgres|Oracle|DB2 -
    • connect to http://localhost/sql-ledger/admin.pl and setup users -and datasets -
    • connect to http://localhost/sql-ledger/login.pl and login - -
    - -

  • Installation on Windows /w cygwin

    -
      -
    • install cygwin -Apache, perl, postgres, gcc and lynx -
    • install DBI -
    • tar zxvf DBI-1.30.tar.gz -
    • cd DBI-1.30 -
    • perl Makefile.PL -
    • make install -
    • install DBD-Pg -
    • tar -zxvf DBD-Pg-1.13.tar.gz -
    • export POSTGRES_INCLUDE=/usr/include/postgresql -
    • export POSTGRES_LIB=/usr/lib/postgresql -
    • cd DBD-Pg-1.13 -
    • perl Makefile.PL -
    • make install -
    • edit /etc/apache/httpd.conf and add -
      -AddHandler cgi-script .pl
      -Alias /sql-ledger/ /var/www/sql-ledger/
      -<Directory /var/www/sql-ledger>
      -  Options +ExecCGI
      -</Directory>
      -
      -<Directory /var/www/sql-ledger/users>
      -  Order Deny,Allow
      -  Deny from All
      -</Directory>
      -
      -
    • install SQL-Ledger -
    • cd /var/www -
    • mkdir sql-ledger -
    • download setup.pl and save the file -in /var/www/sql-ledger -
    • cd /var/www/sql-ledger -
    • perl setup.pl -
    - -

  • What do I enter for the language

    -If you use English, nothing, if you want to use a foreign language for -the login screen and admin stuff enter the language code, this is the -directory in the locale directory. - - -

  • printing to a printer

    -Printers are defined in sql-ledger.conf - -
    -%printers = ( 'Default' => 'lpr', 'Color' => 'lpr -PEpson' );
    - -Check in your /etc/printcap file for the names of available printers. - -

    If you have LaTeX installed set -

    -  $latex = 1
    in sql-ledger.conf - -

    To send the document to the printer check the "Postscript" or "PDF" format, -enter the number of copies and click on the "Print" button. - -

    The printer you enter in your preferences is the default printer. -You can choose any other available printer. This makes it possible -to print from anywhere on the network to any printer. - -

    Note: html format is for screen preview. Use the "Print" option from your -browser to print to a printer. - - -

  • Using samba to send printjobs to a printer attached to a Windows XP workstation

    -The next part applies to roll your own printfilters only. If you use CUPS or -LPRng your milage may vary but you can still use this as a guide how it works. -I use the printer 'Epson' as an example which is -attached to a XP workstation called Raven, no password to log on. - -
    -/etc/printcap entry on the server which runs lpd
    - 
    -epson:Epson\
    -  :sh:\
    -  :lp=/dev/null:\
    -  :sd=/var/spool/output/epson:\
    -  :if=/usr/libexec/lpr/epson/prnfilter:\
    -
    -# end of entry in /etc/printcap
    -
    -
    -# pnrfilter shell script
    -#!/bin/sh
    -# Filter for Epson Stylus
    -
    -PATH="$PATH:/usr/local/bin"
    -
    -#read first_line
    -read tmp
    -first_line=`echo $tmp | cut -b1-2 | sed -n '1p'`
    -
    -first_chr=`expr "$first_line" : '\(.\)'`
    -first_two=`expr "$first_line" : '\(..\)'`
    -rewindstdin
    -
    -if [ "$first_two" = "%!" ]; then # Postscript file
    -  gs @st640p.upp -dSAFER -dNOPAUSE -q -sOutputFile=/tmp/$$ -
    -else
    -  # text file
    -  cat > /tmp/$$
    -  echo -n "^L" >> /tmp/$$
    -  smbclient '\\Raven\Epson' "" -c 'printmode text'
    -fi
    -
    -smbclient '\\Raven\Epson' "" -P -c "print /tmp/$$"
    -rm /tmp/$$
    -
    -# EOF
    -
    -
    -rewindstdin is a small program to rewind the filehandle for STDIN
    -save the next part up to EOF to a file rewindstdin.c and compile
    -
    -#include <sys/types.h>
    -#include <unistd.h>
    -extern int errno;
    -main()
    -{
    -  if( lseek(0,0,0) == 0 ){
    -    errno = 0;
    -  }
    -  return( errno );
    -}
    -
    -# EOF
    -
    -compile to an executable
    -
    -gcc -o /usr/local/bin/rewindstdin rewindstdin.c
    -
    - - -

  • beginning balances

    -Add a GL Journal entry and enter the beginning balance for your accounts. -Beginning balances are the balances from your last balance sheet. If you also -add open invoices to account for COGS for inventory, add the invoices -and make the appropriate adjustments. - - -

  • establish a beginning inventory

    -add the parts with a vendor invoice. Use the real cost for the items, -not zero. If you use zero cost then the cost of goods will be zero when you -sell the item. - - -

  • Assemblies

    -Assemblies are manufactured goods assembled from parts, services and -assemblies. Because you do not buy assemblies you 'stock assemblies' by -adding assembled units to your inventory. The quantity for individual parts -is reduced and the quantity for the assembly increased. To disassemble an -assembly you simply return the parts to inventory by entering a negative -quantity for the number of assemblies to stock. - - -

  • customizing SQL-Ledger

    -The application interface -consists of a global and private interface. - - -

  • DBD-Pg not installed

    - -Most modern distributions now package DBD-Pg. If it is -not packaged follow this recipe to get it working. - -
      -
    • check if you have the header files for PostgreSQL -
      $ find / -name 'libpq-fe.h' -
      if nothing shows up install the development package for PostgreSQL -
    • download and untar DBD-Pg -
    • set the environment variables POSTGRES_LIB and POSTGRES_INCLUDE -
    • cd to DBD-Pg directory -
      as ordinary user -
      $ perl Makefile.PL -
      $ make -
      $ make test -
      if all went well su to root -
      # make install -
    • remove DBD-Pg -
    - - -

  • login.pl has compilation error

    - -This could be because of a missing configuration file in the users directory - -

    check the permission for the users directory. The directory must be -set writeable for the webserver. If your webserver runs ias user/group -nobody.nogroup set the directory to -

    -drwx--x--x   2 nobody   nogroup    1024 May 26 16:49 users
    -
    -or
    -
    -drwxrwx--x   2 johndoe  nogroup    1024 May 26 16:49 users
    - - -

  • script not executing, shows in browser instead

    - -Add -
    -  AddHandler cgi-script .pl
    -in your httpd.conf file. - - -

  • unknown terminal!

    -the frontend script couldn't figure out which browser you are using -

    include the terminal variable on the URL -

    -  http://localhost/sql-ledger/login.pl?terminal=lynx
    -Valid terminal variables are lynx and mozilla - - -

  • permission denied

    - -Check if your web server has write permission to write to the following -files and directories: -
    -  users/
    -  templates/
    -  users/members
    -
    -  # chown nobody:nogroup users templates users/members
    -
    - - -

  • permission denied to access tables

    -The user you entered in the "Database section" must be a valid -database user who has rights to access the tables. - -

    If the tables are owned by 'joe' and you enter 'mary' as the dba -you might run into this problem if mary doesn't have the rights to -access tables owned by joe. - - -

  • html and graphics files don't show up on screen

    - -Enable Includes and FollowSymlinks Options in your httpd.conf file -
    -  <Directory /usr/local/sql-ledger>
    -    Options ExecCGI Includes FollowSymlinks
    -  </Directory>
    -
    - - -

  • Can I use mySQL

    - -mySQL lacks certain features required by SQL-Ledger. - - -

  • switch display to a foreign language

    - -Load your preferences and select the language. -
    Language selection is in accordance to - -ISO 3166-1 standards. - - -

  • Text shows in English when I use a foreign language

    - -This is because the corresponding hash entry is missing. -Add the missing text in the locale/cc/all or locale/cc/missing -file and run 'perl locales.pl' from the command line to rebuild -the individual files. - -
    cc refers to the country code. - - -

  • switch to a foreign language for the login and admin screen

    - -Edit sql-ledger.conf and enter the code for the $language variable -
    -  $language = "de";
    - -

    This is a global change and applies to all logins, individual settings -may be changed by setting the language in your Preferences. - - -

- -

-


- -

SQL-Ledger security

-
- -
    -
  • The security features built into SQL-Ledger provide encrypted passwords -and access control which makes it fairly safe out of the box to run even in -front of a firewall. -Some precautions which are out of our control must be taken though. -It matters where you install SL and how you configure your web server and -SQL server. - -
    -  Typical setups:
    -  
    -  /usr/local/vh/www                   <- DocumentRoot for virtual host
    -  /usr/local/vh/sql-ledger            <- Alias for sql-ledger
    -  /usr/local/vh/users                 <- users directory out of reach
    -
    -
    - /usr/local/vh/www <- DocumentRoot for virtual host - /usr/local/vh/www/sql-ledger <- Alias for sql-ledger - /usr/local/vh/www/sql-ledger/users <- users configuration files and tmp space - - <Directory /usr/local/vh/www/sql-ledger/users> <- disable webserver access - Order Deny,Allow for users directory - Deny from All - </Directory> - -
    - -The location for the users directory can be specified in sql-ledger.conf - -

  • Set permission for the users and templates directory to 711 - -

  • If you do not want anyone to change the templates with the built-in -editor set the files in templates/directory/ to read only or disable -the menu item to edit the templates. - -

  • You may setup a read-only environment if you disable the menu items -to add data. i.e 'Add Transaction' if unchecked you will not be able to add -a transaction or repost a transaction. You may look at it but nothing else. - -

  • There are various settings for audit control and you may disable -reposting entirely or up to a certain date. - -

  • For PostgreSQL you may also set who has access to the server in the file -pg_hba.conf -
    Authentication crypt does not work because not all SQL servers -accept encrypted passwords. - -

  • in addition you can secure the tables from unauthorized access by -setting up a different database user and GRANT rights. For instance, -users without DELETE rights will still be able to use the program, change -customers and vendors, add transactions but will not be able to delete or -repost transactions. -
    To lock all the tables to create a RO system GRANT SELECT rights only. - -

  • Other security options include a secure shell, your webserver's -authentication system, SSL, encrypted tunnels, ... - -
- - - - -- cgit v1.2.1