Community mailing list archives

Re: Migrate encrypted user passwords from v6 to v9

Yassine TEIMI
- 11/08/2016 03:58:30
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 ?

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.

Can you confirm that ?

Thanks a lot.

2016-11-07 22:47 GMT+00:00 Holger Brunn <>:
> What is the proper way to migrate passwords from v6 to v9 ? looks a 
lot like it generates hashes that passlib used in
blob/9.0/addons/auth_crypt/ 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:

[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


Post to:



Yassine TEIMI

Consultant & Odoo Project Manager
TEL : +212 6-87 71 41 18