I changed the domain in Odoo and now I can't access it from my login. Is there a way I can edit this field in the SQL data?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
2395
Weergaven
You can try resetting the password for the administrator account from the command line. First, stop the Odoo service if it is currently running. Then, enter the following command to reset the password:
./odoo-bin --db-filter=your_database_name --update=admin password=new_password
Replace your_database_name with the actual name of your database, and new_password with the password you want to use for the administrator account.
After running this command, you should be able to log in to the back office using the administrator account and the new password you set.
If you are unable to reset the password using the command line, you can also try resetting it directly in the database. To do this, connect to the database using a tool like pgAdmin and find the res_users table. Then, locate the record for the administrator account and update the password field with the new password you want to use. Be sure to encrypt the password using the crypt function before saving the record.
Keep in mind that modifying the database directly can be risky, so make sure to back up your database before making any changes. Also, be sure to stop the Odoo service before modifying the database to avoid any potential conflicts.
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden
Maybe you can check the table ir_model_fields. There's a domain column which is usually null.
Otherwise, if you can be more specific describing what you were doing and possibly some log, it's easier to give support. To a non english speaker like me, domain in Odoo can mean several different things.
Thanks Ashish, but the user name and password are not the issue, the URL has somehow changed.