SF.net SVN: ledger-smb: [936] branches/1.2

[..hidden..]

Revision: 936
          http://svn.sourceforge.net/ledger-smb/?rev=936&view=rev
Author:   einhverfr
Date:     2007-03-17 15:12:29 -0700 (Sat, 17 Mar 2007)

Log Message:
-----------
Updated INSTALL based on Jeffk's suggestions

Modified Paths:
--------------
    branches/1.2/CONTRIBUTORS
    branches/1.2/INSTALL

Modified: branches/1.2/CONTRIBUTORS
===================================================================
--- branches/1.2/CONTRIBUTORS	2007-03-17 22:05:45 UTC (rev 935)
+++ branches/1.2/CONTRIBUTORS	2007-03-17 22:12:29 UTC (rev 936)
@@ -52,7 +52,7 @@
 
 Chifung Fan [email omitted] contributed bugfixes.
 
-
+Jeff Kowalczyk [email omitted] contributed to the INSTALL documentation.
 Original Authors of SQL-Ledger:
 ===================================
 Dieter Simader <dsimader @ sql-ledger.com>

Modified: branches/1.2/INSTALL
===================================================================
--- branches/1.2/INSTALL	2007-03-17 22:05:45 UTC (rev 935)
+++ branches/1.2/INSTALL	2007-03-17 22:12:29 UTC (rev 936)
@@ -24,33 +24,51 @@
   a)  Single dataset installations should use the user tables in the dataset.
   b)  Multicompany installations should use user tables in a separate dataset
       from any accounting data.
+To be integrated into the documentation, these minimalist steps have made
+installation/migration of ledger-smb much easier for me:
 
-3)  Create central database
 
-  a) cd to the sql/ directory of the new ledger directory.
-  b) run "psql" with appropriate options to connect to your database.
-  c) Run the SQL script Pg-central.sql.
-        From psql, the command is:  \i /path/to/Pg-Central.sql
-  d) If you are going to put your data here too, run the following command:
-	CREATE LANGUAGE PLPGSQL;
+3) Create a admin database role named 'ledgersmb':
 
-  Note that the psql connection should use the same username that you intend to
-  use for the user authentication connection.  If you use a different username
-  you may find that you get an Access Denied message.
+    bash$ createuser --no-superuser --createdb --no-createrole -U postgres
+     --pwprompt --encrypted ledgersmb
 
-4)  Set the admin password:
-  a)  From psql, determine what admin password you wish to use.  Then type:
-      "update users_conf set password = md5('my_password');"
-      Naturally you would use your password instead of my_password.
 
+4) Create a central user database database, owned by admin role:
 
-5)  Edit the ledger-smb.conf file as appropriate.
+    bash$ createdb -U ledgersmb -O ledgersmb ledgersmb
+
+
+5) Run the included SQL commands to configure the central user database:
+
+    bash$ psql -U ledgersmb -d ledgersmb -f (ledgerpath)/sql/Pg-central.sql
+
+
+6) Update your admin password in the central user database
+    (change MYPASSWORD to your preferred administrative password).
+
+    bash$ psql -U ledgersmb -d ledgersmb
+
+    ledgersmb=> UPDATE users_conf SET password = md5('MYPASSWORD') WHERE id = 1;
+
+7) Quit the interactive SQL console:
+
+    ledgersmb=> \q
+
+Configure apache, visit admin.pl, login with MYPASSWORD, create datasets
+with user ledgersmb, superuser postgres, create users pointing to datasets,
+etc.
+
+
+8)  Edit the ledger-smb.conf file as appropriate.
   a)  Make sure to set the section under GlobalDBH to point to hte databae you
       imported Pg-central into.
-Congratulations, you have manually installed LedgerSMB 1.2.
 
-6)  Check Dependencies
+9)  Add configuration to Apache:
+    bash$ sh configure_apache.sh
 
+10) Check Dependencies
+
 The Build.PL script can be used to test for unmet dependencies and run other
 tests.  It doesn't install anything yet, but it will tell you what you are 
 missing.  To check for dependencies, run "perl Build.PL" from the command line.
@@ -68,7 +86,16 @@
   * Net::TCLink for credit card processing in a POS environment
   * Parse::RecDescent for the CLI script host
 
+11) Restart Apache (instructions may vary with your Linux distro).
 
+12) Create Datasets and Users:
+   Visit http://hostname/ledger-smb/admin.pl, login with MYPASSWORD, 
+   Create datasets with user ledgersmb, superuser postgres
+   Create users pointing to datasets.
+
+Congratulations, you have manually installed LedgerSMB 1.2.
+
+
 FTP INSTALLATION:
 ============================================================================
 If you control the server and have shell access, the


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.