Odoo Help
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.
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.
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.
Sorry, I had not noticed Christophe Simonis answer saying basically the same thing as my edited answer.
The SQL query will work only if 'Password Encryption' module is not installed, otherwise result will be encrpyted (and hence not useful).
To do it through one command line just type sudo -u openerp psql --dbname <database> --command "select password from res_users where login='admin';".
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.
He lost the admin user's password, so he can't connect.
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.
RegisterOdoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it nowQuestion tools
Stats
| Asked: 2/5/13, 10:39 AM |
| Seen: 12716 times |
| Last updated: 12/11/16, 3:33 PM |
Thanks for reply, but is their any alternate solution when end user can do the same without any technical knowledge?
which version of OpenERP are you using?
i need solution for both version V6 & V7
it wouldn't be very good if there was! You might be able to get the password through XMLRPC, but I think they are now encrypted (or hashed rather) so you might only be able to reset the password rather than retrieve it
kathan: I updated my answer with how to configure OpenERP 7 to enable what you want. If you already lost your password, it's too late though, and you'll have to hire a someone to reset things for you, or ask your service provider to do this for you if you don't control your installation.