Admin edition problem after migration

[Poochie]

Dear support,

I recently moved a subscription from one of our servers (with Plesk full version) to a new client server with the Admin edition of Plesk. The site works correctly, but even if there is no subscription management, it inherited the limitations (bandwidth per month and disk space, and it's now emailing each day to remember that) of the previous setup. Is there a command-line shortcut to clear all limitations for this domain?

Thanks

 

[Wizzie]

maybe if you make an "unlimited" plan and add it to that subscription it will end those pesky notifications.

 

[Poochie]

maybe if you make an "unlimited" plan and add it to that subscription it will end those pesky notifications.

Being there no "Subscriptions management" page, it's not doable, maybe only via command line:

http://cl.ly/image/2m2Z1K1d0r26
http://cl.ly/image/2g110O2I2E0y

 

[Wizzie]

i use web pro version so bare with me a little and maybe we can find a way!

on the same line where you find add new domain, add new subdomain, etc... at the end there is a wrench icon, what are the options there?

 

[Poochie]

i use web pro version so bare with me a little and maybe we can find a way!
on the same line where you find add new domain, add new subdomain, etc... at the end there is a wrench icon, what are the options there?

There is but I have no options (just active list or classic list). I'm quite sure that the command line could be the only way out (or transfer the account back to my full plesk, edit the restrictions and clone it back again).

 

[Wizzie]

Do you still have accesss to the old server? Maybe you can change there to unlimited plan and then make the backup and transfer it to the new one.
Or maybe i can do that for you, import your backup, change it to unlimited plan and then recreate the backup with the new settings.

I am curios too if there is a command line that will do that quicker but it seems that nobody knows yet.

 

[Poochie]

Do you still have accesss to the old server? Maybe you can change there to unlimited plan and then make the backup and transfer it to the new one.
Or maybe i can do that for you, import your backup, change it to unlimited plan and then recreate the backup with the new settings.
I am curios too if there is a command line that will do that quicker but it seems that nobody knows yet.

Not finding official support I will have to migrate the account back to the old server, edit it, and transfer it again I suppose.

 

[IgorG]

You can get official free migration assistance here - http://odin.com/products/plesk/free-migration-support/

 

[Poochie]

You can get official free migration assistance here - http://odin.com/products/plesk/free-migration-support/

Resolved, here is how it happened:

I have successfully set the value of 'Disk space' and 'traffic' field to unlimited for domain project.domain.com, under Plesk >> statistics. Please refer the attached screenshot.

In order to set it, I took below steps:

-=-=
Before doing any changes I took backup of PSA database:

-=
[root@server ~]# mysqldump -uadmin -p`cat /etc/psa/.psa.shad
-=

1. Logged in to plesk database:

[root@server ~]# plesk db

2. Checked domains table in order to find that domains 'project.domain.com':

mysql> select * from domains where name like '%project%'\G;
*************************** 1. row ***************************
id: 1
cr_date: 2014-08-19
name: server.domain.com
displayName: server.domain.com
dns_zone_id: 1
status: 0
htype: vrt_hst
real_size: 541623
cl_id: 1
cert_rep_id: 0
limits_id: NULL
params_id: NULL
guid: 6a1f3605-c874-4f54-a23c-84f31828b7a3
external_id:
adminDescription:
resellerDescription:
description:
overuse: false
gl_filter: on
vendor_id: 1
webspace_id: 0
webspace_status: 0
parentDomainId: 0
permissions_id: 0
*************************** 2. row ***************************
id: 2
cr_date: 2014-04-29
name: project.domain.com
displayName: project.domain.com
dns_zone_id: 2
status: 0
htype: vrt_hst
real_size: 5539550985
cl_id: 1
cert_rep_id: 0
limits_id: NULL
params_id: NULL
guid: 02623dab-cb68-4059-bc31-b3da01d5410a
external_id:
adminDescription:
resellerDescription:
description:
overuse: false
gl_filter: on
vendor_id: 1
webspace_id: 0
webspace_status: 0
parentDomainId: 0
permissions_id: 0
2 rows in set (0.00 sec)

ERROR:
No query specified

3. Checked subscription table:

mysql> select * from Subscriptions;
+----+-----------+-------------+--------+--------------+--------+--------------------------------------+-------------+
| id | object_id | object_type | locked | synchronized | custom | uuid | external_id |
+----+-----------+-------------+--------+--------------+--------+--------------------------------------+-------------+
| 1 | 1 | domain | false | true | false | 14589f07-eb83-93f6-b4b8-3a532969f363 | |
| 2 | 2 | domain | false | true | true | 9e94ba8c-c3b1-f8ca-f77c-aecbe4871720 | |
+----+-----------+-------------+--------+--------------+--------+--------------------------------------+-------------+
2 rows in set (0.00 sec)


4. Checked SubscriptionProperties table with id 2:

mysql> select * from SubscriptionProperties where subscription_id=2;
+-----------------+--------------------------------------+-----------+
| subscription_id | name | value |
+-----------------+--------------------------------------+-----------+
| 2 | aps_bundle_filter_id | 1 |
| 2 | default_server_mysql | 1 |
| 2 | default_server_postgresql | none |
| 2 | informer_files | false |
| 2 | limitsId | 2 |
| 2 | outgoing_messages_domain_limit | default |
| 2 | outgoing_messages_enable_sendmail | default |
| 2 | outgoing_messages_mbox_limit | default |
| 2 | outgoing_messages_overlimit_percent | 0 |
| 2 | outgoing_messages_subscription_limit | default |
| 2 | OveruseBlock | true |
| 2 | OveruseNotify | false |
| 2 | OveruseSuspend | false |
| 2 | permissionsId | 3 |
| 2 | phpSettingsId | 1 |
| 2 | unpaid_website_status | suspended |
+-----------------+--------------------------------------+-----------+
16 rows in set (0.00 sec)

5. Checked the current value for subscription in Limits table (limitId = 2):

mysql> select * from Limits where id=2;
+----+------------------------+-------------+
| id | limit_name | value |
+----+------------------------+-------------+
| 2 | disk_space | 10737418240 |
| 2 | disk_space_soft | 5368709120 |
| 2 | expiration | -1 |
| 2 | expiration_soft | NULL |
| 2 | max_box | 1 |
| 2 | max_db | 2 |
| 2 | max_dom_aliases | -1 |
| 2 | max_maillists | 0 |
| 2 | max_mn | -1 |
| 2 | max_site | 1 |
| 2 | max_site_builder | 0 |
| 2 | max_subdom | -1 |
| 2 | max_subftp_users | -1 |
| 2 | max_traffic | 32212254720 |
| 2 | max_traffic_soft | 10737418240 |
| 2 | max_unity_mobile_sites | 0 |
| 2 | max_webapps | 0 |
| 2 | max_wu | -1 |
| 2 | mbox_quota | 1073741824 |
+----+------------------------+-------------+
19 rows in set (0.00 sec)

6. updated the value of the parameters 'max_traffic' and 'disk_space' to unlimited:

mysql> update Limits set value='-1' where limit_name='disk_space' and id='2';
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> update Limits set value='-1' where limit_name='max_traffic' and id='2';
Query OK, 1 row affected (0.13 sec)
Rows matched: 1 Changed: 1 Warnings: 0

7. Checked Limits table value again :

mysql> select * from Limits where id=2;
+----+------------------------+-------------+
| id | limit_name | value |
+----+------------------------+-------------+
| 2 | disk_space | -1 |
| 2 | disk_space_soft | 5368709120 |
| 2 | expiration | -1 |
| 2 | expiration_soft | NULL |
| 2 | max_box | 1 |
| 2 | max_db | 2 |
| 2 | max_dom_aliases | -1 |
| 2 | max_maillists | 0 |
| 2 | max_mn | -1 |
| 2 | max_site | 1 |
| 2 | max_site_builder | 0 |
| 2 | max_subdom | -1 |
| 2 | max_subftp_users | -1 |
| 2 | max_traffic | -1 |
| 2 | max_traffic_soft | 10737418240 |
| 2 | max_unity_mobile_sites | 0 |
| 2 | max_webapps | 0 |
| 2 | max_wu | -1 |
| 2 | mbox_quota | 1073741824 |
+----+------------------------+-------------+
19 rows in set (0.00 sec)

-=-=