Ubuntu 10.04 -> 12.04 and SASL

[The Other Air Force]

Hey,
Had some trouble initially with SASL when I upgraded Ubuntu.

In /etc/postfix/sasl/smtpd.conf I had to change the following:

auxprop_plugin: mysql 
sql_select: select password from mail_user where login = '%u'

to

sql_select: select password from mail_user where login = '%u@%r'
auxprop_plugin: sql

Moderately annoying to figure out.

[otto06217]

Originally Posted by The Other Air Force

Hey,
Had some trouble initially with SASL when I upgraded Ubuntu.

In /etc/postfix/sasl/smtpd.conf I had to change the following:

auxprop_plugin: mysql 
sql_select: select password from mail_user where login = '%u'

to

sql_select: select password from mail_user where login = '%u@%r'
auxprop_plugin: sql

Moderately annoying to figure out.

You made my day!

Thanx