Oh ok, so I could fix it now by my self - Thanks :) Am 20.02.2014 15:17, schrieb Michael Cramer: > This comes from your password query 'disablesieve-filter' is the > result of 'AND disable%Ls' %Ls specifies the lowercase protocol name. > If you have these column in your database you need to set this in 'AND > `disable%Ls` ' to allow a column name with the minus sign. > > Zitat von Thomas Creutz <[email protected]>: > >> Ok, today I did the debug test: >> >> Feb 20 14:57:59 mail1 dovecot: auth: Debug: master in: >> USER#0111#[email protected]#011service=sieve-filter >> Feb 20 14:57:59 mail1 dovecot: auth-worker(29572): Debug: >> sql([email protected]): SELECT email as user, maildir as home, >> CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, >> CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, >> '/.sieve') as sieve FROM mail_user WHERE (login = '[email protected]' >> OR email = '[email protected]') AND disablesieve-filter = 'n' >> Feb 20 14:57:59 mail1 dovecot: auth-worker(29572): Warning: mysql: Query >> failed, retrying: Unknown column 'filter' in 'where clause' >> Feb 20 14:57:59 mail1 dovecot: auth-worker(29572): Error: >> sql([email protected]): User query failed: Unknown column 'filter' in >> 'where clause' >> Feb 20 14:57:59 mail1 dovecot: auth: Debug: userdb out: FAIL#0111 >> >> my dovecot-sql.conf holds this: >> ----- >> driver = mysql >> connect = host=localhost dbname=dbispconfig user=ispconfig >> password=XXXXXXXX >> default_pass_scheme = CRYPT >> >> password_query = SELECT password FROM mail_user WHERE (login = '%u' OR >> email = '%u') AND disable%Ls = 'n' >> user_query = SELECT email as user, maildir as home, CONCAT('maildir:', >> maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') >> AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE >> (login = '%u' OR email = '%u') AND disable%Ls = 'n' >> >> iterate_query = SELECT email as user FROM mail_user >> ----- >> >> From where comes the disablesieve-filter? >> >> Thomas >> >> Am 18.02.2014 11:10, schrieb 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 <[email protected]>: >>> >>>> I would add some informations: >>>> >>>> auth lookup works fine with doveadm: >>>> >>>> $ doveadm auth lookup [email protected] >>>> passdb: [email protected] >>>> user : [email protected] >>>> >>>> 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 [email protected] >>>>> /var/vmail/domain.tld/account/.sieve INBOX.Refilter' vmail >>>>> >>>>> gives me >>>>> >>>>> sieve-filter(vmail): Error: user [email protected]: 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([email protected]): 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: [email protected] >>>> 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 >> >> -- >> MfG >> Thomas Creutz >> >> Topackt IT Solutions GmbH >> Altspeyerer Weide 2 >> 67346 Speyer >> --------------------------------------- >> Mobil: 0151-11711132 >> Tel: 06232-31504-0 >> Fax: 06232-31504-240 >> ----------------------------------------------- >> Mail: [email protected] >> 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
-- MfG Thomas Creutz Topackt IT Solutions GmbH Altspeyerer Weide 2 67346 Speyer --------------------------------------- Mobil: 0151-11711132 Tel: 06232-31504-0 Fax: 06232-31504-240 ----------------------------------------------- Mail: [email protected] 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
