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.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilitate
- Inventar
- PoS
- Project
- MRP
Această întrebare a fost marcată
2
Răspunsuri
526
Vizualizări
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
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Înscrie-te
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.