Odoo Help
Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM
|
e-Commerce
|
Accounting
|
Inventory
|
PoS
|
Project management
|
MRP
|
etc.
Enable password recovery from database
I have locked myself out of my OpenERP by forgetting my password (doh!) so as topic says I need to enable password recovery directly within the database. In which table etc. can I do it?
Btw, I am using the auth_crypt module so I cannot just simply recover my old password by looking in res_users.
Thanks in advance
If you are talking about the OpenERP admin user password, you can recover it if your database passwords aren't encrypted. (as for any other OpenERP user password)But I recommend you can follow some related articles like the The Best Online Available Password Manager For Database: http://www.passwordmanagers.net/The-Best-Online-Available-Password-Manager-For-Database.html.
I believe you can get some free and useful tips about master password recovery.
For the basic protection of Password Manager For Web Database, you can follow to http://www.passwordmanagers.net/Password-Manager-For-Web-Database.html.
Normally what you do is provide in the clear text section of the database that looks like random text in the password field is a string of random text that matches a password that is known to decode to a known password.
An example in the context of PostgreSQL http://postgresql.1045698.n5.nabble.com/Algorithm-for-generating-md5-encrypted-password-not-found-in-documentation-td4919082.html
You cannot decode a hash - you can use a rainbow table to do a lookup but with a salt that is almost not possible. And further the hashing is not done by PostgreSQL but by the auth_crypt module which from what I know is not the same as the simple integrated MD5 hashing function in PostgreSQL.
I simply want to know where I can enable the password recovery (from the login screen) in the database. Which table and row do I need to edit? (I do not want to waste time RE the auth_crypt module so I can create a new MD5 hash based on what ever salt the module is using.)
The object is base.config.settings and the field is auth_signup_reset_password
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.
RegisterOdoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it nowQuestion tools
Stats
| Asked: 1/25/14, 11:19 AM |
| Seen: 3172 times |
| Last updated: 7/9/17, 9:51 PM |