Franck wrote:
> Hi,
>> Hi
>> i've a problem with quota support in vpopmail and vqadmin (vqadmin 2.3.6
>> and vpopmail 5.4.13)
>> Vpopmail config is in MysQl database in limits table.
>> I've a domain with 200 account and quota 2000M
>> But i can't update quota more than 2000M with vqadmin or directly in the
>> limits table (diskquota and defaultquota  int12) :(
>> What's the solution ?
>> If i put 0 in quota, is 0 like no limit ?
> perhaps, i've found ...
> Int(12) = -2147483648 -> 2147483647
> and 2Gb in octet near 2000000000
> Can i changed int by bigint in table schema for diskquota and defaultquota ?
> Will vpopmail, vqadmin and qmailadmin always work ?
> Franck

It isn't just a database thing, the actual code in the maildir++ patch
and in vpopmail needs to be changed.

>From a while back on the list:

** snip **

From: Tom Collins
Date: Mon, 15 Jan 2007 15:32:35 -0800
Subject: Re: [vchkpw] vpopmail max quota of 2GB

On Jan 15, 2007, at 9:29 AM, Iulian Liviu Ionescu wrote:
> It seems that there's a limit in quota at 2GB. What are the options
> available to have mail accounts with more than 4 GB quota?

One options: rewrite the Maildir++ patches for qmail and POP/IMAP
servers, along with vpopmail's quota support code to use a larger
variable type to store the sizes (long long?).  It might be possible
to work around it with a hack of storing message sizes in bytes, but
the total of the sizes (and the user's quota) in KB.  This would get
you up to 2TB quotas.

foreach message_size do {
   bytes += message_size;
   kbytes += bytes / 1024;
   bytes = bytes % 1024;

I'm sure that at the time it was written, 2GB seemed like an insane
quota for a mailbox.  Unfortunately it's now a realistic number.

Keep in mind that if you've got 2GB mailboxes, it probably requires
lots of resources to recalculate disk usage.  Consider running a
nightly cronjob that calculates disk usage for all email users and
warns the ones who are over "quota".  If they stay over for a certain
period, bill them or turn their account off.

Not a pretty solution, but I'm afraid there's no easy way to support
quotas over 2GB.

** snip **

Michael Johnson
System Administrator                      [EMAIL PROTECTED]
PhD Computing                

Reply via email to