콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
2 답글
837 화면

It usually logs in automatically, but today it just decided to not log on, a user accidentally changed password to his pin but it would still automatically log in until today. Not sure why and i cannot reset password as email doesn't send.

아바타
취소

I also encountered this problem, and I tried this method.

작성자

thanks, it seems with too many failed attempts odoo locks itself as well, giving it 24 hours and if it signs in with the password then its fine if not ill use your fix to change password and give an update.


베스트 답변

Hi,


If you can't log in to your Odoo 18 Community instance, try the following steps:

1. Try Incognito/Private Window


Sometimes the browser cache causes login issues.


    Open a private/incognito browser window


    Go to your Odoo URL


    Manually enter your email and password or PIN


2. Check Email Settings (If Reset Email Not Working)


If you're not receiving the reset email:


    Go to Settings > Technical > Outgoing Mail Servers


    Make sure your SMTP server is set correctly


    Click “Test Connection” to confirm it works


    Also check Email Queue under Settings > Technical > Email > Emails – see if the email is stuck or failed


3. Reset Password Manually via PostgreSQL (If Still Locked Out)


If you have server access:


    Connect to the database using psql


    Run this SQL to reset the password:


   UPDATE res_users SET password = 'newpassword' WHERE login = 'user@example.com';


    Replace 'newpassword' with your own and use the correct email/login.


You can now log in with the new password.


Hope it helps.


아바타
취소
작성자 베스트 답변

I am still locked out, USER ignored, as well as Password, could not connect to server: could not translate host name "psql" to address : Unknown host


On sql shell This is what i get,

Server [localhost]: 127.0.0.1

Database [postgres]: [odoo]

Port [5432]: 5432

Username [openpg]: user_name

password for user user_name

psql: error: could not connect to server: FATAL: password authentication failed for user user_name 


아바타
취소