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 th
David Mehler wrote:
> Thanks, so if I understand what your saying the reason I'm getting the
> column update issues is Dovecot is reading from and writing to the
> quota and quota_messages columns in my virtual_users table?
>
> My database user I believe only has select permissions on that table.
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
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...
# p
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 column
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 wa
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
D
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 tabl
