Alright, so I've got postfix + courier working as a primary server (using MySQL to handle the virtual domains and users).. I followed the (amazing) guide in the linode library..

But now, I've setup my domain to work with google apps, and so I've configured the relay_host option in postfix to "forward" all mail to google. Problem is that gmail wants authentication:



everything online points that I need to enable "smtp_sasl_password_maps", except all the examples use the hash files (a simple plain text document...). I'd rather continue using MySQL for this...

Just setting it to the: "smtp_sasl_password_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf" didn't seem to work

soooo any ideas?

I'd suggest trying the plain-text approach with "smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd" first. If that works, you know client SASL is functional. Then it's just a matter of figuring out the right way of getting Postfix to pull the credentials from MySQL correctly (sorry, don't know anything about that).

well you were right about that.. it didn't work with the plain text approach... BUT i did manage to fix it after awhile...

but still nothing on getting it into a MySQL database

alright, I figured it out... so for the benefit of others:

ASSUMING everything works with sasl_password as plain_text (or using the hash approach)... ie. "smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd". Also, I'm assuming you've setup MySQL and saslauthd for use with postfix (see the email guide in linode library)

For MySQL:

in main.cf:


mysql-sasl_passwd.cf:


I used AES_ENCRYPT/AES_DECRYPT in order to have SOME level of encryption on the passwords..

I plan on writing a more detailed version on my mini blog in the next few days.. but hopefully others who have the same problem may find this useful..

Great, glad you got it working!