iterate_query with static userdb ?

[Laura Smith]

On Sunday, 17 May 2020 10:38, Aki Tuomi <aki.tuomi at open-xchange.com> wrote:

> > On 17/05/2020 12:34 Laura Smith <n5d9xq3ti233xiyif2vp at protonmail.ch> wrote:
> >
> > Hi,
> >
> > Going by the "static userdb" example  on this page (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar setup in conjunction with pgsql for passdb.
> >
> > However I get an error "auth: Warning: sql: Ignoring changed iterate_query in /etc/dovecot/local_sql_users.conf, because userdb sql not used. (If this is intentional, set userdb_warning_disable=yes)"
> >
> > Does this mean the following is not a valid config ? Or at least I will not be able to achieve iteration ?
> >
> > mail_location = maildir:/foobar/mail/%d/%n/Maildir
> > passdb {
> >   driver = sql
> >   args = /etc/dovecot/local_sql_users.conf
> > }
> > userdb {
> >   driver = static
> >   args = uid=foo gid=bar home=/foobar/mail/%d/%n
> > }
>
> It's valid but why do it like this? You can return these fields with user_query in the sql config. 
>
> Aki
>
> ---
> Aki Tuomi

Because I wanted to avoid storing uid/gid/home in the database ?