Odoo Help

1

How to recover the Admin password

By
Maarir
on 8/26/16, 8:43 AM 1,072 views

Hi Experts,

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:

[options]

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


Hi,

Thank you for your quick answer, but unfortunately it still not working!! 

Maarir
on 8/26/16, 10:09 AM
1

Ray Carnes

--Ray Carnes--
16599
| 9 7 9
Atlanta, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0.

Completed Odoo Functional and Technical Training.

Major Skills:

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 8/26/16, 2:00 PM

If you or someone else changes the admin password via the User Interface (by clicking SET MASTER PASSWORD), then it is stored in a file called .openerp_serverrc which is stored in the home folder of the user account used to run the Odoo service.

1

Zbik

--Zbik--
6253
| 6 4 7
Lodz, Poland
--Zbik--


Zbik
On 8/26/16, 11:12 AM

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)

1

Ermin Trevisan

--Ermin Trevisan--
4452
| 6 4 7
Walchwil, Switzerland
--Ermin Trevisan--


Ermin Trevisan
On 8/26/16, 9:37 AM

Your admin password is commented out. Remove the semicolon at the line start and restart odoo.

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

Question tools

1 follower(s)

Stats

Asked: 8/26/16, 8:43 AM
Seen: 1072 times
Last updated: 8/31/16, 3:23 AM