[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:  branches/1.2/INSTALL
- Subject: SF.net SVN: ledger-smb:  branches/1.2/INSTALL
- From: ..hidden..
- Date: Fri, 09 Mar 2007 09:22:09 -0800
Date: 2007-03-09 09:22:09 -0800 (Fri, 09 Mar 2007)
Added troubleshooting section to INSTALL for access denied error
--- 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
+Error: Access Denied in admin.pl
+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
+ After the creation of user accounts, the commant to reset the admin password
+ 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.