From: michael (michael at michaelschurter dot com)
Date: Thu Jun 17 2004 - 12:28:02 EDT
I just updated my Debian (testing) system and suddenly I couldn't
authenticate through SASL to send e-mails anymore. After a little
poking around I realized that the newer version of SASL now splits user
names into user and realm. Slick feature, but it totally ruins my Postfix
> SASL > saslauthd > PAM > MySQL setup.
So I poked around a little more and discovered the wonderful auxprop
mechanism. It looked ideal. If I understand it correctly it would
shorten my authentication chain down to Postfix > SASL > MySQL.
So I setup /etc/postfix/smtpd.conf to look like this:
pwcheck_method: auxprop
auxprop_plugin: sql
sql_engine: mysql
sql_hostnames: localhost
sql_user: vmail
sql_passwd: <password>
sql_database: hosting
sql_select: select clearpw from users where email = '%u@%r'
(I had been using ENCYPT()'d passwords, but I understand that there's no
way to do that using auxprop.)
I tried to login and it doesn't work. To make matters even more
bizarre, nothing shows up in my mysql.log file (I'm logging all queries
right now), and my mail.log looks like this (edited):
localhost postfix/smtpd[22150]: connect from unknown[<my ip>]
localhost postfix/smtpd[22150]: warning: SASL authentication failure: no
secret in database
localhost postfix/smtpd[22150]: warning: unknown[<my ip>]: SASL CRAM-MD5
authentication failed
localhost postfix/smtpd[22150]: warning: unknown[<my ip>]: SASL NTLM
authentication failed
localhost postfix/smtpd[22150]: warning: SASL authentication failure:
cannot connect to saslauthd server: No such file or directory
localhost postfix/smtpd[22150]: warning: SASL authentication failure:
Password verification failed
localhost postfix/smtpd[22150]: warning: unknown[<my ip>]: SASL PLAIN
authentication failed
localhost postfix/smtpd[22150]: warning: SASL authentication failure:
cannot connect to saslauthd server: No such file or directory
localhost postfix/smtpd[22150]: warning: unknown[<my ip>]: SASL LOGIN
authentication failed
localhost postfix/smtpd[22150]: lost connection after AUTH from
unknown[<my ip>]
I feel like SASL's ignoring me. :)
Any thoughts? Thanks in advance.
|
|
|