Skip ke Konten
Pertanyaan ini telah diberikan tanda
passworddatabaserecovery
6 Replies
12342 Tampilan
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
Buang
Avatar
parkwayma
Jawaban Terbai

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
Buang
Avatar
John Doe
Penulis Jawaban Terbai

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

Avatar
Buang
Avatar
marc
Jawaban Terbai

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
Buang
John Doe
Penulis

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
Penulis

Fabrice, thank you so much. :)

Post Terkait Replies Tampilan Aktivitas
Admin password reset not working, tried database, odoo.conf
password database admin
Avatar
Avatar
2
Mei 25
3432
Retrieving Master Database Password
password database master
Avatar
Avatar
Avatar
2
Des 15
10067
Postgres server password inside openerp-server.conf file!! Diselesaikan
security password database
Avatar
Avatar
Avatar
2
Des 23
33782
Master password for database Diselesaikan
password database masterpasswort odooV8
Avatar
Avatar
1
Okt 20
4589
DB Admin password reset each time we update Odoo 8. Isn't it stored in the database? Diselesaikan
password database admin odoo8
Avatar
Avatar
1
Sep 16
5800