Odoo Help

14 Answers

Alexandre Fayolle - Camptocamp

--Alexandre Fayolle - Camptocamp--

| 5 6 8
Le Bourget-du-Lac, France
--Alexandre Fayolle - Camptocamp--

Alexandre has been working on Odoo at Camptocamp since 2012 as a project manager and technical lead. He is an active actor in the Odoo Community (github projects, mailing lists, IRC...), and wants to build a better ecosystem for Odoo developers. He is a member of the Odoo Community Association board and an active contributor to the OCA projects.

Alexandre Fayolle - Camptocamp
2/5/13, 10:53 AM

If you have access to the database, you can read it with the following SQL query:

select password from res_users where login='admin';

On the other hand, if you have admin access to OpenERP (which requires having the password, which may be too late for you...) you can go to Settings -> Configuration -> General settings, and in the "Portal Access" section, check the "Enable password reset from login page" option. Then you will get a "reset password" link from the login page which will send a link by email to the email address linked with the user attempting to log in, if you have also configured the email gateway. This works in V7.

Camptocamp France SAS, Alexandre Fayolle - Camptocamp
2/8/13, 4:51 AM

Sorry, I had not noticed Christophe Simonis answer saying basically the same thing as my edited answer.

2/11/13, 12:45 AM

The SQL query will work only if 'Password Encryption' module is not installed, otherwise result will be encrpyted (and hence not useful).

Jairo Llopis
12/12/13, 12:51 PM

To do it through one command line just type sudo -u openerp psql --dbname <database> --command "select password from res_users where login='admin';".


Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
| 7 7 9
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo Americas

Fabrice Henrion (fhe)
2/5/13, 2:45 PM

In OpenERP 7, go to Settings > Users and select the user you want to reset the password for. You will see a button labeled "Reset password" in the top right corner that will send an email to the email address of the user with a new password.
An email smtp server needs to be set up in OpenERP for this to work.

1 Comment
Camptocamp SA, Guewen Baconnier
2/8/13, 3:37 AM

He lost the admin user's password, so he can't connect.


Since version 7.0 this functionality is provided by the module auth_signup.

Once installed you need to go to Settings > General Settings and check the option Enable password reset from Login page.

As Fabrice said, you need to have a outgoing email server configured.

2/11/13, 12:49 AM

Reset password, even if Email is not configured.

In OpenERP 7, go to Settings > Users and select the user you want to reset the password for. In the top click on More -> Change Password.

But this can be done only after login.

8/19/16, 7:20 AM

how can i provide reset password button on landing page  for odoo9 

Ask a Question
Keep Informed
2 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