www.webdeveloper.com
Results 1 to 5 of 5

Thread: Ubuntu + Postfix + SASL + MySQL Auth Issue

Hybrid View

  1. #1
    Join Date
    Mar 2009
    Location
    Yorkshire
    Posts
    266

    Ubuntu + Postfix + SASL + MySQL Auth Issue

    Hey guys,

    I have been in the process of setting up a mail server on ubuntu and have got everything working apart from the SMTP authentication to send mail out. The server is running postfix with a mysql database. Now, the errors im getting are all SASL authentication errors and i cant understand why. I have logged all MySQL queries while attempting to log into SMTP and these are all working correctly. The query is as follows:

    select password from mailbox where username='%u@%r' and active = 1

    Does anyone have any idea what could be causing the authentication to fail?
    Ryan Lund

    Development Manager
    http://www.ifindpoker.com

  2. #2
    Join Date
    Mar 2009
    Location
    Yorkshire
    Posts
    266
    Also this is the last error produced:
    Code:
    Nov 10 17:24:31 ubuntu postfix/smtpd[1372]: warning: SASL authentication failure: incorrect digest response
    Last edited by ryanlund; 11-10-2011 at 11:55 AM.
    Ryan Lund

    Development Manager
    http://www.ifindpoker.com

  3. #3
    Join Date
    Mar 2009
    Location
    Yorkshire
    Posts
    266
    Haha no response eh. Ok the problem you see above is basically because the SASL auxprop plugin requires the passwords in the database to be saved in plaintext. This is obviously not the best way to go about it so instead i used PAM with mysql and that has resolved that problem.

    There are a few minor issues to resolve to get it working 100% but fortunately the main problem has gone
    Ryan Lund

    Development Manager
    http://www.ifindpoker.com

  4. #4
    Join Date
    Nov 2011
    Posts
    29
    I was just finished learning the wonderful world of Postfix and Dovecot on Ubuntu not too long ago. Fun times! I decided to just do a plain text file usernameass authentication and it worked out well for me. However I realize this is not the best way to store things so that will be changed soon. Glad you figured it out.

  5. #5
    Join Date
    Mar 2009
    Location
    Yorkshire
    Posts
    266
    Yeah it was quite awkward to figure out, there are still some minor issues but nothing stopping my emails working for the time being
    Ryan Lund

    Development Manager
    http://www.ifindpoker.com

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles