How to change mailbox limit in the Power User view mode?

Question

How to change mailbox limit (mailbox size, mailbox quota) in the Power User view mode?

Answer

In Power User view mode service plan and subscriptions management is not available, it is available in Service Provider view only. Web Admin and Web App editions do not support Service Provider View, so in order to switch to Service Provider View, it is required to re-activate Plesk with Web Host or Web Pro edition licenses that support Service Provider View. When Web Host or Web Pro license is used, the subscription properties are ready to be adjusted. Web Host trial license can be retrieved here .

Note: the license changes can be reverted in Tools and Settings > License Management > Roll Back Key . This was your previously installed license will be uploaded.

Solution 1

Change mailbox size limits on a Service Plan level.

1. Go to Tools & Settings > License Management > Install Key ;

2. Use a trial key to set Plesk to Web Host Edition

3. If Service Provider view was not activated, click Change View in bottom right corner;

4. Go to Service Plans , select domain plan that was used for all domains and modify "Mailbox size" entry;

5. Click Update & Sync to automatically apply changes to all domains associated with the Service Plan;

6. Go to Tools & Settings > License Management > Roll Back Key and click Ok to revert to existing Web Admin license.

Solution 2

Modify subscription properties that has a custom Service Plan.

1. Login to the server over SSH

2. Backup psa database according to the instructions provided in the following article: How to backup/restore a Plesk database dump

3. Login to Plesk database

4. Execute the following query to find out mailbox limit value replacing the domain name:

   CONFIG_TEXT: select id, limit_name, value from Limits where id in (select value from SubscriptionProperties where subscription_id in (select id from Subscriptions where object_id in (select id from domains where name = "example.com"))and name='limitsId')and limit_name='mbox_quota';

5. Use the id to update the value:

   CONFIG_TEXT: update Limits set value='-1' where id=x and limit_name='mbox_quota';

   where -1 is equal to unlimited. Any value can be set in bytes.

   This setting will work as a template for all mailboxes created under that domain.

Solution 3

Manually change values in the database.

1. Login to the server over SSH

2. Backup psa database according to the instructions provided in the following article: How to backup/restore a Plesk database dump

3. Login into Plesk database

4. To set current mailbox limits for every existing domain (for example, 200MB):

   CONFIG_TEXT: update Limits set value=209715200 where limit_name='mbox_quota'; 

5. To modify all default limits for future domains:

   CONFIG_TEXT: update TmplData set value=209715200 where element='mbox_quota';

6. To set 200MB limit for all existing mailboxes on all existing domains:

   CONFIG_TEXT: update mail set mbox_quota=209715200;

Additional information

How to resend deferred mails