when I use squirrelmail to login postfix,it show the error on the window:
 ERROR: Connection dropped by IMAP server

when I check the log  on  /var/log/maillog,it  show the errors include:
  mail imapd: LOGIN FAILED

and the log  in /var/log/debug.log show follows:
Oct 25 04:16:59 mail imapd: Connection, ip=[127.0.0.1]
Oct 25 04:16:59 mail authdaemond: received auth request, service=imap, authtype=login
Oct 25 04:16:59 mail authdaemond: authmysql: trying this module
Oct 25 04:17:00 mail authdaemond: SQL query: SELECT username, password., "", uid, '80', '/usr/local/virtual', maildir, "", name, "" FROM mailbox WHERE username = "chao@srcloft3.3322.org"
Oct 25 04:17:00 mail authdaemond: mysql_query failed, reconnecting: Unknown column 'uid' in 'field list'
Oct 25 04:17:00 mail authdaemond: mysql_query failed second time, giving up: Unknown column 'uid' in 'field list'
Oct 25 04:17:00 mail authdaemond: authmysql: TEMPFAIL - no more modules will be tried
 

solution:
there must be something wrong in /usr/local/etc/authlib/authmysqlrc
.find out the line:
MYSQL_UID_FIELD                uid

and change to :
MYSQL_UID_FIELD                80

本文出自 “doff” 博客，谢绝转载！

本文出自 51CTO.COM技术博客