Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
5 Antwoorden
3825 Weergaven
Avatar
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?
 


Avatar
Annuleer
Avatar
HIREN DANGAR
Beste antwoord

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;

 

Avatar
Annuleer
Avatar
Ermin Trevisan
Beste antwoord

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

Avatar
Annuleer
Avatar
maharajg
Auteur Beste antwoord

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 

Avatar
Annuleer
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
Auteur

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;