[Dovecot] Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'

Thomas Creutz t.creutz at topackt.com
Mon Feb 17 15:31:53 UTC 2014


Hi List,

I have a problem with dovecot 2.2.12 and sieve-filter call:

su -c 'sieve-filter -D -v -W -C -u account at domain.tld
/var/vmail/domain.tld/account/.sieve INBOX.Refilter' vmail

gives me

sieve-filter(vmail): Error: user account at 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 at domain.tld): User query failed: Unknown column 'filter' in
'where clause'

but I never used filter in dovecot:

grep -iR filter /etc/dovecot/

gives me no result (and yes the dir is right).

Any Idea whats wrong? I know it tells me, that the column is missing in
the Database - but why I need it? I also never see it documented somewhere:

http://wiki2.dovecot.org/AuthDatabase/SQL
http://wiki2.dovecot.org/PasswordDatabase/ExtraFields

Thomas



More information about the dovecot mailing list