Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
13 Replies
189843 Tampilan

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
Buang

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

I edited your question and removed my answer.

Jawaban Terbai

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
Buang

The config file is also read from ~/.openerp_serverrc

Penulis

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?

Penulis Jawaban Terbai

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

Perfect... I solved by using your solution.

Thanks,

Jawaban Terbai

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

Avatar
Buang
Jawaban Terbai

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

Avatar
Buang

It's worked for me. Thanks.

Jawaban Terbai

video reference here


Avatar
Buang
Jawaban Terbai

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

Avatar
Buang
Jawaban Terbai

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
Buang
Jawaban Terbai

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

Avatar
Buang
Jawaban Terbai

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
Buang
Jawaban Terbai

refer this link...

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


Avatar
Buang
Jawaban Terbai

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

Avatar
Buang
Jawaban Terbai

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

Avatar
Buang
Penulis

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.

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)

  SELECT login, password FROM res_users WHERE login = 'admin';
Avatar
Buang
Penulis

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

Post Terkait Replies Tampilan Aktivitas
0
Okt 24
685
2
Jul 24
11883
1
Mar 15
5393
3
Mar 15
10278
3
Mar 15
8700