iterate_query with static userdb ?

James list at xdrv.co.uk
Sun May 17 13:11:29 EEST 2020


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 gid are not stored in my database but are returned by the query.


More information about the dovecot mailing list