[Howto] Per user quota edit within ispcp when using dovecot

[aseques]

Updated the script to work properly on ispcp 1.0.7

[djabit]

I have two problems :

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.

[aseques]

(06-28-2011 11:11 PM)djabit Wrote:  I have two problems :

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

[djabit]

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?

[aseques]

(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.

[fdriver]

(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

[aseques]

(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.

[Sweil]

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