SASL (Postfix) authentication with MySQL and Blowfish pre-encrypted passwords

Posted by webo on Server Fault See other posts from Server Fault or by webo
Published on 2011-02-23T18:18:15Z Indexed on 2011/02/25 7:27 UTC
Read the original article Hit count: 522

Filed under:
|
|
|
|

I have a Rails app with the Devise authentication gem running user registration and login. I want to use the db table that Devise populates when a user registers as the table that Postfix uses to authenticate users.

The table has all the fields that Postfix may want for SASL authentication except that Devise encrypts the password using Blowfish before placing it in the database.

How could I go about getting Postfix/SASL to decrypt those passwords so that the user can be authenticated properly? Devise salts the password so I'm not sure if that helps.

Any suggestions? I'd likely want to do something similar with Dovecot or Courier, I'm not attached to one quite yet.

© Server Fault or respective owner

Related posts about mysql

Related posts about postfix