> On 16/12/2024 22:07 EET Stanislav via dovecot <dovecot@dovecot.org> wrote:
>
>
> Greetings,
> I have a mail server for a few folks, basically my family.
> My current Dovecot configuration is the following, which works like a
> charm:
> ==========
> passdb {
> driver = sql
> args = /usr/local/etc/dovecot/dovecot-sql.conf.ext
> }
> userdb {
> driver = static
> args = uid=981 gid=981 home=/var/mail/virtual/%d/%n/home
> }
> ==========
>
> I've decided to deploy Solr to be able to search faster.
> Now, when I try to execute "doveadm index -A inbox" I get an error
> "Error: auth-master: userdb list: User listing returned failure" because
> I'm using the static userdb.
>
> My question is, how do I implement the listing users feature while using
> "static driver" or a similar approach? I really want to keep using the
> template "/var/mail/virtual/%d/%n/home" instead of defining a custom
> path for each user.
>
> So I came up with this idea to replace "static" with "sql" driver for
> "userdb" since there's "iterate_query" I can use to achieve my goal, tho
> I have to define "user_query", so I can do something like:
> =======
> SELECT '/var/mail/virtual/%d/%n/home' AS maildir, 981 AS uid, 981 AS gid
> FROM mailbox WHERE username='%u' and active='1';
> =======
> However, this is a useless waste of resources since I'm not really
> querying anything, and I'm not even sure if there's template support
> (e.g., %d/%n) in there.
>
> Appreciate any help
> Best
You could get rid of the static userdb with these settings
mail_uid = 981
mail_gid = 981
mail_home = /var/mail/virtual/%d/%n/home
and ensure you have iterate_query in your SQL config.
Should do the trick.
Aki
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
