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,
-- Jason Dixon DixonGroup Consulting http://www.dixongroup.net
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ courier-users mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
