Skip to Content
Menu
This question has been flagged
3 Replies
2736 Zobrazenia

Hello, i forget my admin odoo14 CE password (installed on a remote ubuntu 20.04) , and can't recover it from UI, How can i set it from SSH Please ? 

I want to connect directly via ssh to the database and reset it ? does it work ? how to do it exactly ? thanks in advance.

Avatar
Zrušiť
Best Answer

video reference here

 

Avatar
Zrušiť
Autor Best Answer

thank you very much !

Avatar
Zrušiť
Best Answer

Hello BENKOULAL RAMZI WASSIM,


I hope you find this message well.


Please find below steps to change the Odoo 14 user password in Ubuntu 20.04 from SSH:


1. Open Terminal in your system (Ctrl+Shift+T).

2. SSH into the desired server: ssh your_username@your_system_ip_address (eg, odoo@192.159.2.524).

3. Enter your system password (in this case, the password for the "odoo" system user).

4. Access PostgreSQL: sudo su - postgres.

5. Enter the PostgreSQL password.

6. Enter the desired database: psql db_name.

7. Change the password: UPDATE res_users SET password='your_new_password' WHERE login='admin'; (ensure the password is enclosed in single quotes, eg, UPDATE res_users SET password='odoo' WHERE login='admin'.

8. Commit changes: \q.

9. Restart service: sudo service postgresql restart. (make sure to restart the service).


I hope this information proves helpful to you.

Thanks & Regards,
Email: odoo@aktivsoftware.com     

Skype: kalpeshmaheshwari

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
1
dec 20
5345
0
feb 21
3123
2
jún 25
1636
0
máj 25
14
2
jan 25
3250