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.
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
This question has been flagged
10
Replies
174422
Views
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 = ********The config file is also read from ~/.openerp_serverrc
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?
.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.
Perfect... I solved by using your solution.
Thanks,
Just change the admin_passwd in odoo.conf, it work for me !
It's worked for me. Thanks.
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
i changed the admin passwd in conf file in windows and restart odoo service but error database connection denied is still coming
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.
refer this link...
https://www.odoo.com/forum/help-1/question/recovering-master-password-73750#answer-73755
Hi, you can check out if you can get solution from SmartKey Password Recovery Bundle: http://www.recoverlostpassword.com
Please refer to the answers to this question: https://accounts.openerp.com/forum/Help-1/question/478/
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.
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';
Sorrry U got miss understanding, I am talking about master password.
So you are talking about recovering the Administrator password, not the Master Database password?
I edited your question and removed my answer.
See: https://www.youtube.com/watch?v=SJlM6jUslxk