Skip to Content
Menu
This question has been flagged
13 Replies
189782 Views

Hello,

Issue: forgot master password

In openerp database management where we able to change password.

I have changed the default master password to another, now I have forget it.

Please let me know how can I recover it.

thanks, urgent.

Avatar
Discard

So you are talking about recovering the Administrator password, not the Master Database password?

I edited your question and removed my answer.

Best Answer

If you have access to openerp-server.conf (your active OpenERP server config file). e.g: /etc/openerp-server.conf

The password is written anywhere in that file:

admin_passwd = ********


Video: https://www.youtube.com/watch?v=SJlM6jUslxk

Avatar
Discard

The config file is also read from ~/.openerp_serverrc

Author

I have update it dynamically from database admin panel, till not able to recover.

Have you tried restarting the server with the admin_passwd set in your conf file?

Author Best Answer

.openerp_serverrc

Default admin master password is stored in openerp-server.conf

but its not given forgotten one.

Master password for openerp will found at .openerp_serverrc file.

Which located at home directory

Open Terminal

user@ubuntu: cat .openerp_serverrc [options] addons_path = -------------------
admin_passwd = admin
csv_internal_sep = ,

Here you found your master admin password.

Avatar
Discard

Perfect... I solved by using your solution.

Thanks,

Best Answer

For those in windows, inside the Odoo installation folder, just go to the "server" folder/directory and you'll find the odoo.conf

Avatar
Discard
Best Answer

Just change the admin_passwd in odoo.conf, it work for me !

Avatar
Discard

It's worked for me. Thanks.

Best Answer

video reference here


Avatar
Discard
Best Answer

I just comment the entry of admin_pass and reload manager link and config file was rewritten so we can rewrite admin_pass

Avatar
Discard
Best Answer

in your openerp-server.conf, comment line that contain admin_passwd = , then open your odoo. you will be asked to set new master password

if you change it manually on openerp-server.conf, your password will be saved as plain text, not encrypted

Avatar
Discard
Best Answer

i changed the admin passwd in conf file in windows and restart odoo service but error database connection denied is still coming

Avatar
Discard
Best Answer

There is an confusing mix of terminoly from odoo since:

The "master password" is named "admin_passwd" in the config file (usually, "odoo.conf".) This leads to confusion, since there is no "master" user anywhere in Odoo.

The "database admin" password (one for each indiviual database) is stored (Odoo 12+) inside the postgres database. It's also encrypted, so you can only clear it and reset it in the web interface.

The admin IS the master.

Avatar
Discard
Best Answer

refer this link...

https://www.odoo.com/forum/help-1/question/recovering-master-password-73750#answer-73755


Avatar
Discard
Best Answer

Hi, you can check out if you can get solution from SmartKey Password Recovery Bundle: http://www.recoverlostpassword.com

Avatar
Discard
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)

  SELECT login, password FROM res_users WHERE login = 'admin';
Avatar
Discard
Author

Sorrry U got miss understanding, I am talking about master password.

Best Answer

Please refer to the answers to this question: https://accounts.openerp.com/forum/Help-1/question/478/

Avatar
Discard
Author

link does not helpfull to reset master password.

I saw Yohanes' correct response, and suggested my answer to a related question as additional reading to help with a broader understanding. You have ambiguous terminology that confused Yannick. The answer I refer to attempts a disambiguation of the different password type names.

If it's additional reading, it shouldn't be posted as an Answer. It would be best to add this as a Comment wither to the question, or to a correct answer.

Related Posts Replies Views Activity
0
Oct 24
681
2
Jul 24
11877
1
Mar 15
5392
3
Mar 15
10277
3
Mar 15
8693