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 | etc.
I've install Odoo 8 on my laptop (Ubuntu 16.4) few days ago. And I forget the administrator password to access to the DB. I tried to recover it from "/etc/odoo/openerp-server.conf", but it's not working??
Bellow, my configuration file:
; This is the password that allows database operations:
; admin_passwd = admin
db_host = False
db_port = False
db_user = odoo
db_password = False
addons_path = /usr/lib/python2.7/dist-packages/openerp/addons
Please do have any solution to this issue?
Thank you in advance.
Odoo system has three different passwords:
1) Paremeter admin_passwd in openerp-server.conf
This password allows you to manage databases, when you browse address
localhost: 8069 / web / database / manager
In this case, to set new: Remove the semicolon at the line start, set your password and restart odoo.
2) Paremeter db_password in openerp-server.conf
This is the password of role with name odoo in postgresql (parameter db_user = odoo in openerp-server.conf)
In this case, to set new, see https://www.postgresql.org/docs/9.0/static/sql-alterrole.html
In your case this password probably is empty (db_password = False)
3) Main Odoo user password, user with login = admin (or with your email).
In this case, to set new, replace the password and hash in the database with the new one by running this SQL query:
UPDATE res_users SET password = "NEW_PASSWORD",password_crypt = NULL WHERE id=1;
To retrieve login:
SELECT login, password FROM res_users WHERE id=1;
IMPORTANT!!! After update res_users (after setting NEW_PASSWORD) you login to Odoo and set new password again (If you need crypted password in database)
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 8/26/16, 8:43 AM|
|Seen: 4307 times|
|Last updated: 2/26/18, 1:29 AM|