Problem with Cyrus-SASL with auxprop-mysql and Postfix

[Jens Mittag]

Am Sonntag, den 11.02.2007, 10:15 +0100 schrieb Patrick Ben Koetter:
> * Jens Mittag <thomas-moore at gmx.net>:
> > Hi!
> > 
> > I know this has been discussed often enough, but though I've read a lot of
> > postings about this topic I can not solve it...
> > 
> > I've set set debug levels to the maximum values possible (for both postfix
> > and SASL) and get the following error (which is not very helpful to me):
> > 
> > postfix/smtpd[5036]: Read 49 chars: AUTH PLAIN AG0wMHJlZGJpQG0wMHJlLmRlADVta
> > postfix/smtpd[5036]: warning: SASL authentication failure: Password verification failed
> > m00re postfix/smtpd[5036]: warning: unknown[62.214.237.110]: SASL PLAIN authentication failed
> > m00re postfix/smtpd[5036]: Write 34 chars: 535 Error: authentication failed??
> > 
> > My smtpd.conf looks like:
> > 
> > log_level: 7
> > pwcheck_method: auxprop
> > auxprop_plugin: sql
> > mech_list: plain login
> > sql_engine: mysql
> > sql_hostnames: 127.0.0.1
> > sql_user: postfix
> > sql_passwd: passwort
> > sql_database: postfix
> > sql_select: select password from mailbox where username='%u@%r'
> > 
> > At first I thought the sql_select is wrong, but unfortunately, SASL does not
> > connect to MySQL at all. What could cause this? 
> > 
> > My system is Ubuntu 6.06 LTS (means I have version 2.1.19.dfsg1-0.1ubuntu2
> > installed). 
> > 
> > Besides doing the auxprop approach I also tried authdaemond, but with no
> > success either. I have already switched from a chrooted postfix to normal
> > operation, but I still get 
> > 
> > postfix/smtpd[23588]: warning: SASL authentication failure: cannot connect
> > to Courier authdaemond: No such file or directory
> > 
> > The smtpd.conf I used for this approach is:
> > 
> > pwcheck_method: authdaemond
> > log_level: 7
> > mech_list: PLAIN LOGIN
> > authdaemond_path: /var/run/courier/authdaemon/socket
> > 
> > The socket file exists and is readable by the user postfix... whats wrong?
> 
> First guess: In both cases you are running the Postfix smtpd daemon chrooted
> and therefore it can't access the MySQL socket or the authdaemond socket.
> 
> If that's not the answer show 'saslfinger -s' output.

According to what I've read on mailinglists and the postfix doc, its
sufficient to change the smtpd settings in master.cf to disable the
chroot of postfix... 

saslfinger -s gives me:

-- content of /etc/postfix/sasl/smtpd.conf --
pwcheck_method: authdaemond
log_level: 7
mech_list: PLAIN LOGIN
authdaemond_path: /var/run/courier/authdaemon/socket


-- active services in /etc/postfix/master.cf --
# service type  private unpriv  chroot  wakeup  maxproc command + args
#               (yes)   (yes)   (yes)   (never) (100)
smtp      inet  n       -       n       -       -       smtpd

pickup    fifo  n       -       -       60      1       pickup
cleanup   unix  n       -       -       -       0       cleanup
qmgr      fifo  n       -       n       300     1       qmgr
tlsmgr    unix  -       -       -       1000?   1       tlsmgr
rewrite   unix  -       -       -       -       -       trivial-rewrite
bounce    unix  -       -       -       -       0       bounce
defer     unix  -       -       -       -       0       bounce
trace     unix  -       -       -       -       0       bounce
verify    unix  -       -       -       -       1       verify
flush     unix  n       -       -       1000?   0       flush
proxymap  unix  -       -       n       -       -       proxymap
smtp      unix  -       -       -       -       -       smtp
relay     unix  -       -       -       -       -       smtp
        -o fallback_relay=
showq     unix  n       -       -       -       -       showq
error     unix  -       -       -       -       -       error
discard   unix  -       -       -       -       -       discard
local     unix  -       n       n       -       -       local
virtual   unix  -       n       n       -       -       virtual
lmtp      unix  -       -       -       -       -       lmtp
anvil     unix  -       -       -       -       1       anvil
scache    unix  -       -       -       -       1       scache
maildrop  unix  -       n       n       -       -       pipe
  flags=DRhu user=vmail argv=/usr/bin/maildrop -d ${recipient}
uucp      unix  -       n       n       -       -       pipe
  flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail
($recipient)
ifmail    unix  -       n       n       -       -       pipe
  flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp     unix  -       n       n       -       -       pipe
  flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender
$recipient
scalemail-backend unix  -       n       n       -       2       pipe
  flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store
${nexthop} ${user} ${extension}
mailman   unix  -       n       n       -       -       pipe
  flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
  ${nexthop} ${user}



amavis unix - - n - 2 smtp
        -o smtp_data_done_timeout=1200
        -o disable_dns_lookups=yes

127.0.0.1:10025 inet n - n - - smtpd
        -o content_filter=
        -o local_recipient_maps=
        -o relay_recipient_maps=
        -o smtpd_restriction_classes=
        -o smtpd_client_restrictions=
        -o smtpd_helo_restrictions=
        -o smtpd_sender_restrictions=
        -o smtpd_recipient_restrictions=permit_mynetworks,reject
        -o mynetworks=127.0.0.0/8
        -o strict_rfc821_envelopes=yes

-- mechanisms on localhost --

-- end of saslfinger output --

cheers
 Jens