Odoo Help


How can I log back in to Odoo, with the Administrator Account? Odoo asking for admin email instead of username

Francis Wafula
on 8/8/14, 9:45 AM 34,905 views

I have just finished setting up the onsite version of Odoo, it was working great, but I  logged myself out, thinking it will be simple to log back in. I still have the master password for the administrator, but now that login (http://localhost:8069) is not showing as before and instead it is now a company website asking for an email and password to login instead of the default prompt asking for username; password. How do I log back in?

I also found this problem as well. Could anyone help me to solve this issue? Lerdlop

Lerdlop Khumsri
on 10/6/14, 9:00 AM

Hi Lerdlop, read my post below, should work for you.

Francis Wafula
on 10/7/14, 7:04 AM
Francis Wafula
On 8/8/14, 10:05 AM

Hi, I just found the solution, my admin password was okay; The problem was that once you add the administrator email, (settings-> users -> administrator) the administrator username also changes from the default 'admin' to the email you have put and 'admin' does not work for login anymore. I used the followin postgresql query to confirm my new username and password. Unfortunately I can't post the link as I don't have enough karma.

1. Take on postgres user privileges

you:-$ sudo -sHu postgres 

2. Start up the PostgreSQL command line with the list command to list all databases;

postgres:-$ psql -l (not a 1 but a small L)

 Name       |  Owner      | Encoding |   Collate         |    Ctype         |   Access privileges   
 odoo1       | openerp     |    UTF8   | en_US.UTF-8 | en_US.UTF-8 | 
 postgres   | postgres    | UTF8      | en_US.UTF-8  | en_US.UTF-8 | 
 template0 | postgres     | UTF8      | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
                |                   |               |                      |                      | postgres=CTc/postgres
 template1 | postgres     | UTF8      | en_US.UTF-8  | en_US.UTF-8 | =c/postgres          +
                 |                  |               |                      |                       | postgres=CTc/postgres


3. identify the database that is for your openerp. For me it was easy as the owner was "openerp", and the name "odoo1"

4. Fire up the PostgreSQL command line and select your database as below; use database identifed from step 3.

postgres:-$ psql -d odoo1

psql (9.3.4)

Type "help" for help.

5. Query your database by asking it to display all logins, passwords from the table "res_users". This is the odoo store for logins and passwords

yourDataBaseName=#Query login, password from table, 

odoo1=# select login, password from res_users;

      login        | password


   rick                | rick123

admin@bit.co.ke | WheyHaarD4u2Guess

(2 rows) 


With the latest release of Odoo 8.0, you can no longer see the passwords in plain text. They are now encrypted -- which is a VERY GOOD thing!

Kelly Stuart
on 10/7/14, 7:17 PM
David Dean
On 10/6/14, 9:13 AM

Although the username field is labelled "Email" you can still login with your username. I often login with my Odoo username (e.g. 'admin') with no problems.

Thank you David. I get it.

Lerdlop Khumsri
on 10/6/14, 9:26 AM

Indeed. I think they made this slightly confusing for most people.

on 10/6/14, 10:18 AM

David, THIS is the answer I have been searching for! A million thanks! :) For a new install Odoo 8.0, use "admin" as the Email and the password for the database to log in. This was giving me fits as it's not explained anywhere in the docs. You're a life saver.

Sandy Walker
on 11/12/14, 11:13 AM
On 7/13/16, 3:01 AM

Thank you Francis, you saved me!!

On 9/24/15, 2:03 PM

Saved my life!

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

Question tools

5 follower(s)


Asked: 8/8/14, 9:45 AM
Seen: 34905 times
Last updated: 7/13/16, 8:24 AM