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

Can't find file: 'key_history.MYI' (errno: 2)

Discussion in 'Plesk for Linux - 8.x and Older' started by metallikop, Mar 24, 2005.

  1. metallikop

    metallikop Guest

    0
     
    After doing an upgrade recently I have the following error. Has anyone experienced this? I'm more worried about the Mysql error "Can't find file ...." not drweb.

    Code:
    cyndane root # /etc/init.d/psa start
    ===> Reading /etc/psa/psa.conf ...
    spamd already running on /tmp/spamd_full.sock, exiting
    Starting psa-spamassassin service:                         [FAILED]
    Mysql error: Can't find file: 'key_history.MYI' (errno: 2)
    Key register failed
    /usr/local/psa/admin/bin/httpsdctl: line 227:  7070 Terminated              $HTTPD
    /usr/local/psa/admin/bin/httpsdctl start: httpd could not be started
    Starting Plesk:                                            [FAILED]
    Starting up DrWeb(R) daemon: date
    Dr.Web (R) daemon for Linux/Plesk Edition, version 4.32.2 (2004-11-01)
    Copyright (c) Igor Daniloff, 1992-2004
    Doctor Web Ltd., Moscow, Russia
    Support service: [url]http://support.drweb.com[/url]
    To purchase: [url]http://buy.drweb.com[/url]
    
    Engine version: 4.32b
    Loading /var/drweb/bases/drwtoday.vdb - Ok, virus records: 515
    Loading /var/drweb/bases/drw43232.vdb - Ok, virus records: 516
    Loading /var/drweb/bases/drw43231.vdb - Ok, virus records: 466
    Loading /var/drweb/bases/drw43230.vdb - Ok, virus records: 901
    Loading /var/drweb/bases/drw43229.vdb - Ok, virus records: 632
    Loading /var/drweb/bases/drw43228.vdb - Ok, virus records: 584
    Loading /var/drweb/bases/drw43227.vdb - Ok, virus records: 568
    Loading /var/drweb/bases/drw43226.vdb - Ok, virus records: 533
    Loading /var/drweb/bases/drw43225.vdb - Ok, virus records: 476
    Loading /var/drweb/bases/drw43224.vdb - Ok, virus records: 484
    Loading /var/drweb/bases/drw43223.vdb - Ok, virus records: 442
    Loading /var/drweb/bases/drw43222.vdb - Ok, virus records: 371
    Loading /var/drweb/bases/drw43221.vdb - Ok, virus records: 372
    Loading /var/drweb/bases/drw43220.vdb - Ok, virus records: 560
    Loading /var/drweb/bases/drw43219.vdb - Ok, virus records: 412
    Loading /var/drweb/bases/drw43218.vdb - Ok, virus records: 511
    Loading /var/drweb/bases/drw43217.vdb - Ok, virus records: 512
    Loading /var/drweb/bases/drw43216.vdb - Ok, virus records: 507
    Loading /var/drweb/bases/drw43215.vdb - Ok, virus records: 539
    Loading /var/drweb/bases/drw43214.vdb - Ok, virus records: 275
    Loading /var/drweb/bases/drw43213.vdb - Ok, virus records: 404
    Loading /var/drweb/bases/drw43212.vdb - Ok, virus records: 428
    Loading /var/drweb/bases/drw43211.vdb - Ok, virus records: 494
    Loading /var/drweb/bases/drw43210.vdb - Ok, virus records: 450
    Loading /var/drweb/bases/drw43209.vdb - Ok, virus records: 639
    Loading /var/drweb/bases/drw43208.vdb - Ok, virus records: 603
    Loading /var/drweb/bases/drw43207.vdb - Ok, virus records: 620
    Loading /var/drweb/bases/drw43206.vdb - Ok, virus records: 683
    Loading /var/drweb/bases/drw43205.vdb - Ok, virus records: 525
    Loading /var/drweb/bases/drw43204.vdb - Ok, virus records: 607
    Loading /var/drweb/bases/drw43203.vdb - Ok, virus records: 409
    Loading /var/drweb/bases/drw43202.vdb - Ok, virus records: 543
    Loading /var/drweb/bases/drwebase.vdb - Ok, virus records: 51982
    Loading /var/drweb/bases/drw43201.vdb - Ok, virus records: 364
    Total virus records: 68927
    Key file not found!
    Plesk authorization failed: HTTP request error [7]
    Error: Plesk Software not running.
                                                               [FAILED]
     
  2. futec

    futec Guest

    0
     
    1: your using an illegal key
    2: your key is used on more than 1 server
    3: your upgraded or changed key without SpamAssasin support
     
  3. Hultenius

    Hultenius Guest

    0
     
    One of my customer got the same problem with some mysql tables some days ago (Can't find file: '***.MYI' (errno: 2)), after a mysql upgrade. The MYI and MYD files where gone so all he could do was to use a backup.
     
  4. smtalk

    smtalk Guest

    0
     
    Just comment out "skip-innodb" in /etc/my.cnf ( #skip-innodb ) and then restart mysqld.
     
  5. JLChafardet

    JLChafardet Regular Pleskian

    26
    57%
    Joined:
    Feb 20, 2004
    Messages:
    379
    Likes Received:
    0
    Location:
    Caracas - Venezuela
    yes, just do vim /etc/my.cnf and comment out the skip-innodb line by adding a # in front of it. save and exit :x! then service mysqld restart and service psa start (startall if all is stoped)

    regards,
     
  6. DigitalCrowd

    DigitalCrowd Basic Pleskian

    24
    23%
    Joined:
    Jul 5, 2002
    Messages:
    58
    Likes Received:
    0
    WOW. This saved me a MAJOR headache.

    Question: After I did this, my PSA came back which is good. But what did I loose by doing this?

    Before I tried to do a repair table misc USE_FRM but that didn't work, some result, MYI is missing.
     
  7. WebDork

    WebDork Guest

    0
     
    Thanks - fixed a big problem for me too I think.
     
  8. MarcosBL

    MarcosBL Guest

    0
     
    OMG.. just love you man... saved the day for one more
     
Loading...