Article ID: 117408, created on Sep 20, 2013, last review on Jun 19, 2016

  • Applies to:
  • Operations Automation 5.5
  • 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:

    MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin psa > ~/psa.`date +%F_%H:%M`.sql  
    MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin 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_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin
  4. Check that the Presense Buidler user exists in the mysql database:

    #MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin 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_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin 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_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin 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_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin 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

Search Words

Unknown table engine 'InnoDB'

ERROR while trying to upgrade APSC SQL database from 11.1.0


failed to establish test connection

ERROR while trying to upgrade MySQL password


ERROR while trying to upgrade MySQL password format for Sitebuilder user

Can't find any matching row in the user table

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f aea4cd7bfd353ad7a1341a257ad4724a 5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 614fd0b754f34d5efe9627f2057b8642 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e

Email subscription for changes to this article
Save as PDF