Thanks Till for that tip.
I added the following line to the file
/etc/courier/authmysqlrc:
Code:
MYSQL_WHERE_CLAUSE enabled=1
Squirrelmail login will now correctly fail if the email account has a zero in the enabled field.
For SMTP then, which of the six files in the tutorial need to have the WHERE clause added? My initial thought was
/etc/postfix/mysql-virtual_mailboxes.cf. Are there others?
Additionally, do I need to change anything with:
Code:
sql_select: select password from users where email = '%u'
in the file vi
/etc/postfix/sasl/smtpd.conf.
Thanks.