Re: Postfix + SASL2 + MySQL on Debian

From: Simon Matter (simon dot matter at ch dot sauter-bc dot com)
Date: Thu Jun 17 2004 - 14:38:51 EDT

  • Next message: J. Ryan Earl: "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:

    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.
    >
    >


  • Next message: J. Ryan Earl: "Re: Postfix + SASL2 + MySQL on Debian"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD