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

2014-02-20 Thread Thomas Creutz
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 th

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

2014-02-20 Thread Thomas Creutz
This sql query must be build somewhere from dovecot itself. I can add the column name to the user_qeuery: 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 sie

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

2014-02-20 Thread 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 :

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

2014-02-20 Thread Thomas Creutz
Ok, today I did the debug test: Feb 20 14:57:59 mail1 dovecot: auth: Debug: master in: USER#0111#011acco...@domain.tld#011service=sieve-filter Feb 20 14:57:59 mail1 dovecot: auth-worker(29572): Debug: sql(acco...@domain.tld): SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Mai

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

2014-02-18 Thread 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 : I would add some informations: auth lookup works fine with doveadm: $ doveadm auth lookup acco...@domain.tld passdb: acco...@domain.tld user

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

2014-02-18 Thread Thomas Creutz
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-f

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

2014-02-17 Thread 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: