pam_mysql cuts off domain name after email

  • ovencleaner

    ovencleaner - 2009-01-09

    Running postfix Cyrus-SASL using the pam module to go to mysql.

    I am logging in as, but for some reason the domain is getting stripped off? It

    do_auth         : auth failure: [user=joeblow] [service=smtp] [] [mech=pam] [reason=PAM auth error]

    SELECT password FROM mailbox WHERE username = 'joeblow'

    It should be doing:
    SELECT password FROM mailbox WHERE username = ''

    Any ideas?

    auth required user=postfix passwd=mypasswd host= db=postfix table=mailbox usercolumn=username passwdcolumn=password crypt=0

    # Settings for saslauthd daemon
    # Please read /usr/share/doc/sasl2-bin/README.Debian for details.

    # Should saslauthd run automatically on startup? (default: no)

    # Description of this saslauthd instance. Recommended.
    # (suggestion: SASL Authentication Daemon)
    DESC="SASL Authentication Daemon"

    # Short name of this saslauthd instance. Strongly recommended.
    # (suggestion: saslauthd)

    # Which authentication mechanisms should saslauthd use? (default: pam)
    # Available options in this Debian package:
    # getpwent  -- use the getpwent() library function
    # kerberos5 -- use Kerberos 5
    # pam       -- use PAM
    # rimap     -- use a remote IMAP server
    # shadow    -- use the local shadow password file
    # sasldb    -- use the local sasldb database file
    # ldap      -- use LDAP (configuration is in /etc/saslauthd.conf)
    # Only one option may be used at a time. See the saslauthd man page
    # for more information.
    # Example: MECHANISMS="pam"

    # Additional options for this mechanism. (default: none)
    # See the saslauthd man page for information about mech-specific options.

    # How many saslauthd processes should we run? (default: 5)
    # A value of 0 will fork a new process for each connection.

    # Other options (default: -c -m /var/run/saslauthd)
    # Note: You MUST specify the -m option or saslauthd won't run!
    # See /usr/share/doc/sasl2-bin/README.Debian for Debian-specific information.
    # See the saslauthd man page for general information about these options.
    # Example for postfix users: "-c -m /var/spool/postfix/var/run/saslauthd"
    OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd"

    • go-soft

      go-soft - 2009-08-06


      i have exactly the same problem. Did you find a solution?

  • Alessandro

    Alessandro - 2012-08-11

    Just for future users…

    try adding the parameter "-r" to "/etc/default/saslauthd" and restart saslauth.


    OPTIONS="-r -c -m /var/spool/postfix/var/run/saslauthd"


    /etc/init.d/saslauthd restart




Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks