I would add some informations: auth lookup works fine with doveadm:
$ doveadm auth lookup acco...@domain.tld passdb: acco...@domain.tld user : acco...@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 acco...@domain.tld > /var/vmail/domain.tld/account/.sieve INBOX.Refilter' vmail > > gives me > > sieve-filter(vmail): Error: user acco...@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(acco...@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.cre...@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
