跳至内容
菜单
此问题已终结
3 回复
2862 查看

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.

形象
丢弃
最佳答案

video reference here

 

形象
丢弃
编写者 最佳答案

thank you very much !

形象
丢弃
最佳答案

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

形象
丢弃
相关帖文 回复 查看 活动
1
12月 20
5404
0
2月 21
3169
1
7月 25
1308
2
7月 25
7041
2
7月 25
3398