summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-03-09 17:22:09 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2007-03-09 17:22:09 +0000
commitcd78581fa2d16e3d712b7a44580c60ac1fc63f86 (patch)
tree52737725c737422d239fd201097b5986392044b7
parentee1c5266cccb0f6c03f3371b273a73907656c5e3 (diff)
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
-rw-r--r--INSTALL32
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;