Skip to Content
This question has been flagged
passworddatabaserecovery
6 Replies
12285 Views
Avatar
John Doe

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

Avatar
Discard
Avatar
parkwayma
Best Answer

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.

Avatar
Discard
Avatar
John Doe
Author Best Answer

Btw, I am using the auth_crypt module so I cannot just simply recover my old password by looking in res_users.

Avatar
Discard
Avatar
marc
Best Answer

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

Avatar
Discard
John Doe
Author

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.)

Fabrice Henrion (fhe)

The object is base.config.settings and the field is auth_signup_reset_password

John Doe
Author

Fabrice, thank you so much. :)

Related Posts Replies Views Activity
Admin password reset not working, tried database, odoo.conf
password database admin
Avatar
Avatar
2
May 25
3350
Retrieving Master Database Password
password database master
Avatar
Avatar
Avatar
2
Dec 15
10018
Postgres server password inside openerp-server.conf file!! Solved
security password database
Avatar
Avatar
Avatar
2
Dec 23
33745
Master password for database Solved
password database masterpasswort odooV8
Avatar
Avatar
1
Oct 20
4542
DB Admin password reset each time we update Odoo 8. Isn't it stored in the database? Solved
password database admin odoo8
Avatar
Avatar
1
Sep 16
5770