Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
passworddatabaserecovery
6 Odgovori
12555 Prikazi
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
Opusti
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
Opusti
Avatar
John Doe
Avtor 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
Opusti
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
Opusti
John Doe
Avtor

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
Avtor

Fabrice, thank you so much. :)

Related Posts Odgovori Prikazi Aktivnost
Admin password reset not working, tried database, odoo.conf
password database admin
Avatar
Avatar
2
maj 25
3899
Retrieving Master Database Password
password database master
Avatar
Avatar
Avatar
2
dec. 15
10244
Postgres server password inside openerp-server.conf file!! Solved
security password database
Avatar
Avatar
Avatar
2
dec. 23
33981
Master password for database Solved
password database masterpasswort odooV8
Avatar
Avatar
1
okt. 20
4759
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
5947