Article ID: 127867, created on Dec 25, 2015, last review on Dec 25, 2015

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


A Plesk Panel upgrade fails with the error below:

ERROR: Zend_Db_Statement_Exception
SQLSTATE[HY000]: General error: 1017 Can't find file: './psa/smb_apsPackages.frm' (errno: 13)"

I start the bootstrapper script to repair Plesk Panel and continue the upgrade process, but it fails too:

/usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/ repair
ERROR while trying to upgrade MySQL password format for Sitebuilder user


The Presense Builder database user was not created during the Plesk upgrade.


  1. Back up the current Plesk Panel databases:

    mysqldump -u admin -p`cat /etc/psa/.psa.shadow` psa > ~/psa.`date +%F_%H:%M`.sql  
    mysqldump -u admin -p`cat /etc/psa/.psa.shadow` apsc > ~/apsc.`date +%F_%H:%M`.sql
  2. Find the first preupgrade dump in the /var/lib/psa/dumps/ directory that has the following format:



    a) 9.5.4 - Plesk version before upgrade

    b) 11.0.9 - Plesk version you are upgrading to

    c) 20130726 - Date when upgrade started

    d) 102859 - Time when upgrade started

  3. Restore it:

    zcat /var/lib/psa/dumps/mysql.preupgrade.9.5.4- |  mysql -uadmin -p`cat /etc/psa/.psa.shadow` 
  4. Check that the Presense Buidler user exists in the mysql database:

    #mysql -u admin -p`cat /etc/psa/.psa.shadow` mysql -sNe "select User from user where user='pp_sb_db'"
  5. If the user is absent, then create it:

    a) For MySQL server version 5.1:

    #mysql -u admin -p`cat /etc/psa/.psa.shadow` mysql -sNe "insert into mysql.user values ('localhost','pp_sb_db','*3B063F312BAD7DB54911C318959EB12FF43925DB','N','N','N','N','N','N','N', 'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N', 'N','','','','',0,0,0,0);"

    b) For MySQL server version 5.5:

    #mysql -u admin -p`cat /etc/psa/.psa.shadow` mysql -sNe "insert into mysql.user values ('localhost','pp_sb_db','*5D648C6BA7EC62DCBE81954B0FA0F9E18FFFF856','N','N','N','N','N','N','N', 'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N', 'N','','','','',0,0,0,0,'',NULL);"
  6. Set a valid password for the pp_sb_db user from the /usr/local/sb/config file:

    a) Get the password:

    # grep password /usr/local/sb/config
    password = qwet1235

    b) Update the database user with the password from the previous step:

    #mysql -u admin -p`cat /etc/psa/.psa.shadow` mysql -sNe "update mysql.user set password=password('qwet1235') where user='pp_sb_db';"
  7. Launch bootstraper again to perform a database upgrade:

    /usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/ repair

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 29d1e90fd304f01e6420fbe60f66f838 01bc4c8cf5b7f01f815a7ada004154a2 0a53c5a9ca65a74d37ef5c5eaeb55d7f aea4cd7bfd353ad7a1341a257ad4724a

Email subscription for changes to this article
Save as PDF