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 = "[email]chao@srcloft3.3322.org[/email]"
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
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 = "[email]chao@srcloft3.3322.org[/email]"
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
转载于:https://blog.51cto.com/doffo/47714