Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
3 Risposte
3080 Visualizzazioni

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
Abbandona
Risposta migliore

video reference here

 

Avatar
Abbandona
Autore Risposta migliore

thank you very much !

Avatar
Abbandona
Risposta migliore

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
Abbandona
Post correlati Risposte Visualizzazioni Attività
1
dic 20
5567
0
feb 21
3386
0
ago 25
164
1
ago 25
2122
1
lug 25
2593