Hello, Thanks for your replies so far. Still having issues with per-user quotas. To my Mysql virtual_users table I've added a column quota_kb and for a test user I've added in a value of 250000 going for a 250 megabyte quota.
I've tried various sql queries they're returning empty sets not pulling out the information needed. Thanks. Dave. On 10/12/12, Daniel Parthey <daniel.part...@informatik.tu-chemnitz.de> wrote: > Hi Dave, > > David Mehler wrote: >> Thanks for your reply. I've written you directly as it is sounding >> like at least for now this isn't dovecot it's well a mysql issue with >> design. I don't have anything in my database setup with regards quota >> I've included it below. I've got one virtual mail user called vmail >> with UID/GID of 5000 who owns all the virtual mailboxes. If I'm >> understanding what I've read in the link, the dovecot wiki and your >> message since anything in a user section of Mysql will override the >> global configuration in 90-quota.conf, that being the case I should >> add an extra column to virtual users? Once that's done adjust the >> userdb query for dovecot to return quota information? > > Yes, the quota should be stored in an additional userdb column, > or you need at least an SQL statement which takes a username > and returns a quota rule. > > Quota of 0 is interpreted as "unlimited" by dovecot. > As already said, if the value in the quota column for the > user is 0, your SQL statement could also return a different > value (default quota) instead of 0 (using MySQL CASE/ELSE statement). > > Here is a short documentation on how it is done with Tine 2.0 Groupware: > http://www.tine20.org/wiki/index.php/Admins/Mailserver_integration > (it is a simple example which does not support a default quota fallback, > since Tine 2.0 writes the default quota as a value into the column > when the user is created) > > Regards > Daniel > -- > https://plus.google.com/103021802792276734820 >
