Re: Panic: lib-sql: Too many bind args

2021-08-11 Thread dovecot
Maybe there's something wrong with my "map" configuration, which led to the improper syntax (see original email), but it's Dovecot that generated the syntax. I have not used dictionaries and do not have first hand working knowledge. Until someone else more knowledgeable chimes in, this is my

Re: Panic: lib-sql: Too many bind args

2021-08-11 Thread Joseph D Wagner
On 8/11/21 2:48 PM, dove...@ptld.com wrote: On 08-11-2021 5:39 pm, Joseph D Wagner wrote: dovecot[51153]: dict(51395): Panic: lib-sql: Too many bind args (2) for statement: SELECT attr_name FROM attributes WHERE attr_name LIKE AND username = ? No idea if this is the only problem, but the sql

Re: Panic: lib-sql: Too many bind args

2021-08-11 Thread dovecot
On 08-11-2021 5:39 pm, Joseph D Wagner wrote: dovecot[51153]: dict(51395): Panic: lib-sql: Too many bind args (2) for statement: SELECT attr_name FROM attributes WHERE attr_name LIKE  AND username = ? No idea if this is the only problem, but the sql query has invalid syntax. SELECT attr_n

Panic: lib-sql: Too many bind args

2021-08-11 Thread Joseph D Wagner
From /etc/dovecot/dovecot.conf: mail_attribute_dict = proxy::attr dict { attr = pgsql:/etc/dovecot/dovecot-attr-sql.conf.ext } From /etc/dovecot/dovecot-attr-sql.conf.ext: map { pattern = $key table = attributes fields { attr_name = $key } username_field = username value_fi

ACL's using SQL Backend

2021-08-11 Thread Joseph D Wagner
I don't want to use vfile as the acl backend. I want to use sql, but it seems to be sparsely documented.  Would this work? create table acls (   acl_name varchar(255) not null,   username varchar(320) not null default '',   acl_value varchar not null,   constraint acls_pk primary key (acl_na

Re: Get Director vhostCount

2021-08-11 Thread William Edwards
Hi, William Edwards schreef op 2021-07-24 18:11: Hi, I would like to monitor each mail server's amount of available vhosts, so I can take action when a certain threshold is reached (e.g. adding mail servers). I'm using Dovecot 2.3.4.1 with Director. My first idea was to use the Doveadm HTTP AP

Re: JWT local validation

2021-08-11 Thread Aki Tuomi
You can fashion such thing using the dict protocol, we have no plans to include that kind of tooling with community dovecot at this moment. Aki > On 11/08/2021 10:06 Tomas Habarta wrote: > > > Yep, that was the point, RFC states typ header as optional so I was looking > for some workaround

Re: JWT local validation

2021-08-11 Thread Tomas Habarta
Yep, that was the point, RFC states typ header as optional so I was looking for some workaround as the implementation did not put it in the tokens. Fortunately, I had a great luck as developers were so kind and added it with next minor release -- so this is sorted and local validation works grea