Odoo Help


11 Answers

Martin Canada


| 6 6 10
Cornwall, Canada

Analysing, designing, coding and mentoring since 1975. Kilobytes to terabytes. Punch cards to punchy sites. My OpenERP video series: http://www.youtube.com/playlist?list=PLq7op4J183lX44ZlXPiHxUpRvmmRDtxye My Google Speadsheets --> OpenERP Data Pump project: http://martinhbramwell.github.io/GData_OpenERP_Data_Pump My email (with spaces removed) : mhb . warehouseman @ gmail . com

Martin Canada
2/8/13, 9:01 AM

To understand how this works you have to picture three different "entities" talking to each other: your browser, the OpenERP server and the database server.

When you start up OpenERP, before any users connect, it needs to be able to get into the database server and load up the list of all available databases. So, OpenERP needs its own password.

When the OpenERP administrator creates or drops databases, he/she needs a password that is NOT known by the many possible administrators of individual databases.

When an administrator uses a browser to connect to the OpenERP server, the first step is to choose a single database for use. Each database is managed separately, and possibly by different administrators. The user can only gain administrative access to the databases for which he/she knows the specific admin password.

In other words, you actually have three passwords:

  1. The password OpenERP uses to get into PostgreSQL. It is known as "db_password" in the OpenERP configuration file.
  2. The password the site administrator uses to control all the databases; the Master password. It is known as "admin_password" in the OpenERP configuration file.
  3. The password an individual database administrator needs to have full control over a single database; the Admin password. This is stored, along with all the other database users, inside the database itself.

Caveat : This is true of 6.1 (and just about every 3-tier system I've ever seen), it MAY have changed for 7.0, but I'll leave it to someone else to slap me down if I'm wrong.

To see an Admin password you can follow these steps (tried in 6.1):

you:-$ # Take on postgres user privileges
you:-$ sudo -sHu postgres
postgres:-$ # Start up the PostgreSQL command line.
postgres:-$ psql -d yourDataBaseName
psql (9.1.7)
Type "help" for help.

yourDataBaseName=: # Query the user table
yourDataBaseName=: select login, password from res_users;
 login | password 
 rick  | rick123
 admin | WheyHaarD4u2Guess
(2 rows)

delentef France
2/9/13, 12:08 PM

Thanks for the answer, however there is still something I don't understand: what is the administrator's identifier (or login in unix parlance)? Is it 'root'? is it 'postgresql'? is it 'openerp'? On the 'Create Database' page of openERP, whose password is the Master Password? and whose password is th

Camptocamp SA Switzerland
2/10/13, 6:27 AM

On database creation, you must set:

  • in Master Password the password used to connect to postgresql. It can be found as admin_password in your conf file.
  • in Admin Password the password that will be created for the new admin OpenERP user in the new database.
Martin Canada
2/10/13, 7:44 AM

Yannick is correct. I'd add that you can't have different master passwords for multiple super-users; with just one per installation, the OpenERP super-user needs no 'identifier' per se. You could run your site with Unix user name and group openerp:openerp, but that is a different issue.

test India
2/11/13, 12:47 AM

Unable to recover forgot master password. ? any steps to recover ?

Camptocamp SA Switzerland
2/11/13, 5:45 AM

Charlie, your already asked how to recover the password here: How to recover master password if I forgot it? And you have some answers.

test India
2/11/13, 6:21 AM

Yannick: this url linked over their, but till not correct answer to fix it.

Does any rule to don't comment here ? FK

Camptocamp SA Switzerland
2/11/13, 8:47 AM

Well, the idea is to have one question per topic. Let's try solving your issue in your question, not here :)

Kallerhan Netherlands
8/10/17, 3:58 AM

The difference is not big, but the scope of administrator's password should be extensive, if you forget or lost your admin password ,and you unable to access your computer ,  the other admin account password can unlock Windows password and reset a new admin password . all i know about the admin password ,


Hince Vezel Canada
11/29/16, 4:20 AM

You can reset the login password on any Windows with this guide: http://www.uukeys.com/unlock-remove-windows-8-10-password.html

Ask a Question
Keep Informed
1 follower(s)
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.

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now