HI,
While trying to activate the domain from Plesk panel, it fails and domain remains disabled. We will not be able to activate the domain from the command-line too (/usr/local/psa/bin/domain). We have to activate the domain directly from the "PSA" database
You will see that error while active/un-suspend domain form the command prompt:-
===============>>>
#:/usr/local/psa/admin/bin# /usr/local/psa/bin/domain --on example.net
An error occurred during turning domain on/off: The domain is suspended because the subscription is still suspended.
===============>>>
Now, there is only one way to fix this error, please follow this:-
Login in to the MySQL database,
===============>>>
# mysql -u admin -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 881
Server version: 5.0.51a-24+lenny5 (Debian)
mysql> use psa;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
mysql> select * from domains where name='example.net';
+----+------------+--------------------+--------------------+-------------+--------+---------+------------+-------+-------------+-----------+-----------+--------------------------------------+-------------+---------+-----------+-----------+-------------+-----------------+----------------+
| id | cr_date | name | displayName | dns_zone_id | status | htype | real_size | cl_id | cert_rep_id | limits_id | params_id | guid | external_id | overuse | gl_filter | vendor_id | webspace_id | webspace_status | permissions_id |
+----+------------+--------------------+--------------------+-------------+--------+---------+------------+-------+-------------+-----------+-----------+--------------------------------------+-------------+---------+-----------+-----------+-------------+-----------------+----------------+
| 1 | 2011-10-13 | example.net |example .net | 2 | 2 | vrt_hst | 1724352316 | 1 | 2 | 1 | 0 | 0e40ed2c-8beb-48f4-acd2-bcfcda6c1aaf | | true | on | 1 | 0 | 256 | 1 |
+----+------------+--------------------+--------------------+-------------+--------+---------+------------+-------+-------------+-----------+-----------+--------------------------------------+-------------+---------+-----------+-----------+-------------+-----------------+----------------+
1 row in set (0.00 sec)
===============>>>
You can see here "webspace_status=256", you need to change this value to "0",
===============>>>
mysql> select * from domains where name='example.net'\G;
*************************** 1. row ***************************
id: 1
cr_date: 2011-10-13
name: example.net
displayName: example.net
dns_zone_id: 2
status: 2
htype: vrt_hst
real_size: 1724352316
cl_id: 1
cert_rep_id: 2
limits_id: 1
params_id: 0
guid: 0e40ed2c-8beb-48f4-acd2-bcfcda6c1aaf
external_id:
overuse: true
gl_filter: on
vendor_id: 1
webspace_id: 0
webspace_status: 256
permissions_id: 1
1 row in set (0.00 sec)
===============>>>
mysql> UPDATE domains SET webspace_status='0' where id='1';
Query OK, 1 row affected (1.14 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>
===============>>>
Now, domain "example.net" should be active now.
Thank you,
