Postix Quota Increase

Discussion in 'HOWTO-Related Questions' started by toolz, Mar 21, 2009.

  1. toolz

    toolz New Member

    Hello,

    Followed Falco's how-to on setting up virtual users /domains on Fedora 10 and everything seems to be working fine but it seems the quota feature only allows up to 2GB and I have one client who needs 5GB.

    It seems that anything above 2GB puts the quota at unlimited and we don't want that. Is there a way to break the 2GB barrier?

    Thanks,

    Toolz
     
  2. falko

    falko Super Moderator Howtoforge Staff

    Do you use bigint(20) for the quota field in the users table?
     
  3. toolz

    toolz New Member

    Falco,

    Yes indeed.

    quota bigint(20) Yes 5368709120

    The funny thing is this, when it creates a user, it puts the following in the maildirsize file:

    2147483647S

    Which is 2GB. Is the limitation of the quota patch 2GB? Also if I manually adjust the maildirsize to anything higher, it then shows unlimited in the mail clients.

    Any ideas?

    Thanks,

    Toolz
     
  4. falko

    falko Super Moderator Howtoforge Staff

    What's the SQL statement you used to create that user?

    What happens when you try to increase the value in phpMyAdmin?
     
  5. toolz

    toolz New Member

    Falco,

    I just did an insert with phpMyAdmin, but here is what it uses:

    INSERT INTO `mail`.`users` (`email`, `password`, `quota`) VALUES ('[email protected]', ENCRYPT('1234567'), '5368709120');

    I did increase it in phpMyAdmin to 5GB and it write 2GB in the maildirsize file.

    Toolz
     
  6. falko

    falko Super Moderator Howtoforge Staff

    What's the output of
    Code:
    uname -a
    ?
     
  7. toolz

    toolz New Member

    Linux localhost.localdomain 2.6.27.19-170.2.35.fc10.ppc #1 Mon Feb 23 12:48:02 EST 2009 ppc ppc ppc GNU/Linux
     
  8. falko

    falko Super Moderator Howtoforge Staff

    ppc is 32-bit, I guess? Maybe that's the problem. Maybe you can try on a 64-bit system? I'd be interested in the result as well. :)
     
  9. dedez

    dedez New Member

    Same trouble for me..the maximum quota per-user is limited to 2Gb!
    I try to put any kind of value in the DB table but the limit still there..
     
  10. falko

    falko Super Moderator Howtoforge Staff

    Are you on a 32- or 64-bit system?
     

Share This Page