Articles in this section

See more

 How to synchronize locked subscriptions with their service plans

Avatar
Kuzma Ivanov
Updated
Follow
Plesk for Windows Plesk for Linux kb: how-to FR:PPM-2893

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Question

A subscription is flagged with a blue lock saying:

PLESK_INFO: The subscription is locked for synchronization: It is excluded from syncing with the service plan because the subscription parameters were customized.

How to synchronize locked subscriptions with their service plans?

Answer

 

Synchronizing a subscription with its service plan via Plesk

 

  1. Go to Subscriptions > example.com.

  2. Click Unlock & Sync in the Account section on the right.

    Click on the picture to enlarge
    Domain Dashboard

 

Synchronizing all subscriptions via a command-line interface

 

  • In Plesk for Linux

    1. Connect to a Plesk server via SSH.

    2. Create a list with all locked subscriptions:

      # plesk db -sNe "select name from domains d INNER JOIN Subscriptions s ON d.id=s.object_id where d.webspace_id=0 AND s.object_type='domain' AND s.locked='true'" > /root/locked_subscriptions.txt

    3. Unlock subscriptions from the generated list:

      # for domain in `cat /root/locked_subscriptions.txt`; do /usr/local/psa/bin/subscription --unlock-subscription $domain; done

    4. Synchronize these subscriptions with their service plans:

      # for domain in `cat /root/locked_subscriptions.txt`; do /usr/local/psa/bin/subscription --sync-subscription $domain; done

    5. (Optional) Check that no unsynced subscriptions left. The following command should return empty output:

      # plesk db -sNe "select name from domains d INNER JOIN Subscriptions s ON d.id=s.object_id where d.webspace_id=0 AND s.object_type='domain' AND s.synchronized='false'"

 

  • In Plesk for Windows Server

    1. Connect to the Plesk server via RDP.

    2. Start a command prompt as an Administrator.

    3. Create a list with all locked subscriptions:

      C:\> plesk db -sNe "select name from domains d INNER JOIN Subscriptions s ON d.id=s.object_id where d.webspace_id=0 AND s.object_type='domain' AND s.locked='true'" > locked_subscriptions.txt

    4. Unlock and synchronize subscriptions from the generated list:

      C:\> for /f %i in (locked_subscriptions.txt) do plesk bin subscription --unlock-subscription %i & for /f %i in (locked_subscriptions.txt) do plesk bin subscription --sync-subscription %i

    5. (Optional) Check that no unsynced subscriptions left. The following command should return empty output:

      C:\> plesk db -sNe "select name from domains d INNER JOIN Subscriptions s ON d.id=s.object_id where d.webspace_id=0 AND s.object_type='domain' AND s.synchronized='false'"

 

Additional Information

 

Comments

4 comments

Sort by Date Votes
  • Avatar
    Bryan Williams

    with not run with the "*" at the end and returns:

    'ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: NO)
    Wrong syntax for command's '-unlock-subscription' parameter
    [\cat]

    Wrong syntax for command's '-unlock-subscription' parameter
    [/etc/psa/.psa.shadow]'

    Without the "*" any thoughts?

    0
    Comment actions Permalink
  • Avatar
    Bulat Tsydenov

    @Bryan Thank you for bringing this to our attention! The article was modified correspondingly, now all commands are valid.

    0
    Comment actions Permalink
  • Avatar
    Paul R

    After running the commands for Linux, does the second command leave the server as it was? i noticed that when i ran the first command it said it was unlocking all the subscriptions (over 200) then when i ran the 2nd command it ran ok and synced all the subscriptions but i was expecting it to say they were locked.Put my mind at rest please.

    0
    Comment actions Permalink
  • Avatar
    Lev Iurev

    Hello Paul,

    Subscription is locked when you modify it's limits/settings directly in subscription. So there is a difference in limits/settings between subscription and service plan.

    First command unlocks subscription and makes them available for synchronization.

    The second command sync them with service plan  - sync limits/parameters between service plan and subscriptions.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles