1. Please take a little time for this simple survey! Thank you for participating!
    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...