Community mailing list archives
Re: Migrate encrypted user passwords from v6 to v9by
It's is entirely possible, just no one has written the script.
On Tue, 8 Nov 2016 10:05 PM Yassine Teimi <firstname.lastname@example.org> wrote:
Thanks a lot.Can you confirm that ?As much as I know, OpenUpgrade migrates data from version 'n' to version 'n+1', so it's impossible for openupgrade to migrates from 6 to 9 directly.Hi Holger, Thanks for the answer,I'm wondering if moving password column to password_crypt even if the two odoo versions (6 and 9) are using different hash modules, will work properly.
Did you try moving it from v6 directly on v9 using OpenUpgrade ?2016-11-07 22:47 GMT+00:00 Holger Brunn <email@example.com>:> What is the proper way to migrate passwords from v6 to v9 ?https://github.com/odoo/odoo/blob/6.0/addons/base_crypt/crypt.py#L72 looks a lot like it generates hashes that passlib used in https://github.com/OCA/OCB/ blob/9.0/addons/auth_crypt/auth_crypt.py#L62 might just understand. Did you ever try to simply move the password column to password_crypt? This might just work. I even think I remember to have done exactly that: https://github.com/ OCA/OpenUpgrade/blob/7.0/addons/auth_crypt/migrations/220.127.116.11/pre- migration.py#L31 [The rest is quite academic, because the above is your solution. But given I wrote this text already, I won't delete it] If not, you'll have to take the hash apart (separate magic and salt from the hash, split by the dollar sign) and craft one passlib understands. If this is not possible (which I doubt), you'd have to keep the old hashes in some separate column, and for every login check if there exists an old hash, verify it with the v6 code, and write a new hash v9 style. Don't forget to clear out the old hash column then. But still, my guess would be that renaming the column suffices. -- Therp - Maatwerk in open ontwikkeling Holger Brunn - Ontwerp en implementatie mail: firstname.lastname@example.org web: http://therp.nl
--CordialementYassine TEIMIConsultant & Odoo Project ManagerTEL : +212 6-87 71 41 18