Skip to Content
Menu
This question has been flagged
2 Replies
137 Views

A friend of mine has a windows installation of Odoo 16 in a pc at his work. He wanted to backup the db, but he's lost and doesn't remember the database manager password.

I've read that in this case, you can simply change the database manager password in odoo.conf with a new one in plaintext. Is this safe? Because the database data is crucial (it's patients data, he is a doctor). Is there any possibility that he will lose connection with the database or the db will be erased?

Also, I've read that the database manager password in odoo.conf is sha encrypted. Can it be replaced with a plain text one?

Lastly, in Odoo 16 windows, where is odoo.conf located?

Avatar
Discard
Best Answer

Hi,


Yes, it’s totally safe to change the database manager password by editing odoo.conf — it won’t affect your data at all.


Just open odoo.conf and look for the line that says admin_passwd.

Replace the value with a new password in plain text like this:


admin_passwd = mynewpassword

This password is not encrypted, and that’s normal. Odoo stores it in plain text in the config file.


Changing it won’t disconnect or delete your database — it only changes the password used to access the database management screen (where you can create, restore, or drop databases).


Once you save the file, restart the Odoo server, and you’ll be able to log into the database manager with the new password.


On Windows, where is odoo.conf?

If your friend used the standard Odoo installer, it’s usually here:


C:\Program Files (x86)\Odoo 16.0\server\odoo.conf


Hope it helps

Avatar
Discard
Best Answer

The value of admin_passwd in odoo.conf can be simply replaced by the text-representation of your desired, new password for interactions with /web/database/manager, yes.

Upon restarting the server, Odoo should automatically encrypt it again.

About "Is there any possibility that he will lose connection with the database or the db will be erased?" - no, the admin_passwd's sole purpose is to prevent unauthorized access to the GUI of /web/database/manager actions.

Note: There are cases, where the encryption does not happen automatically, in that case you could simply read the password from the file.


Where exactly the odoo.conf file is located depends on your setup. A installation from source (i.e. if you've downloaded a zip or cloned the github repository) could be anywhere. A installation using the executable (.exe) also allows you to specify the path of installation. By default it should be something like C:\Program Files (x86)\Odoo 16.0\server\odoo.conf (but it's  along while since I've installed Odoo on a Windows machine, so just look out for common folders) - you should find the file in there.

Avatar
Discard
Related Posts Replies Views Activity
5
Jul 24
89127
2
Mar 15
5979
0
May 25
752
13
Sep 24
190366
2
Jul 24
11953