Skip to content

Instantly share code, notes, and snippets.

@ray-odoo
Last active September 23, 2018 17:46
Show Gist options
  • Save ray-odoo/cef23d6fee6e2e819250fa19ac289c2d to your computer and use it in GitHub Desktop.
Save ray-odoo/cef23d6fee6e2e819250fa19ac289c2d to your computer and use it in GitHub Desktop.
Upgrade SAAS to Enterprise (July 2015)
1. Take a backup of the SAAS database. (You must be logged into odoo.com as the Administrator of the database).
2. Perform the following PSQL:
update ir_module_module set state = 'to remove' where name = 'saas_trial';
insert into base_config_settings(auth_signup_reset_password) values(true);
update res_partner set signup_type='reset', signup_token='rsvabcdefghijykalklk', signup_expiration=to_timestamp('20200411','YYYYMMDD') where id=(select partner_id from res_users where id=1);
ALT:
https://www.odoo.com/forum/help-1/question/how-to-reset-the-odoo-database-admin-password-a-summary-for-different-odoo-versions-131992
UPDATE res_users SET password='', password_crypt= '$pbkdf2-sha512$25000$DOHcO2fMeS8lxJhTijGGUA$Z0aC00wlabdtQrJh2hpQ9dI3IWnQCd7vfJzbutP4.x0dDu4BkOgI/1u2ldn7K0by8tpFCzYwzJTZrb6nkVdVXg' WHERE id=1;
3. Access the server via the password reset link:
http://localhost/web/reset_password?token=rsvabcdefghijykalklk&login=admin
4. Upgrade the base module.
5. Settings -> Modules and clicked Apply scheduled upgrades.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment