Re: [Dovecot] still having difficulties with per-user quotas

2012-10-21 Thread Daniel Parthey
Hi Dave, David Mehler wrote: Thanks for all your help so far. I have per-user quotas now working, I had to also alter my dict config file as well. I am having two outstanding issues, actually one outstanding issue and one question. Here's the question, given that the userdb sql query

Re: [Dovecot] still having difficulties with per-user quotas

2012-10-21 Thread David Mehler
Hello, Thanks. I've created a quota table as described in dovecot-dict sql configuration file and granted the mail user select, insert, update, and delete rights to that table, while the virtual_users table select rights only. I configured for the new table. Here's my config, have I got it? Are

Re: [Dovecot] still having difficulties with per-user quotas

2012-10-20 Thread Daniel Parthey
David Mehler wrote: Oct 19 15:23:52 imap(xxx): Error: user xxx: Couldn't drop privileges: User is missing UID (see mail_uid setting) Set the following options in your dovecot.conf: mail_uid = vmail mail_gid = vmail Also see section Mail users at http://wiki2.dovecot.org/UserIds Regards

Re: [Dovecot] still having difficulties with per-user quotas

2012-10-20 Thread David Mehler
Hello, Thank you for your reply. Adding mail_uid and mail_gid fixed it. I now have quotas going but I don't know if I have them right or just don't like my setup. My first issue is from what it is looking like I have to define all my users in the quota database not just the ones whose values I

Re: [Dovecot] still having difficulties with per-user quotas

2012-10-20 Thread Daniel Parthey
David Mehler wrote: My first issue is from what it is looking like I have to define all my users in the quota database not just the ones whose values I want to override the global quota declaration in 90-quota.conf. If I just add the user@domain to the database the bytes and messages columns

Re: [Dovecot] still having difficulties with per-user quotas

2012-10-20 Thread Daniel Parthey
David Mehler wrote: Thanks for your reply. So with the extending of the query to return a default quota rule, do you have an example of that by the way, does that mean I only have to put the overrided users in the quota table? Assuming that quota values are in the dovecot_users table... #

[Dovecot] still having difficulties with per-user quotas

2012-10-19 Thread David Mehler
Hello, I am trying to get per-user quotas working. My thanks to all who have helped so far. To recap I am running Dovecot 2.1 and Mysql where I've got my virtual users. All virtual users are under the system user vmail with a UID and GID of 5000. Looking over the wiki docs I've added a quota