I've recently set up Odoo, haven't done a backup yet. Using an account that logs in with google, I changed the email address of that user to one that is not the same as the account I auth to google with, and worse, it matches the one that is the admin account I set up Odoo with. Now I can't log in with ether account. Is my only recourse to nuke the database and start over? I've set up some other stuff and users so that is not ideal. If I knew the database credentials I could probably change the email back again. Suggestions?
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
2
Antwoorden
4419
Weergaven
I fixed it. This wasn't a password issue. Odoo allowed me to modify my second admin account so that two accounts had the email email address. I couldn't login with Oauth to the second one because the email address no longer matched, and it was getting an error trying to login to the native one.
What I did to fix it was -- I su'd to the postgres user, and looked for tables in my database, found the res_users table and changed the erroneous 'login' back to the original.
# select * from "res_users";
I noted the ID of the account that was supposed to connect via Oauth, which was 22.
# update "res_users" set login='my_Oauth_email_address' where id=22;
I'm doing a backup now :-)
The default admin user has the database ID 1 (for Odoo version 11 and lower) or 2 for Odoo version 12 and 13.
Please check my little tutorial here fo resetting the password:
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