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