[Dovecot] Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'
When I wanna run
su -c 'sieve-filter -D -v -W -C -u account@domain.tld /var/vmail/domain.tld/account/.sieve INBOX.Refilter' vmail
I get
sieve-filter(vmail): Error: user account@domain.tld: Auth USER lookup failed sieve-filter(vmail): Fatal: Internal error occurred. Refer to server log for more information.
on log file I see this:
Feb 17 16:21:34 mail1 dovecot: auth-worker(8430): Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause' Feb 17 16:21:34 mail1 dovecot: auth-worker(8430): Error: sql(account@domain.tld): User query failed: Unknown column 'filter' in 'where clause'
After activated debug I cold find this:
Feb 20 14:57:59 mail1 dovecot: auth: Debug: master in: USER#0111#011account@domain.tld#011service=sieve-filter Feb 20 14:57:59 mail1 dovecot: auth-worker(29572): Debug: sql(account@domain.tld): SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = 'account@domain.tld' OR email = 'account@domain.tld') AND disablesieve-filter = 'n' Feb 20 14:57:59 mail1 dovecot: auth-worker(29572): Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause' Feb 20 14:57:59 mail1 dovecot: auth-worker(29572): Error: sql(account@domain.tld): User query failed: Unknown column 'filter' in 'where clause' Feb 20 14:57:59 mail1 dovecot: auth: Debug: userdb out: FAIL#0111
So it means, that
a) ISPConfig missed the database column disablesieve-filter and b) need to quote column name on the sql-query for user_query = ...