Article ID: 125499, created on May 13, 2015, last review on Sep 18, 2015

  • Applies to:
  • Plesk 11.5 for Linux
  • Plesk 11.5 for Windows


How to change Subscription Expiry Dates at once for all suspended domains.



# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Nse"select name from domains where status!=0 and webspace_id =0" | while read i; do /usr/local/psa/bin/domain_pref -u $i -expiration -1; /usr/local/psa/bin/subscription --webspace-on; done


  1. Retrieve the list of expire subscription names from database:

    "%plesk_bin%"\dbclient.exe --direct-sql --sql="select name from domains where status!=0 and webspace_id =0" | more +1 > c:\expire_subscription.txt
  2. Execute the below given utility to change the expiration dates for above listed subscription:

    cd %plesk_cli%
    for /f %i in (C:\expire_subscription.txt) do  domain_pref.exe -u %i -expiration -1   
  3. Activate the same listed subscriptions:

    cd %plesk_cli%
    for /f %i in (C:\expire_subscription.txt) do subscription.exe --webspace-on %i

    With the steps described above you will be able to enable all the expired subscriptions on server. Further you can follow steps below to enable and activate domains under these subscription.

    cd %plesk_bin%
    dbclient.exe --direct-sql --sql="select name from domains where status !=0 and  webspace_id !=0" | more +1 > c:\expire_domains.txt
    cd %plesk_cli%
    for /f %i in (c:\expire_domains.txt) do domain.exe --on %i

Search Words

subscription suspended

domain.exe --on

domain_pref.exe -u %i -expiration

Expiry date for subscription

Activate expired domains

subscription.exe --webspace-on

Change all Subscription Expiry Dates at Once

46a8e394d6fa13134808921036a34da8 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 bd7fc88cf1b01f097749ae6f87272128 29d1e90fd304f01e6420fbe60f66f838 01bc4c8cf5b7f01f815a7ada004154a2 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF