From: Simon Matter (simon dot matter at ch dot sauter-bc dot com)
Date: Thu Jun 17 2004 - 14:38:51 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:
Usually that's something like /usr/lib/sasl2/smtpd.conf, not
/etc/postfix/smtpd.conf.
HTH
Simon
> 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.
>
>
|
|
|