Postfix - Sasl - mysql
aaron at alpete.com
Wed Apr 7 13:35:19 PDT 2004
>> > 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
Here's my working smtpd.conf:
mech_list: plain login
sql_select: select pass_plain from mailbox where username='%u@%r'
More information about the freebsd-questions