Current time: 11-22-2024, 02:13 PM Hello There, Guest! (LoginRegister)


Post Reply 
[Howto] Per user quota edit within ispcp when using dovecot
Author Message
aseques Offline
Member
*****
Dev Team

Posts: 330
Joined: May 2008
Reputation: 4
Post: #31
RE: [Howto] Per user quota edit within ispcp when using dovecot
Updated the script to work properly on ispcp 1.0.7
06-23-2011 12:02 AM
Find all posts by this user Quote this message in a reply
djabit Offline
Junior Member
*

Posts: 31
Joined: Jun 2011
Reputation: 0
Post: #32
RE: [Howto] Per user quota edit within ispcp when using dovecot
I have two problems Sad :

1)
The webinterface shows the quota which is set in the database but it did not accept any changes...

2)
I can change the quota in the database via phpmyadmin. But it seems to have no effect:
I get always a "mailbox for user is full" error...

Any ideas? Thank you.
06-28-2011 11:11 PM
Find all posts by this user Quote this message in a reply
aseques Offline
Member
*****
Dev Team

Posts: 330
Joined: May 2008
Reputation: 4
Post: #33
RE: [Howto] Per user quota edit within ispcp when using dovecot
(06-28-2011 11:11 PM)djabit Wrote:  I have two problems Sad :

1)
The webinterface shows the quota which is set in the database but it did not accept any changes...
Are you able to click on "quota" to edit the quota size? Is there any error message?
(06-28-2011 11:11 PM)djabit Wrote:  2)
I can change the quota in the database via phpmyadmin. But it seems to have no effect:
I get always a "mailbox for user is full" error...
You could try to set the quota to unlimited (0) and see if the message is different. If it seems that the values in the database (table dovecot_quota) are wrong you can just delete the registry entries and they will be recreated

Good luck
06-29-2011 12:32 AM
Find all posts by this user Quote this message in a reply
djabit Offline
Junior Member
*

Posts: 31
Joined: Jun 2011
Reputation: 0
Post: #34
RE: [Howto] Per user quota edit within ispcp when using dovecot
Thanks.
I got it working:
I changend this line in dovecot.conf from 1G to 10G:
Code:
quota_rule = *:bytes=10G

Now the maximum quota in webinterface is 2048MB... any way to increase it?
06-29-2011 06:05 PM
Find all posts by this user Quote this message in a reply
aseques Offline
Member
*****
Dev Team

Posts: 330
Joined: May 2008
Reputation: 4
Post: #35
RE: [Howto] Per user quota edit within ispcp when using dovecot
(06-29-2011 06:05 PM)djabit Wrote:  Thanks.
I got it working:
I changend this line in dovecot.conf from 1G to 10G:
Code:
quota_rule = *:bytes=10G

Now the maximum quota in webinterface is 2048MB... any way to increase it?
The value in dovecot.conf is only a default, that value that is overrriden by the database value
Code:
CONCAT('*:bytes=',quota,'B') AS quota_rule
Whenever you change the value for bytes in the table quota_dovecot it should be reflected in the ispcp panel.
06-30-2011 04:18 PM
Find all posts by this user Quote this message in a reply
fdriver Offline


Posts: 4
Joined: Mar 2011
Reputation: 0
Post: #36
RE: [Howto] Per user quota edit within ispcp when using dovecot
(06-29-2011 06:05 PM)djabit Wrote:  Thanks.
I got it working:
I changend this line in dovecot.conf from 1G to 10G:
Code:
quota_rule = *:bytes=10G

Now the maximum quota in webinterface is 2048MB... any way to increase it?

You must change type of field "quota" in database table mail_users, to bigint(10). After this change maximum quota is more bigger as 2048MB.

sorry for my bad english
07-12-2011 01:50 AM
Find all posts by this user Quote this message in a reply
aseques Offline
Member
*****
Dev Team

Posts: 330
Joined: May 2008
Reputation: 4
Post: #37
RE: [Howto] Per user quota edit within ispcp when using dovecot
(07-12-2011 01:50 AM)fdriver Wrote:  
(06-29-2011 06:05 PM)djabit Wrote:  Thanks.
I got it working:
I changend this line in dovecot.conf from 1G to 10G:
Code:
quota_rule = *:bytes=10G

Now the maximum quota in webinterface is 2048MB... any way to increase it?

You must change type of field "quota" in database table mail_users, to bigint(10). After this change maximum quota is more bigger as 2048MB.

sorry for my bad english
That's a problem, because making changes to the ispcp database can interfere in the normal functioning of ispcp after upgrades and that stuff.
Could you open a ticket asking for this change? Altough ispcp is not able to use mail quotas with courier, it'll be a future problem if it ever works.
Another option would be to use the MB as the minimum unit for the quota (so the limit would be 2000GB instead of 2GB), for dovecot it's no problem, even on the gui patch I made, we are doing the conversion from MB to Bytes.
07-18-2011 11:24 PM
Find all posts by this user Quote this message in a reply
Sweil Offline
Junior Member
*

Posts: 24
Joined: Mar 2009
Reputation: 2
Post: #38
RE: [Howto] Per user quota edit within ispcp when using dovecot
There are some bugs in the files from first post for ispcp 1.0.7. It is not possible to use quota with anything else than rugular domains. I fixed that and some other minor bugs in my version.
  • Fix: Quota for all domain types
  • Fix: Replaced Spanish(?) with correct English phrases, so other localizations will work
  • Fix: Adding an email-adress now takes quota in MB
  • Fix: There was a bug preventing to change quota for sub.aliasdomain accounts


Attached File(s)
.tar  quota_1_0_7_fixed.tar (Size: 85 KB / Downloads: 36)
(This post was last modified: 10-16-2011 05:07 AM by Sweil.)
10-16-2011 05:05 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)