On 08/15/2013 10:50 AM, LuKreme wrote:
"Error: user lists@*munged*: Couldn't drop privileges: User is missing UID (see mail_uid setting)"
These are all virtual users with a hid of 89. How do I tell dovecot that?
$ cat /etc/dovecot/dovecot-sql.conf.ext driver = mysql connect = host=localhost dbname=postfix user=dovecot password=dovecot default_pass_scheme = MD5-CRYPT password_query = select password from mailbox where username ='%u' user_query = select concat('/usr/local/virtual/', maildir) from mailbox where username = '%u'
In my SQL configuration I have something like this:
user_query =
SELECT _home AS home, _uid AS uid, _gid AS gid
FROM virtual_mailboxes
WHERE _recipient='%u' AND _active=1
Using this I can give certain users a different UID/GID, should I want to. But if I'm not mistaken you can also statically configure the uid and gid. On page http://wiki2.dovecot.org/VirtualUsers, the last example says:
userdb { driver = static args = uid=vmail gid=vmail home=/var/mail/virtual/%d/%n }
I guess you should be able to adapt this to your SQL config.
-- Rob