Postfix + MySQL: crypt password doesn't work

Discussion in 'Server Operation' started by TiNik, Jun 18, 2015.

  1. TiNik

    TiNik New Member

    Hi, I've been upgrading Debian to Jessie recently and since then SMTP SASL authentication stopped working.

    If I insert a password to mailbox table in plaintext everything works, but encrypted version does not.

    The weird thing is that testsaslauthd works with encrypted passwords just fine.

    Don't you know what I should set to make it work with encrypted pass??

    /etc/postfix/sasl/smtpd.conf:
    Code:
        mech_list: PLAIN LOGIN CRAM-MD5 DIGEST-MD5 NTLM
        sql_engine: mysql
        sql_hostnames: 127.0.0.1
        sql_user: USERNAME
        sql_passwd: PASS
        sql_database: mail
        sql_select: SELECT password FROM mailbox WHERE username = '%u@%r'
    /etc/pam.d/smtp
    Code:
    auth    required   pam_mysql.so user=USERNAME passwd=PASS host=127.0.0.1 db=mail table=mailbox usercolumn=username passwdcolumn=password crypt=1
    account sufficient pam_mysql.so user=USERNAME passwd=PASS host=127.0.0.1 db=mail table=mailbox usercolumn=username passwdcolumn=password crypt=1
     
  2. TiNik

    TiNik New Member

    SOLUTION:

    /etc/postfix/sasl/smtpd.conf:
    Code:
    pwcheck_method: saslauthd
    mech_list: PLAIN LOGIN
    /etc/default/saslauthd
    Code:
    START=yes
    DESC="SASL Authentication Daemon"
    NAME="saslauthd"
    MECHANISMS="pam"
    MECH_OPTIONS=""
    THREADS=5
    OPTIONS="-c -m /var/run/saslauthd -r"
    +/etc/pam.d/smtp (above)
     

Share This Page