Skip to Content
Menu
This question has been flagged
2 Replies
5470 Views

I backed up my database as a zip file about a month ago (10.0) - and now when I try to restore it, I can't seem to log in? I have the correct username and password, but it denies me. Is there a way to reset these?


I have a lot of data in there (inventory) that I really don't want to lose.

Avatar
Discard

Hey Harrison Hoffert,

From terminal (Shell) / Pgadmin Window You can reset it.

:- From Terminal,

1) psql your_database_name

2) Now run this query ,

update res_user set password='***' where id=1;

> Above query is for admin,if you want to change other user's password,simple go with Select SQL query and update it accordingly !

for ex.) select id,login from res_users;

Thanks.

Best Answer

Backup and restore does not change the password. You have simply entered a wrong password. As Dipak explained, in Odoo 8.0 you can retrieve your password directly from the database. From Odoo 9.0 on the password is stored encrypted in the database, but it is possible to reset it using a self-created hash. Please read the answer of andreparames in the following thread on how to do it: https://github.com/odoo/odoo/issues/9806#issuecomment-255487372

Avatar
Discard