1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Error after Updating Plesk Control Panel 9.5

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by dschiffner, Feb 13, 2011.

  1. dschiffner

    dschiffner Guest

    0
     
    After Updating Plesk Control Panel 9.5 when i try to log into Plesk i get following Errors

    ERROR: PleskMainDBException

    MySQL query failed: Table 'psa.lockout' doesn't exist

    0: common_func.php3:206
    db_query(string 'delete from lockout where (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(last_wrong)) > (30 * 60)')
    1: cmd_loginup.php:82
    createSession(string 'admin', string '********')
    2: login_up.php3:22

    Whats wrong ?
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    It looks like upgrade was nor successfully completed and database was not correctly upgraded. Recovering broken upgrade is complex and not trivial task. I suggest you contact support team if you can't fix it by yourself.
     
  3. mariusd

    mariusd Guest

    0
     
    Had the same problem, solved

    Hi,

    I had the same error message, I could solve it by connecting to the psa database and then create the table:

    mysql> CREATE TABLE `lockout` (
    -> `login` varchar(20) character set utf8 NOT NULL default '',
    -> `last_wrong` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    -> `attempts` int(11) NOT NULL default '1',
    -> PRIMARY KEY (`login`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    -> ;

    Maybe that helps you as well.

    Best
    Marius
     
  4. Mangoswiss

    Mangoswiss Guest

    0
     
    I had a similar error after trying to update from Plesk 9 to 10

    This worked for me but I make no promises...

    You can check the state of your database like this...
    $> mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow ` psa

    You should have a directory full of psa database backups

    cd /var/lib/psa/dumps/

    In there they'll be something like...

    mysql.preupgrade.9.2.2-10.10.1.20110311-005228.dump.gz

    Gunzip it somewhere you can remember

    $> gunzip mysql.preupgrade.9.2.2-10.10.1.20110311-005228.dump.gz

    then take the unzipped file and restore your database like so...

    $> mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa < mysql.preupgrade.9.2.2-10.10.1.20110311-005223.dump


    Check the database again and you should get a load of OKs
    $> mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow ` psa

    then go back to Plesk and all should be good!
     
  5. spid3r1987

    spid3r1987 Guest

    0
     
    genius!!

    worked thanks, saved my bacon!!
     
  6. SalvadorS

    SalvadorS Regular Pleskian

    29
    90%
    Joined:
    Nov 12, 2009
    Messages:
    282
    Likes Received:
    2
    Dear Mangoswiss, you solve my life. Thanks a lot


     
    Last edited: Jul 9, 2012
Loading...