On 11.7.2012, at 21.10, l...@airstreamcomm.net wrote: > Testing using the mysql dict for quota storage (dovecot-2.0.12-2_127.el5), > and ran into a couple issues. First is a permissions issue: > > dovecot: lmtp(26786, d...@test.tld): Error: > net_connect_unix(/var/run/dovecot/dict) failed: Permission denied > (euid=5000(<unknown>) egid=5000(<unknown>) missing +r perm: > /var/run/dovecot/dict, euid is not dir owner) > > The file /var/run/dovecot/dict is listed with srw------- perms. I changes > the perms to srw----rwx and it works, but I would like to figure out how to > configure properly to run with the uid and gid 5000 as this is the user for > virtual mail.
http://wiki2.dovecot.org/Dict explains this. > The second issue is that two identical rows are created in the mysql database > for each user quota. The next message delivered updates both rows. Identical? Or perhaps one is the number of bytes and the other is the number of messages? > The last issue might be a documentation omission. Dovecot warned me that the > mysql user did not have DELETE privileges on the quota table: > > dovecot: dict: Error: sql dict: commit failed: DELETE command denied to user > 'user'@'a.b.c.d' for table 'domain_user_quotas' This is done when recalculating quota. > The quota dict documentation (at http://wiki2.dovecot.org/Quota/Dict) does > not mention DELETE being needed: Updated.