Seit dem Upgrade auf Ubuntu 14.04 kann ich mich nicht mehr an Dovecot anmelden, weder über KMail noch über Roundcube.
In der mail.log steht folgendes:
1 2 3 | auth-worker(3325): Error: sql(XXXXX@example.de,192.168.0.101): User query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':/var/vmail/example.de/XXXXX' AS mail, 150 AS uid, 8 AS gid, concat('dirsiz' at line 1 Error: Internal auth failure (client-pid=21945 client-id=1) imap-login: Internal login failure (pid=21945 id=1) (internal failure, 1 successful auths): user=<XXXXX@sonnensystem.de>, method=PLAIN, rip=192.168.0.101, lip=192.168.0.100, mpid=21946, TLS, session=<WdwfCev+3wDAqABl> |
Meine dovecot-sql.conf.ext hat diese Einträge:
1 2 3 4 5 6 | driver = mysql connect = host=localhost dbname=mail user=mail password=password default_pass_scheme = MD5-CRYPT password_query = SELECT username AS user, password, '/var/vmail/%d/%n'AS userdb_home, 'maildir:/var/vmail/%d/%n' AS userdb_mail, 150 AS userdb_uid, 8 AS userdb_gid FROM mailbox WHERE username = '%u' AND active = '1' user_query = SELECT '/var/vmail/%D/%N' AS home, 'maildir:/var/vmail/%d/%n' AS mail, 150 AS uid, 8 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1' iterate_query = SELECT username AS user FROM users |
Wo muß ich den Fehler suchen?