So my setup is as follows... I have a test account, '[EMAIL PROTECTED]', in the mysql table. My authmysqlrc field has this relevant configuration:
MYSQL_USER_TABLE users MYSQL_LOGIN_FIELD id MYSQL_HOME_FIELD home MYSQL_DEFAULTDELIVERY delivery
The MYSQL_SELECT_CLAUSE uses the users table and returns the approriate fields, as follows: users.id,users.crypt,users.clear, \ users.mail_uid,users.gid,users.home,'',users.quota, \ '',users.delivery
That's not correct. DEFAULTDELIVERY is *not* the last field in the custom query. Read the comments for the detailed explanation:
# $(service) will expand out to the service being authenticated: imap, imaps, # pop3 or pop3s. Courier mail server only: service will also expand out to # "courier", when searching for local mail account's location. In this case, # if the "maildir" field is not empty it will be used in place of # DEFAULTDELIVERY. Courier mail server will also use esmtp when doing # authenticated ESMTP.
You want the maildir field to contain something like:
IF(STRCMP('$(service)', 'courier') == 0, users.delivery, '')
pgp00000.pgp
Description: PGP signature
