Added troubleshooting section to INSTALL for access denied error

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@869 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 31 insertions, 1 deletions

diff --git a/INSTALL b/INSTALL
index f62fbb68..ccc8c5a7 100644
--- a/INSTALL
+++ b/INSTALL
@@ -25,9 +25,12 @@ recommend as follows:
   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.
+  d) If you are going to put your data here too, run the following command:
+	CREATE LANGUAGE PLPGSQL;
 
   Note that the psql connection should use the same username that you intend to
-  use for the user authentication connection.
+  use for the user authentication connection.  If you use a different username
+  you may find that you get an Access Denied message.
 
 4)  Set the admin password:
   a)  From psql, determine what admin password you wish to use.  Then type:
@@ -57,3 +60,30 @@ and may not be required in all circumstances.  These include:
   * Net::TCLink for credit card processing in a POS environment
   * Parse::RecDescent for the CLI script host
 
+
+
+TROUBLESHOOTING
+===========================================================================
+Error:  Access Denied in admin.pl
+
+Likely causes:
+1)  The password entered may not match the password set in step 4.  You can 
+    repreat that step prior to the creation of user accounts as often as you 
+    wish.
+
+    After the creation of user accounts, the commant to reset the admin password
+    is:
+    UPDATE users_conf SET password=mp5('password') WHERE id = 
+        (select id FROM user WHERE username = 'admin');
+
+    Of course, substitute 'password' for your chosen password.
+
+2)  The central database may have been created with a different user than you 
+    are using for the connection and you may not have permission to access the
+    required database entities.  To correct this, assuming that the desired 
+    database username is ledgersmb, the following commands from psql:
+      GRANT ALL ON users TO ledgersmb;
+      GRANT ALL ON users_id_seq TO ledgersmb;
+      GRANT ALL ON users_conf TO ledgersmb;
+      GRANT ALL ON session TO ledgersmb;
+      GRANT ALL ON session_session_id_seq TO ledgersmb;