Cyrus-SASL2-2.1.20 & MySQL crypt'ed passwords

[Marcel de Reuver]

>
> Could anyone make this setup work? The patch for 2.1.19 applies cleanly to
> the ports tree and I can build sasl, but it ignores the settings on
> smtpd.conf (mainly password_format: crypt).
>
> I can auth @ SMTP using the encrypted password I find at the database, but
> no luck using the plaintext password (which cyrus-sasl should then crypt
> and check vs the database). -- Meaning the patch is having no effect, it
> is only checking the password feeded vs the database...
>
> Is there any way to have SMTP auth working with MySQL / crypt-stored
> passwords using postfix+cyrus-sasl2 ?
>


---- smtpd.conf --------------------
pwcheck_method: auxprop
mech_list: PLAIN LOGIN
auxprop_plugin: sql
srp_mda: md5
password_format: crypt
sql_engine: mysql
sql_hostnames: localhost
sql_database: postfix
sql_user: XXXXXXXXX
sql_passwd: XXXXXXXXX
sql_verbose: yes
sql_select: SELECT password FROM mailbox WHERE username = '%u@%r'
-------------------------------------