[Dovecot] MySQL dict issues

[list at airstreamcomm.net]

On 7/17/12 7:59 AM, Timo Sirainen wrote:
> On 11.7.2012, at 21.10, list at 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, dude at 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.
It does indeed, thanks.
>
>> 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?
There were two rows being created for each username.  My problem was 
that I forgot to create a PK on the username field, so there must be two 
operations on the database that create/update user information by 
dovecot that require that PK to keep it to one row.
>
>> 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.
Thanks!