Community mailing list archives

Re: Migrate encrypted user passwords from v6 to v9

Open For Small Business Ltd, Graeme Gellatly
- 11/08/2016 05:13:07

It's is entirely possible, just no one has written the script.

On Tue, 8 Nov 2016 10:05 PM Yassine Teimi <> wrote:
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





Yassine TEIMI

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

Post to: