Skip to Content
This question has been flagged
1 Reply
2396 Views
Avatar
Richard Gastmeier

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?

Avatar
Discard
Mai Chi Trung

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.

Richard Gastmeier
Author

Thanks Ashish, but the user name and password are not the issue, the URL has somehow changed.


Avatar
Ashish Hirpara
Best Answer

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.

Avatar
Discard