How to change IP address for multiple subscriptions using CLI?

Question

How to change IP addresses for multiple subscriptions using CLI?

Answer

1. Create the list of all subscriptions on a server:

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne"select name from domains where id in (select object_id from Subscriptions)" | awk -F'|' '{print $1}' > list.txt

2. If IP addresses change is required for only particular subscriptions, not for all subscriptions on a server, manually remove unwanted subscriptions from the list.txt  file.

3. Use the subscription utility to change the IP's for all subscriptions in the list file:

   # while read i; do /usr/local/psa/bin/subscription -u $i -ip 203.0.113.2; done < list.txt

If it is required to change IPv4 and IPv6 addresses for all subscriptions, it could be done using the following command:

# while read i; do /usr/local/psa/bin/subscription -u $i -ip 203.0.113.2,2001:db8:f61:a1ff:0:0:0:80; done < list

However, the feature of configuring IPv4 and IPv6 addresses separately via CLI is not implemented it Plesk yet. Take part in our product improvement by referring to the following link: 

https://plesk.uservoice.com/forums/184549-feature-suggestions

The top-ranked suggestions are likely to be included in the next versions of Plesk.

In case if it is needed to change IP address for all subscriptions to 203.0.113.2, which currently have IP addresses are equal to 203.0.113.3, follow the next action plan:

1. Make sure that IP addresses 203.0.113.2 and 203.0.113.3 are presented in the IP Addresses list in Plesk > Tools & Settings > IP Addresses.

2. Create the list of all subscriptions on a server, which IP-addresses are equal to 203.0.113.3:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -N -e "select name from domains as d left join DomainServices as DS on d.id=DS.dom_id left join IpCollections as IPC on DS.ipCollectionId=IPC.id left join IpAddressesCollections as IPAC on IPAC.ipCollectionId=IPC.id left join IP_Addresses as IPA on IPA.id=IPAC.ipAddressId where d.id in (select object_id from Subscriptions) and DS.type='web' and IPA.ip_address='203.0.113.3';" | awk -F'|' '{print $1}' > list

3. Use the subscription utility to change the IP's for all subscriptions in the list file to 203.0.113.2:

# while read i; do /usr/local/psa/bin/subscription -u $i -ip 203.0.113.2; done < list

In case there are resellers, then during assigning an IP address, such resellers will be locked and not be able to synchronize with their Service Plans. In order to avoid this add IP address to resellers service plan first. As an example for the "Default Reseller" Service Plan the command adding 203.0.113.3 address in the pool will be the following:

# plesk bin reseller_plan --update 'Default Reseller' -ip_pool add:203.0.113.3