dovecot - Feb 2014 - Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'

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

I would add some informations:

auth lookup works fine with doveadm:

$ doveadm auth lookup account at domain.tld
passdb: account at domain.tld
  user      : account at domain.tld

Any Ideas?

Thomas

Am 17.02.2014 16:31, schrieb Thomas Creutz:
> 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
-- 
MfG
Thomas Creutz

Topackt IT Solutions GmbH
Altspeyerer Weide 2
67346 Speyer
---------------------------------------
Mobil: 0151-11711132
Tel:   06232-31504-0
Fax:   06232-31504-240
-----------------------------------------------
Mail: t.creutz at topackt.com
WWW:  http://www.topackt.com
pgp:  https://ssl.topackt.com/pgp/
Xing: http://www.xing.com/go/invite/5799158.1aa7c1
-------------------------------------------------------
Registergericht: Amtsgericht Ludwigshafen, HRB 53097
Gesch?ftsf?hrer: Michael Nist