Postfix - Sasl - mysql

[Aaron Peterson]

>> > I added the cyrus-sasl2 port (also chose support for it in
>> postfix port)
>> > "WITH_MYSQL".
>> >
>> > No go.
>> >
>> > I added the following lines to
>> /usr/local/lib/sasl2/smtpd.conf (found this
>> > in another faq/tutorial, so it may be incorrect)
>> >
>> > sasl_pwcheck_method: auxprop
>> > sasl_auxprop_plugin: sql
>>    sql_engine: mysql
>>    mech_list: login plain crammd6 digestmd5
>> > sql_user: postfix-user
>> > sql_passwd: thepassword
>> > sql_database: postfix
>> > sql_statement: SELECT password FROM mailbox WHERE username = '%u'
>> > sql_verbose: yes

I used those instructions, although I modified some for my specific
configuration.  the "username" field in my database is
"user at virtualdomain.com" however.  I had to create a plain-text password
field that i modified the php scripts to create as part of the normal
process of things because the auxprop plugin alone didn't understand
anything but plain text.  you can use the PAM sasl plugin from what I
understand, and configure pam to use mysql with it's native plugin in
order to use encrypted passwords in the mysql database.  I haven't looked
at this stuff in a while, so my memory isn't so clear and things may have
changed...

Here's my working smtpd.conf:

# smtpd.conf
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login

sql_engine: mysql
sql_hostnames: localhost
sql_user: postfix-user
sql_passwd: thepassword
sql_database: postfix
sql_select: select pass_plain from mailbox where username='%u@%r'