I use dovecot 1.0rc25 in dovecot.conf: auth default { mechanisms = LOGIN CRAM-MD5 DIGEST-MD5 PLAIN APOP passdb sql { args=/etc/dovecot-crammd5.conf } passdb sql { args=/etc/dovecot-sql.conf } userdb sql { args=/etc/dovecot-sql.conf } }
in dovecot-sql.conf: driver = mysql connect = host=/var/run/mysql/mysql.sock port= dbname=mail user=vmailuser password=vmailpassword password_query = SELECT clear AS password , user FROM mailbox WHERE user = '%n' AND IF('%d'='',clear = '%w',domain = '%d') AND status ='1' LIMIT 1 user_query = SELECT CONCAT(home,'/',maildir) AS home, '1001' AS uid, '1001' AS gid,CONCAT('maildir:storage=', quota * 1024 ) AS quota FROM mailbox WHERE (user = '%n' AND status = '1') OR (user = '%n' AND domain = '%d' AND status = '1') default_pass_scheme = CLEARTEXT
in dovecot-crammd5.conf: driver = mysql connect = host=/var/run/mysql/mysql.sock port= dbname=mail user=vmailuser password=vmailpassword password_query = SELECT crypt AS password , user FROM mailbox WHERE user = '%n' AND status = '1' LIMIT 1 default_pass_scheme = CRAM-MD5
wen i "use secure authentication" and try login with thunderbird :
dovecot: Mar 02 10:49:39 Info: Dovecot v1.0.rc25 starting up
dovecot: Mar 02 10:49:40 Info: auth-worker(default): mysql: Connected to
/var/run/mysql/mysql.sock (mail)
dovecot: Mar 02 10:49:40 Info: auth-worker(default): mysql: Connected to
/var/run/mysql/mysql.sock (mail)
dovecot: Mar 02 10:49:47 Info: auth(default): client in: AUTH 1
CRAM-MD5 service=IMAP secured lip=192
.168.0.157 rip=192.168.0.64
dovecot: Mar 02 10:49:47 Info: auth(default): client out: CONT 1
PDY3MTAzMjE0OTY4NDA0MTguMTE3MjgzMjU4N0B0ZXN0Pg= =
dovecot: Mar 02 10:49:47 Info: auth(default): client in: CONT 1
YWRpIGU4N2JjYTZiYzA5OTZkYjY0MDk5ZTZjZmQ2YjUxNWE 2
dovecot: Mar 02 10:49:47 Info: auth-worker(default):
sql(adi,192.168.0.64): query: SELECT crypt AS password , user
FROM mailbox WHERE user = 'adi' AND status = '1' LIMIT 1
dovecot: Mar 02 10:49:47 Info: auth(default):
password(adi,192.168.0.64): Credentials:
abd122fc9335009004012948209313d3
b31b6fdbc502bab773e90f7a195d341b
dovecot: Mar 02 10:49:47 Info: auth(default): client out: OK 1
user=adi
dovecot: Mar 02 10:49:47 Info: auth(default): master in: REQUEST
1 4319 1
dovecot: Mar 02 10:49:47 Info: auth-worker(default):
sql(adi,192.168.0.64): SELECT CONCAT(home,'/',maildir) AS home,
'1 001' AS uid, '1001' AS gid,CONCAT('maildir:storage=',
quota * 1024 ) AS quota FROM mailbox WHERE (user = 'adi' AND
stat us = '1') OR (user = 'adi' AND domain = '' AND
status = '1')
dovecot: Mar 02 10:49:47 Info: auth(default): master out: USER 1
adi home=/srv/vmail/adrian.eu/adi/ uid=100 1
gid=1001 quota=maildir:storage=512000
dovecot: Mar 02 10:49:47 Info: imap-login: Login: user=<adi>,
method=CRAM-MD5, rip=192.168.0.64, lip=192.168.0.157, TLS
dovecot: Mar 02 10:49:48 Info: auth(default): client in: AUTH 1
CRAM-MD5 service=IMAP secured lip=192
.168.0.157 rip=192.168.0.64
dovecot: Mar 02 10:49:48 Info: auth(default): client out: CONT 1
PDE0NjQxNTExNDY4MDE5MTQuMTE3MjgzMjU4OEB0ZXN0Pg= =
dovecot: Mar 02 10:49:49 Info: auth(default): client in: CONT 1
YWRpIGI5YjliNmM3ZmMxMzUxMTU0Y2JiMGU2M2U4YmQxMzR k
dovecot: Mar 02 10:49:49 Info: auth(default):
password(adi,192.168.0.64): Credentials:
abd122fc9335009004012948209313d3
b31b6fdbc502bab773e90f7a195d341b
dovecot: Mar 02 10:49:49 Error: child 4311 (auth) killed with signal 11
restart thunderbird and try again to login:
dovecot: Mar 02 10:55:16 Info: auth(default): client in: AUTH 1
CRAM-MD5 service=IMAP secured lip=192.168.0.157
rip=192.168.0.64
dovecot: Mar 02 10:55:16 Info: auth(default): client out: CONT 1
PDMwMTQ0NjI3Njc3MTYzODEuMTE3MjgzMjkxNkB0ZXN0Pg==
dovecot: Mar 02 10:55:16 Info: auth(default): client in: CONT 1
YWRpIGMzYTRlODYwMTk1NjVkZDE1NDUzYzI5NGYxNWVhNjVm
dovecot: Mar 02 10:55:16 Info: auth(default):
password(adi,192.168.0.64): Credentials:
abd122fc9335009004012948209313d3b31b6fdbc502bab773e90f7a195d341b
dovecot: Mar 02 10:55:16 Error: child 4347 (auth) killed with signal 11
dovecot: Mar 02 10:55:18 Info: auth-worker(default): mysql: Connected to
/var/run/mysql/mysql.sock (mail)
dovecot: Mar 02 10:55:18 Info: auth-worker(default): mysql: Connected to
/var/run/mysql/mysql.sock (mail)
(In thunderbird : "Login to server failed.")
After that the login works ok :
dovecot: Mar 02 10:55:18 Info: auth-worker(default): mysql: Connected to
/var/run/mysql/mysql.sock (mail)
dovecot: Mar 02 10:55:18 Info: auth-worker(default): mysql: Connected to
/var/run/mysql/mysql.sock (mail)
dovecot: Mar 02 10:57:46 Info: imap-login: Aborted login:
method=CRAM-MD5, rip=192.168.0.64, lip=192.168.0.157, TLS
dovecot: Mar 02 10:57:53 Info: auth(default): client in: AUTH 1
CRAM-MD5 service=IMAP secured lip=192.168.0.157
rip=192.168.0.64
dovecot: Mar 02 10:57:53 Info: auth(default): client out: CONT 1
PDc2NzE5MTcwMzE4MzI1NzUuMTE3MjgzMzA3M0B0ZXN0Pg==
dovecot: Mar 02 10:57:53 Info: auth(default): client in: CONT 1
YWRpIGIxOGQ3NmFmMGIwYmU3OTkyMjk4MmI1OWRlYTQzNTQz
dovecot: Mar 02 10:57:53 Info: auth-worker(default):
sql(adi,192.168.0.64): query: SELECT crypt AS password , user FROM
mailbox WHERE user = 'adi' AND status = '1' LIMIT 1
dovecot: Mar 02 10:57:53 Info: auth(default):
password(adi,192.168.0.64): Credentials:
abd122fc9335009004012948209313d3b31b6fdbc502bab773e90f7a195d341b
dovecot: Mar 02 10:57:53 Info: auth(default): client out: OK 1
user=adi
dovecot: Mar 02 10:57:53 Info: auth(default): master in: REQUEST
6 4337 1
dovecot: Mar 02 10:57:53 Info: auth-worker(default):
sql(adi,192.168.0.64): SELECT CONCAT(home,'/',maildir) AS home, '1001'
AS uid, '1001' AS gid,CONCAT('maildir:storage=', quota * 1024 ) AS quota
FROM mailbox WHERE (user = 'adi' AND status = '1') OR (user = 'adi' AND
domain = '' AND status = '1')
dovecot: Mar 02 10:57:53 Info: auth(default): master out: USER 6
adi home=/srv/vmail/adrian.eu/adi/ uid=1001
gid=1001quota=maildir:storage=512000
dovecot: Mar 02 10:57:53 Info: imap-login: Login: user=<adi>,
method=CRAM-MD5, rip=192.168.0.64, lip=192.168.0.157, TLS
Everytime i have to input password for 2-3 times to login with secure authentication.