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 http://www.phdcomputing.net/
