View Single Post
  #3  
Old 7th June 2008, 23:34
atjensen11 atjensen11 is offline
Senior Member
 
Join Date: Dec 2007
Posts: 199
Thanks: 9
Thanked 6 Times in 6 Posts
Default

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.
Reply With Quote