Change quota for users

Discussion in 'Installation/Configuration' started by chameleon, Feb 24, 2008.

  1. chameleon

    chameleon New Member

    I have just installed a mail server following this how-to:

    http://www.howtoforge.com/virtual_users_and_domains_with_postfix_debian_etch

    Great how-to.
    Everything works, but I noticed that when I create a user with quota 4GB and send him an e-mail, everything is ok except the quota.
    For some reason it was truked to 2GB (2147483647).
    In mysql database everything is ok.
    But the value in maildirsize in /home/vmail/domain.tld/user1/ is 2147483647S.
    I checked every step on how-to and there is no errors.

    Can you help me with this one?

    Thanks in advance.
     
    Last edited: Feb 24, 2008
  2. falko

    falko Super Moderator ISPConfig Developer

    What filesystem are you using? Any errors in your logs?
     
  3. chameleon

    chameleon New Member

    Debian Etch is the OS.
    No no errors in the log.
    Here is what I see in the mail.log:

    Feb 26 01:41:22 mail amavis[2897]: (02897-02) Passed CLEAN, <[email protected]> -> <[email protected]>, Message-ID: <[email protected]>, mail_id: Lv64gKr65WC2, Hits: 1.269, queued_as: 6E68A12AC184, 6661 ms
    Feb 26 01:41:22 mail postfix/smtp[3863]: CA31112AC1E3: to=<[email protected]>, relay=127.0.0.1[127.0.0.1]:10024, delay=6.7, delays=0.03/0/0/6.7, dsn=2.6.0, status=sent (250 2.6.0 Ok, id=02897-02, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 6E68A12AC184)
    Feb 26 01:41:22 mail postfix/qmgr[2958]: CA31112AC1E3: removed
    Feb 26 01:41:22 mail postfix/virtual[3868]: 6E68A12AC184: to=<[email protected]>, relay=virtual, delay=0.07, delays=0.05/0/0/0.01, dsn=2.0.0, status=sent (delivered to maildir)
    Feb 26 01:41:22 mail postfix/qmgr[2958]: 6E68A12AC184: removed

    I create user in mysql:
    INSERT INTO `users` (`email`, `password`, `quota`) VALUES ('[email protected]', ENCRYPT('test4'),5368709120);

    And whe I check the user maildirsize, I get this:

    cat /home/vmail/domain.com/test4/maildirsize
    2147483647S
    922 1

    I hope this will help
     
  4. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    mount
    and
    Code:
    df -h
    ?
     
  5. chameleon

    chameleon New Member

    Here is the output of mount command:

    /dev/sda1 on / type ext3 (rw,errors=remount-ro)
    tmpfs on /lib/init/rw type tmpfs (rw,nosuid,mode=0755)
    proc on /proc type proc (rw,noexec,nosuid,nodev)
    sysfs on /sys type sysfs (rw,noexec,nosuid,nodev)
    procbususb on /proc/bus/usb type usbfs (rw)
    udev on /dev type tmpfs (rw,mode=0755)
    tmpfs on /dev/shm type tmpfs (rw,nosuid,nodev)
    devpts on /dev/pts type devpts (rw,noexec,nosuid,gid=5,mode=620)

    Here is the output of df -h:
    Filesystem Size Used Avail Use% Mounted on
    /dev/sda1 227G 1.4G 214G 1% /
    tmpfs 1014M 0 1014M 0% /lib/init/rw
    udev 10M 40K 10M 1% /dev
    tmpfs 1014M 0 1014M 0% /dev/sh
     
  6. falko

    falko Super Moderator ISPConfig Developer

    Looks ok. What's the output of
    Code:
    uname -a
    ?
     
  7. chameleon

    chameleon New Member

    Linux mail 2.6.18-6-686 #1 SMP Sun Feb 10 22:11:31 UTC 2008 i686 GNU/Linux
     
  8. falko

    falko Super Moderator ISPConfig Developer

    Looks ok, too. On old Linux systems (kernel 2.4 and older) there was a max. file size of 2GB - I was thinking that maybe this is the problem here, but everything looks ok.

    Now that I think about it again, I think the problem is that the quota field in the users table is of type int(10):

    CREATE TABLE users (
    email varchar(80) NOT NULL,
    password varchar(20) NOT NULL,
    quota INT(10) DEFAULT '10485760',
    PRIMARY KEY (email)
    ) TYPE=MyISAM;


    Change it to bigint and try again.
     
  9. chameleon

    chameleon New Member

    Hello,

    I already did that. But without any luck. See the output:
    cat /home/vmail/domain.com/test/maildirsize
    2147483647S
    809 1

    I double check everything. And even rebuild postfix packe with quota patch like it was done in the how-to, but there is no effekt.
    I'm stuck.

    BR,
    Chameleon
     
  10. falko

    falko Super Moderator ISPConfig Developer

    What do you use for the quota field now? Can you post the table definition (using phpMyAdmin)?
     
  11. chameleon

    chameleon New Member

    CREATE TABLE `users` (
    `email` varchar(80) NOT NULL,
    `password` varchar(20) NOT NULL,
    `quota` bigint(10) default '4294967296',
    PRIMARY KEY (`email`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
     
  12. falko

    falko Super Moderator ISPConfig Developer

    Use bigint(20) instead.
     
  13. chameleon

    chameleon New Member

    Yep, I've just changed it.
    But no luck.
    I will try to patch the postfix again and will change this:

    +# A maximum limit of a mailbox
    +virtual_mailbox_limit = 100000000

    With bigger number and the number will start for example with 4 or 5.
    I hope this will help

    BR,
    chameleon
     
  14. chameleon

    chameleon New Member

    No effect...:(
     
  15. chameleon

    chameleon New Member

    Can someone help me with this one.
    I'm still trying to solve it, but no luck so far.

    Thanks
     
  16. falko

    falko Super Moderator ISPConfig Developer

    Unfortunately I have no idea... :(
     

Share This Page