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.cre...@topackt.com>:
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