Search Type:
Search for:

Language:

Product:
Category:
No categories for selected product

Method pem.getWebspacesList returns empty set for IIS-based subscription

Article ID: 5200 
Last Review: Oct,6 2008
Author:
Last updated by: system APPLIES TO:
  • Parallels Operations Automation 2.6

Cause

This issue is caused by bug #115132 which is going to be fixed in POA 2.7 hotfix01.
 

Resolution

The following command can be executed on POA Management Node to get the list of IIS webspaces for a given subscription:
# psql -U plesk -h`hostname` -x -c \
"SELECT ds.sub_id, ds.hd_id, ds.dom_name, wsb.ip FROM iis_domain_services ds
INNER JOIN iis_webvsrvs ws ON (ds.ds_id = ws.ds_id AND ws.is_basic = 1)
INNER JOIN iis_webvsrvs_bindings wsb ON (ws.srv_id = wsb.srv_id AND wsb.is_basic = 1)
WHERE ds.sub_id = <subscription_id>
AND ds.sync_status <> 2
AND ds.sps_status = 0";

For example:
[root@core root]# psql -U plesk -h`hostname` -x -c \
"SELECT ds.sub_id, ds.hd_id, ds.dom_name, wsb.ip FROM iis_domain_services ds
INNER JOIN iis_webvsrvs ws ON (ds.ds_id = ws.ds_id AND ws.is_basic = 1)
INNER JOIN iis_webvsrvs_bindings wsb ON (ws.srv_id = wsb.srv_id AND wsb.is_basic = 1)
WHERE ds.sub_id = 1034865
AND ds.sync_status <> 2
AND ds.sps_status = 0";
-[ RECORD 1 ]------------------------------
sub_id   | 1034865
hd_id    | 130279
dom_name | d1034865-2.example.com
ip       | 10.0.254.2
-[ RECORD 2 ]------------------------------
sub_id   | 1034865
hd_id    | 130278
dom_name | d1034865-1.example.com
ip       | 10.0.254.2
-[ RECORD 3 ]------------------------------
sub_id   | 1034865
hd_id    | 123937
dom_name | d1034865.example.com
ip       | 10.0.254.1


Subscription for changes to this article Subscription for changes to this article

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
* - required fields
 
 
 
 
 
 
For Home
For Business
For Hosters
For SaaS
For Developers
 
Desktop Virtualization
- Parallels Desktop for Mac
- Parallels Workstation
- Parallels Workstation Extreme
Server Virtualization
- Parallels Server
- Parallels Server for Mac
- Parallels Virtuozzo Containers
- Parallels Infrastructure Manager
Automation
- Parallels Operations Automation
- Parallels Business Automation
- Parallels Plesk Family
More Products