Search code examples
emailpasswordsodoorecover

Recover admin password and email Odoo server

Months ago, I installed an Odoo server and it worked perfectly !

Problem is that I forgot the identification (email/pass) for the admin, wich is real bad. After uninstalling the server and reinstalling it I found out that the database was not wiped. So it didn't change at all !

Please, can anyone help me finding the admin's email and password ?

I'm not very familiar with progresql but res_users displays empty passwords:

enter image description here

Solution

  • You may change admin password using progresql from the terminal. You just need to do like these

    odoo@odedra:~$ psql testing_db
psql (9.1.14)
Type "help" for help.

testing_db=# UPDATE res_users SET password='new_password' WHERE login = 'admin';
UPDATE 1

    where testing_db is database name.

    Now login with new password and change user details whatever you want.