Virtual Users And Domains With Postfix, Courier And MySQL - SASLauthd problem

Discussion in 'HOWTO-Related Questions' started by qtx, May 18, 2007.

  1. qtx

    qtx New Member

    Hello ever'1

    I know, it's a shame and I must be the xth member to post a message here about this issue, but no advice proved to work on my machine.

    The setup is a brand new Debian 4.0.
    I followed the HOWTO 'Virtual Users And Domains With Postfix, Courier And MySQL - ubuntu'.
    During the installation no errors occured, so it cannot be totally screwed.

    What is the (my) problem?
    It is not possible to send/receive emails via a client (thunderbird in my case).

    I can track the following error in:
    /var/log/mail.log
    Code:
    May 18 18:41:39 myserver courierpop3login: Connection, ip=[::ffff:xx.xx.37.7]
    May 18 18:41:53 myserver authdaemond: failed to connect to mysql server (server=localhost, userid=mail_admin): Access denied for user 'mail_admin'@'localhost' (using password: YES)
    May 18 18:41:53 myserver courierpop3login: LOGIN FAILED, user=info@mydomain.tld, ip=[::ffff:xx.xx.37.7]
    May 18 18:41:53 myserver courierpop3login: authentication error: Input/output error
    So when trying to pop/send emails from my mailserver it refuses all delivery (no matter what direction). It's not a thunderbird issue, for sure.

    I checked my files according to the postings in this forum and the howto (especially the ones that differ from the ubuntu installation) and I cannot find any differences.

    So all the saslauthd, mysql etc. conf-files look the same.
    The *mail_admin*-user is registered in mysql (login to mysql works just fine).

    I was able to send emails via telnet and I also receive emails in /home/vmail/.

    Right now I am stuck and do not know, why saslauthd cannot connect to mysql. I know, something must be missing, though!:mad:
    /var/log/syslog does not tell me anything else.

    Any debugging hints are highly appreciated!

    Thanks!
    Qt
     
  2. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    What's the output of
    Code:
    ps aux | grep saslauthd
    ?
    What's in /etc/default/saslauthd?
     
  3. qtx

    qtx New Member

    Hi Falko

    Thanks for helping!

    Output of: ps aux | grep saslauthd
    Code:
    root     18288  0.0  0.1   7216   988 ?        Ss   May18   0:00 /usr/sbin/saslauthd -a pam -m /var/spool/postfix/var/run/saslauthd -r -c -n 5
    root     18289  0.0  0.1   7216   540 ?        S    May18   0:00 /usr/sbin/saslauthd -a pam -m /var/spool/postfix/var/run/saslauthd -r -c -n 5
    root     18290  0.0  0.0   7216   360 ?        S    May18   0:00 /usr/sbin/saslauthd -a pam -m /var/spool/postfix/var/run/saslauthd -r -c -n 5
    root     18291  0.0  0.0   7216   360 ?        S    May18   0:00 /usr/sbin/saslauthd -a pam -m /var/spool/postfix/var/run/saslauthd -r -c -n 5
    root     18292  0.0  0.0   7216   360 ?        S    May18   0:00 /usr/sbin/saslauthd -a pam -m /var/spool/postfix/var/run/saslauthd -r -c -n 5
    root     29782  0.0  0.1   2848   712 pts/0    R+   11:12   0:00 grep saslauthd
    
    Content of: /etc/default/saslauthd
    Code:
    # 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"
    MECHANISMS="pam"
    
    # Additional options for this mechanism. (default: none)
    # See the saslauthd man page for information about mech-specific options.
    MECH_OPTIONS=""
    
    # How many saslauthd processes should we run? (default: 5)
    # A value of 0 will fork a new process for each connection.
    THREADS=5
    
    # Other options (default: -c)
    # See the saslauthd man page for information about these options.
    #
    # Example for postfix users: "-c -m /var/spool/postfix/var/run/saslauthd"
    # Note: See /usr/share/doc/sasl2-bin/README.Debian
    #OPTIONS="-c"
    
    OPTIONS="-m /var/spool/postfix/var/run/saslauthd -r -c"
    PIDFILE="/var/spool/postfix/var/run/${NAME}/saslauthd.pid"
    
    Thanks for any hint on this...
    QT
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Can you delete the
    Code:
    PIDFILE="/var/spool/postfix/var/run/${NAME}/saslauthd.pid"
    line in /etc/default/saslauthd and restart saslauthd?
     
  5. jpieper

    jpieper New Member

    Code:
    May 18 18:41:53 myserver authdaemond: failed to connect to mysql server (server=localhost, userid=mail_admin): Access denied for user 'mail_admin'@'localhost' (using password: YES)
    It donĀ“t seems like your mysql-user is allowed to access. Do you flushed your user privileges?

    Code:
    flush privleges;
    Or do you entered 127.0.0.1 as Host instead of localhost? I think MySQL differs between 127.0.0.1 and localhost.
     
  6. qtx

    qtx New Member

    Hi

    @Falko:
    I did remove the PIDFILE line and restarted saslauthd.
    No improvement, though. :mad:

    @jpieper:
    Yes, the PRIVILEGES have been flushed (ceveral times since).
    Also, I can connect to mysql with the mail_admin-user (see initial post).

    About localhost/127.0.0.1:
    I followed Falkos howto, so in /etc/mysql/my.cnf there is:
    Code:
    bind = 127.0.0.1
    I tried localhost (then restart everything), but did not help.

    Where do you suggest using localhost instead of 127.0.0.1? In which files?

    Thank you guys for helping!
    QT

    BTW.
    What works:
    Send emails to other domains (via thunderbird).
    Receive emails on the host /home/vmail/

    What does not work:
    Receive emails via using thunderbird.

    Errormessage in /var/log/mail.err
    Code:
    May 22 06:49:25 myhost authdaemond: failed to connect to mysql server (server=localhost, userid=mail_admin): Access denied for user 'mail_admin'@'localhost' (using password: YES)
    May 22 06:49:25 myhost courierpop3login: authentication error: Input/output error
    
     
  7. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Ok, receiving mails has nothing to do with saslauthd.
    What's in /etc/courier/authmysqlrc? Is the MySQL password correct in that file?
     
  8. qtx

    qtx New Member

    Yes, of course :eek:
    Just wanted to point out, that something is working.

    Yes, the password was right.

    BUT...
    I found a (1) space after the password :eek:
    After starting the services again, I receive emails! :D
    So all is working fine!

    Thank you all for leading me to the right spot :rolleyes:

    QT
     

Share This Page