How to change expiration date for all subscriptions to unlimited

Question

How to set expiration date for all subscriptions to unlimited in back end?

Answer

For Windows:

1. Connect to the server via RDP and retrieve domain names from the database

   C:\> cd %plesk_dir%
   cd MySQL/bin/
   mysql -uadmin -p -P8306 psa -Ne"select name from domains where webspace_id=0;" > С:\\webspaces_list.txt

2. Run the following command to set expiration date of all subscriptions to unlimited:

   C:\> for /f %i in (C:\\webspaces_list.txt) do "%plesk_cli%\\subscription_settings.exe" -u %i -expiration -1

For Linux:

Connect to the server via SSH and do the following:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa -e"select name from domains where webspace_id=0;" | grep -v "name" > /tmp/webspaces.list
# while read l; do /usr/local/psa/bin/subscription_settings -u $l -expiration -1; done < /tmp/webspaces.list