Skip to Content
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
All Posts Oameni Insigne
Etichete (View all)
odoo accounting v14 pos v15
Despre acest forum
Această întrebare a fost marcată
5 Răspunsuri
3634 Vizualizări
Imagine profil
maharajg

Hi Im new to oodo, ive installed oodo 12 community edition on windows 10. I setup my db and login username and password as admin / admin. After setup ive been using for a few days and for some reason i logged out and when i try to login to http://localhost:8069/web/login , Email - admin, password - admin is not working same is the case if i enter my email and try the same password.

im able to login to be postgresql. I tried using 

update res_users set password='test' where login='admin';
​i get zero rows updated.


I had the same issue few weeks back and i thought i have forgotten the password so i reinstalled the whole thing and dont want to go through the same again.
Any help to reset password?
 


Imagine profil
Abandonează
Imagine profil
HIREN DANGAR
Cel mai bun răspuns

Hello, 

If you are forget your admin password than try to use below query to change password force fully.

update res_users set password='a' where id=1;

 

Imagine profil
Abandonează
Imagine profil
Ermin Trevisan
Cel mai bun răspuns

According to my knowledge, you should create a password hash and reset the hash in the database if you want to be sure your password is encrypted.

You may want to check my post here: https://www.odoo.com/forum/help-1/question/how-to-reset-the-odoo-database-admin-password-a-summary-for-different-odoo-versions-131992#answer-131994

Imagine profil
Abandonează
Imagine profil
maharajg
Autor Cel mai bun răspuns

Thanks tried this,

Query returned successfully: one row affected, 31 msec execution time.

While logging, getting Wrong Login/Password error.

When i try SELECT login, password FROM res_users WHERE id=1;

i get

 "__system__";"a"

This is not resolved yet, dont know why it shows resolved 

Imagine profil
Abandonează
HIREN DANGAR

Try to update admin login as well password too. Like this update res_users set login='user',password='a' where id=1;

maharajg
Autor

tried update res_users set login='admin',password='a' where id=1; , got response Query returned successfully: one row affected, 32 msec execution time.

still unable to login, im sure im missing something very silly, cant figure out what.

HIREN DANGAR

Brother, This is the general query for reset the admin password through database.

Try reset both login and password of Admin.

update res_users set login='a' , password='a' where id=1;