This question has been flagged
4 Replies
18492 Views

i'm  sure that the password and the login are  true  !!!! how can i change it???

Avatar
Discard
Best Answer

Dear Nidhal,

You can change from backend database.

Step-1: Connect to that database from terminal or user interface

Step-2: Fire update query

Example (in terminal)

1. Please type this command in terminal sudo su postgres

2. Then they will ask system password, Please enter it.

3. Then you will to write psql your_database_name

4. Fire that query, update res_users set password = 'Your new password' where login = 'Your_login_name';


Hope this help for you.

Cheers,

Ankit H Gandhi.





Avatar
Discard

This does only work for versions 7 and older. Meanwhile the password is encrypted. See the link I have posted.

Ankit ,your way is absolutely correct and it works for me in odoo8 and 9 ..I think Ermin have no knowledge about this query..@Ermin .If you have no idea about this kind of stuff dont answered ..Lot of experts checking and give perfect solutions for all the problems .Thnaks for Community...Ermin Please

First understand the question and then answer.thats better...

alternate solution for this issue---> is go to pgadmin->connect to pg->selectthe database->Go to Schemas->Public->Tables->Go to res_users table->Rightclick and Go to scripts->Update Script->Run this query(update res_users set password = 'Your new password' where login = 'Your_login_name';)

Dep, this way did not work for me in version 9.0. I had to do it the way as described in the link I have provided. I might have been wrong lately, but that does not mean I'm wrong anytime. I have provided a legit answer to the question which was even asked without providing any useful information.

Dear Ermin..as per Ankit solution it works you can check ..in locally thats why I commented...Just go to res_users table and modify .It works im sure...

I broke my local pgadmin at the moment (I'm using Postgres 9.5 on the server, which is not compatible with my local pgadmin on Ubuntu 15.10), so I can not check it with reasonable efforts, but will do it. However, if Ankit's answer works, everything is perfect. If it doesn't work, for what reason it might be, as it happened to me and obviously also to the people in the thread I have linked, the second solution should work. Any way, the problem is solved and that's the important outcome.

I am facing the same issue and I did follow these step but still after I login I find an error says

TypeError: Cannot read properties of null (reading 'children')
at https://web.com/web/content/38219-4b8ce2f/web.assets_backend.js:503:342

Best Answer

Please be more specific. Do you try to login as admin user?

If the login for a non-admin user does not work, login as admin, go to "Settings/Users" and change the password of the corresponding user. If you forgot the correct admin password and are not able to login as admin, then this may help you:https://github.com/odoo/odoo/issues/9806

Avatar
Discard
Author Best Answer

thank you all i fix it 

Avatar
Discard

Your Welcome @ Nidhal.