Postfix + SASL2 + MySQL on Debian

From: michael (michael at michaelschurter dot com)
Date: Thu Jun 17 2004 - 12:28:02 EDT

  • Next message: Simon Matter: "Re: Postfix + SASL2 + MySQL on Debian"

    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.


  • Next message: Simon Matter: "Re: Postfix + SASL2 + MySQL on Debian"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD