Article ID: 119383, created on Dec 27, 2013, last review on May 10, 2014

  • Applies to:
  • Plesk Automation 11.5

Symptoms

Upgrade task 'Run the /usr/local/psa/bin/repair utility' failed with the following error:

    Unable to execute the command "/usr/local/psa/bin/repair". Error: webmaster (203): Operation in POA failed: [no error code] Account #255 has no role 'WebMaster'.
    Error: <EMAIL> (209): Operation in POA failed: [no error code] Account #261 has no role 'WebMaster'.
    Error occured while sending feedback. HTTP code returned: 502
    Unable to synchronize user roles in the Hosting Panel with those in the Administration Panel: an unexpected error has occurred.

Cause

Plesk and PPA database inconsistency .

Resolution

  1. Login in PPA database

    psql -h `hostname` -U plesk plesk
    
  2. Find the user login form the error message. In our case login is <EMAIL>.

  3. Using login name find member_id with the following query:

    select member_id from users inner join identities on users.auth_identity_id = identities.identity_id where identities.login = '<EMAIL>';    
    
  4. Login in Plesk database:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa
    
  5. Update clients table with the new member_id retrieved in step 3:

    update clients set external_id = $member_id where login = ‘<EMAIL>’;
    
  6. Update smb_users table with the new member_id retrieved in step 3:

    update clients set external_id = $member_id where login = ‘<EMAIL>’;
    

33a70544d00d562bbc5b17762c4ed2b3 e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF