Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 3rd September 2009, 19:24
Thomas Jensen Thomas Jensen is offline
Senior Member
 
Join Date: Apr 2009
Posts: 127
Thanks: 5
Thanked 1 Time in 1 Post
Default Quota = -1, but gets error: "maildir over quota"

One of my mailaccounts gets this error:

temporary failure. Command output: maildrop: maildir over
quota.

I've set the quota to "-1", but it doesn't seems to help

A sidestep:
I've often observed that when some limits (client limits) is set to -1, they are reset automatically to 0.
Reply With Quote
Sponsored Links
  #2  
Old 3rd September 2009, 20:25
Thomas Jensen Thomas Jensen is offline
Senior Member
 
Join Date: Apr 2009
Posts: 127
Thanks: 5
Thanked 1 Time in 1 Post
Default

I've discovered that all older domains are added with another sys_perm_group in mail_domain than the new one.

domain_id sys_userid sys_groupid sys_perm_user sys_perm_group sys_perm_other server_id domain active
1 1 3 riud ruid 1 old_domain.dk y
2 1 2 riud ru 1 newer_domain.dk y
so, ruid is now ru?

in the mail_user table, the quota field for the specific mailbox is -1048576.

Last edited by Thomas Jensen; 3rd September 2009 at 20:30.
Reply With Quote
  #3  
Old 3rd September 2009, 22:35
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
Default

Quote:
I've discovered that all older domains are added with another sys_perm_group in mail_domain than the new one.
The permissions depend on the fact which user has created the domains. If they are created by the admin, the group permissions are ru to prevent users from deleting domains that they had not created. But this is not realted to quota, as postfix and courier dont care about the ispconfig permission fields.

Quote:
in the mail_user table, the quota field for the specific mailbox is -1048576.
This explains your problem as -1048576 is no valid value for this field. Valid values are only positive values or -1.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 3rd September 2009, 22:51
Thomas Jensen Thomas Jensen is offline
Senior Member
 
Join Date: Apr 2009
Posts: 127
Thanks: 5
Thanked 1 Time in 1 Post
Default

Okay, then i'll change it in PHPmyadmin, but, all the rows have that problem, and that's even after i set Quota = -1 in the control panel.

Update:
I did: UPDATE `mail_user` SET `quota` = -1 WHERE `quota` < -1, which worked fine.
But now, in the CP, the quota is shown as -9.53674316406E-7.

Last edited by Thomas Jensen; 3rd September 2009 at 22:55.
Reply With Quote
  #5  
Old 3rd September 2009, 23:59
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
Default

I have no idea how this can happen most likely there is a problem with your mysql databse, e.g with the charsets or connection from mysql to php. as ispconfig is not converting numbers in any way, they were directly output from the DB. You should try to find out waht you changed in your configuration right before the problem started.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 4th September 2009, 00:03
Thomas Jensen Thomas Jensen is offline
Senior Member
 
Join Date: Apr 2009
Posts: 127
Thanks: 5
Thanked 1 Time in 1 Post
Default

I haven't changed anything i know of...

The charset of all tables is: utf8_general_ci

What can i do?
Reply With Quote
  #7  
Old 4th September 2009, 00:11
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
Default

I have no idea. I can not even think of a logical reason how this can happen.

The number -9.53674316406E-7 is equal to -1 kilobyte, but how shall this come together in this case??

What is the type of the column "quota" in the mail_user table?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 4th September 2009, 00:33
Thomas Jensen Thomas Jensen is offline
Senior Member
 
Join Date: Apr 2009
Posts: 127
Thanks: 5
Thanked 1 Time in 1 Post
Default

The type is: int(11), but it has no Collation.
Reply With Quote
  #9  
Old 4th September 2009, 09:49
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
Default

Thats OK. I was able to reproduce this now on one of my systems. I will make a patch for it.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #10  
Old 4th September 2009, 10:11
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,717
Thanks: 820
Thanked 5,322 Times in 4,175 Posts
 
Default

I think I've found the problem.

Please replace the file /usr/local/ispconfig/interface/web/mail/mail_user_edit.php with the file in the attached .zip file and check if this solves the problem.
Attached Files
File Type: zip mail_user_edit.zip (3.7 KB, 106 views)
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
Thomas Jensen (5th September 2009)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mailbox quota again and again jmroth Installation/Configuration 4 1st September 2008 09:53
chgrp error new user DKA General 15 28th July 2008 17:45
Not getting Quota Reports - Perfect Serv/Ubuntu 7.10 tonydm Server Operation 0 22nd March 2008 21:52
Problems with copy & paste dspuser Server Operation 3 23rd May 2006 17:21
Syntax error in Quota? st2xo Installation/Configuration 2 13th February 2006 11:30


All times are GMT +2. The time now is 08:03.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.