On 12/25/2012 03:59 PM, A.L.E.C wrote:
On 12/25/2012 12:35 PM, robert rottermann wrote:
25-Dec-2012 12:21:15 +0100: S: OK "Capability completed." 25-Dec-2012 12:21:15 +0100: C: AUTHENTICATE "PLAIN" "AHJvYmVydEByZWRjb3IuY2gAY29jbzJkaWw=" [25-Dec-2012 12:21:17 +0100]: S: NO "Authentication failed." [25-Dec-2012 12:21:17 +0100]: C: LOGOUT [25-Dec-2012 12:21:17 +0100]: S: OK "Logout completed."
now I am WAY above my head. If I interpret that log entry correctly, roundcube tries to log in using a password but fails. Where does that password come from? Why does it not use the one that was used to log into roundcube?
It uses the same password. Try with enabled managesieve_usetls option.
Thanks Alec for your help, the problem was, that with the mail database I use which was created some years ago by the now defunct syscon tool suite a sql query was generated that failed when service was sieve.
For the sake of other that might run into the same problem my fix:
The failing query was like this (in the dovecot configuration): password_query = SELECT username AS user, password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS userdb_uid, gid AS userdb_gid, CONCAT('maildir:', homedir, maildir) AS userdb_mail, CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM mail_users WHERE (username = '%u' OR email = '%u') AND ((imap = 1 AND '%Ls' = 'imap') OR (pop3 = 1 AND '%Ls' = 'pop3') OR '%Ls' = 'smtp') which I changed to: password_query = SELECT username AS user, password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS userdb_uid, gid AS userdb_gid, CONCAT('maildir:', homedir, maildir) AS userdb_mail, CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM mail_users WHERE (username = '%u' OR email = '%u') AND ((imap = 1 AND '%Ls' = 'imap') OR (pop3 = 1 AND '%Ls' = 'pop3') OR '%Ls' = 'smtp' OR '%Ls' = 'sieve')
This I found out by enabling logging in dovecot.
thanks again Robert
The only thing I added is the last or condition.