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

[..hidden..]

Revision: 869
          http://svn.sourceforge.net/ledger-smb/?rev=869&view=rev
Author:   einhverfr
Date:     2007-03-09 09:22:09 -0800 (Fri, 09 Mar 2007)

Log Message:
-----------
Added troubleshooting section to INSTALL for access denied error

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

Modified: branches/1.2/INSTALL
===================================================================
--- branches/1.2/INSTALL	2007-03-09 00:24:09 UTC (rev 868)
+++ branches/1.2/INSTALL	2007-03-09 17:22:09 UTC (rev 869)
@@ -25,9 +25,12 @@
   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 @@
   * 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;


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