user_query = SELECT concat('/mail/', maildir) as home, concat('maildir:/mail/', maildir) as mail, 101 AS uid, 12 AS gid, concat('maildir:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1'
password_query = SELECT username as user, password, concat('/mail/', maildir) as userdb_home, concat('maildir:/mail/', maildir) as userdb_mail, 101 as userdb_uid, 12 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'
# fast but now so nice:-)
#user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/mail/%d/%n' as mail, 101 AS uid, 12 AS gid, concat ('dirsize:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1'
# Just in case you are using postfix the delimiter char "+", the above query will probably fail for the username '%
n' or '%u' and result in a "5.5.1 user unknown" error
#in this case, you will probalby want to use a separate user and domain part, whilst searching only for the
destination user part (user_query only):
# SELECT ... WHERE username = substring_index('%n','+',1) AND userrealm = '%d'
password_query = SELECT username as user, password, concat('/mail/', maildir) as userdb_home, concat
('maildir:/mail/', maildir) as userdb_mail, 101 as userdb_uid, 12 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'
# fast but now so nice:-)
#password_query = SELECT username as user, password, '/mail/%d/%n' as userdb_home, 'maildir:/mail/%d/%n' as userdb_mail, 101 as userdb_uid, 12 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'
我配dovecot的lda,一直不成功, 不知道什么地方配置錯了 作者: chenqiubite 時間: 2011-11-09 19:10
日志如下:
Nov 9 19:12:54 localhost postfix/qmgr[27602]: warning: private/dovecot socket: malformed response
Nov 9 19:12:54 localhost postfix/qmgr[27602]: warning: transport dovecot failure -- see a previous warning/fatal/panic logfile record for the problem description
Nov 9 19:12:54 localhost postfix/master[31932]: warning: process /usr/libexec/postfix/pipe pid 27707 exit status 1
Nov 9 19:12:54 localhost postfix/master[31932]: warning: /usr/libexec/postfix/pipe: bad command startup -- throttling
Nov 9 19:12:54 localhost postfix/error[27708]: 50EEE7363E1: to=<a@d1.com>, relay=none, delay=1, delays=0/1/0/0.01, dsn=4.3.0, status=deferred (unknown mail transport error) 作者: yoyocn 時間: 2012-03-07 14:16
總是出現(xiàn)訪問拒絕,導(dǎo)致SASL授權(quán)失敗,日志如下:
Mar 7 12:01:09 hp3 postfix/smtpd[26301]: xsasl_dovecot_server_connect: Connecting
Mar 7 12:01:09 hp3 postfix/smtpd[26301]: warning: SASL: Connect to private/auth failed: Permission denied
Mar 7 12:01:09 hp3 postfix/smtpd[26301]: fatal: no SASL authentication mechanisms