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.
Thanks, Aki!
I added those properties and also commented out the following line:
user_query = SELECT maildir, 981 AS uid, 981 AS gid FROM mailbox WHERE
username='%u' and active='1'
After that, I started seeing errors like:
dovecot[29855]: auth-worker(29871): Warning: sqlpool(mysql): Query
failed, retrying: Table 'mail.users' doesn't exist
dovecot[29855]: auth-worker(29871): Error: conn unix:auth-worker
(uid=143): auth-worker<26>: sql(omitted,<nFRU7G4pK
jsEDmqT>): User query failed: Table 'mail.users' doesn't exist (using
built-in default user_query: SELECT home, uid, gid FROM users WHERE
username = '%n' AND domain = '%d')
To fix it, I set user_query to this:
user_query = SELECT username FROM mailbox WHERE username='%u' AND
active='1'
Now, it returns the "username" but I’m not sure how useful that is for
Dovecot in the user_query context. That said, everything seems to be
working fine now.
Does this look like the right approach?
Thanks!
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
