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?