I'm running into some problems setting up Courier-IMAP with MySQL virtual accounts. I've configured everything similar to other installations in the past, but this is the first time I've used Courier-IMAP 4.x with the new authlib. Here is the logging from a POP connection:

Feb 25 07:52:44 ermail authdaemond: received auth request, service=pop3, authtype=login Feb 25 07:52:44 ermail authdaemond: authmysql: trying this module Feb 25 07:52:44 ermail authdaemond: SQL query: SELECT username, password, "", uid, gid, home, maildir, quota, name, "" FROM mailbox WHERE username = "testuser" Feb 25 07:52:44 ermail authdaemond: mysql_query failed, reconnecting: Unknown column 'uid' in 'field list' Feb 25 07:52:44 ermail authdaemond: mysql_query failed second time, giving up: Unknown column 'uid' in 'field list' Feb 25 07:52:44 ermail authdaemond: authmysql: TEMPFAIL - no more modules will be tried Feb 25 07:52:44 ermail pop3d: authentication error: Input/output error

Here is my authmysqlrc:

MYSQL_USERNAME postfix MYSQL_DATABASE postfix MYSQL_CRYPT_PWFIELD password MYSQL_USER_TABLE mailbox MYSQL_LOGIN_FIELD username MYSQL_MAILDIR_FIELD maildir MYSQL_NAME_FIELD name MYSQL_PASSWORD postfix MYSQL_QUOTA_FIELD quota MYSQL_SERVER localhost MYSQL_SOCKET /var/lib/mysql/mysql.sock

I can't figure out why those empty "" fields or the uid/gid are being inserted into the SQL query. Can anyone enlighten me? If this can't be fixed without modifying the schema, can anyone suggest a MYSQL_SELECT_CLAUSE for the following schema?

mysql> describe mailbox; +----------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------------------+-------+ | username | varchar(255) | | PRI | | | | password | varchar(255) | | | | | | name | varchar(255) | | | | | | maildir | varchar(255) | | | | | | quota | int(10) | | | 0 | | | domain | varchar(255) | | | | | | created | datetime | | | 0000-00-00 00:00:00 | | | modified | datetime | | | 0000-00-00 00:00:00 | | | active | tinyint(1) | | | 1 | | +----------+--------------+------+-----+---------------------+-------+ 9 rows in set (0.00 sec)

Thanks,