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

[Michael Cramer]

you can try to turn on the debug logging so that you can see which  
query is executed

mail_debug=yes
auth_debug=yes


Zitat von Thomas Creutz <t.creutz at topackt.com>:

> 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