Re: iterate_query with static userdb ?

2020-05-17 Thread Laura Smith
On Sunday, 17 May 2020 11:11, James wrote: > On 17/05/2020 10:43, Laura Smith wrote: > > > Because I wanted to avoid storing uid/gid/home in the database ? > > I use: > > user_query = "SELECT 'vmail' AS uid, 'vmail' AS gid, allow_nets, > '*:storage=' || quota || 'M' AS quota_rule FROM mailbox

Re: iterate_query with static userdb ?

2020-05-17 Thread James
On 17/05/2020 10:43, Laura Smith wrote: Because I wanted to avoid storing uid/gid/home in the database ? I use: user_query = "SELECT 'vmail' AS uid, 'vmail' AS gid, allow_nets, '*:storage=' || quota || 'M' AS quota_rule FROM mailbox WHERE username = '%n' AND domain = '%d';" ... uid and

Re: iterate_query with static userdb ?

2020-05-17 Thread Laura Smith
On Sunday, 17 May 2020 10:38, Aki Tuomi wrote: > > On 17/05/2020 12:34 Laura Smith 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. > >

Re: iterate_query with static userdb ?

2020-05-17 Thread Aki Tuomi
On 17/05/2020 12:34 Laura Smith wrote: Hi, Going by the "static userdb" example  on this page (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar

iterate_query with static userdb ?

2020-05-17 Thread Laura Smith
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,