Admin-Ahead Community

Linux => Control Panels => Plesk => Topic started by: Jithin M on March 01, 2015, 06:37:19 am

Title: Unable to activate the subscription in Plesk (Windows server)
Post by: Jithin M on March 01, 2015, 06:37:19 am
While trying to activate a subscription which is in 'Suspended' state, the following error is observed in the Plesk control panel:
-------------------------------
Error: Some of the selected domains or aliases were not activated.
Error: Unable to activate the domain: The domain is suspended.
-------------------------------


This issue can be resolved by following the steps given below:

1) Create a psa database backup:
----------------------
"%plesk_dir%\MySQL\bin\mysqldump.exe" -uadmin -p<Plesk_password_here> -P8306 psa > c:\psadump.sql
----------------------


2) Check the subscription status:
----------------------
"%plesk_bin%\dbclient.exe" --direct-sql --sql="select status ,id ,name from domains where name='domain_name'"
----------------------

+--------+----+-----------------------------------------+
| status | id | name                                    |
+--------+----+-----------------------------------------+
|      4 |  1 | example.com                             |
+--------+----+-----------------------------------------+


3) Update the status:
----------------------
"%plesk_bin%\dbclient.exe" --direct-sql --sql="update domains set status = 0 where name='domain_name'"
----------------------


4) Suspend and then activate the subscription using the following utility:
----------------------
"%plesk_cli%\domain.exe" --webspace-off <subscription_name>

"%plesk_cli%\domain.exe" --webspace-on <subscription_name>
----------------------

This is a tried and tested method, and I had used it for resolving a similar issue in Plesk-Windows. It works  :)