Migrate MySQL AES_ENCRYPT user passwords to Rails Devise passwords

Vote count:

0

I've converted my website from PHP/MySQL to Rails with a whole new DB schema (so don't tell me to just use MySQL in Rails). I'm using Devise gem.

MySQL encrypted users passwords using AES_ENCRYPT(password, password) so, no, I don't have the users' raw passwords, and I need to move these users with their passwords over to my new database in Devise. How can I get these passwords in when Devise encrypts passwords differently? Is there any way to do it?

Thanks!

asked 6 mins ago

Guy

350

Migrate MySQL AES_ENCRYPT user passwords to Rails Devise passwords