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

[metallikop]

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.

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]

 

[futec]

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

 

[Hultenius]

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.

 

[smtalk]

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

 

[JLChafardet]

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,

 

[DigitalCrowd]

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.

 

[WebDork]

Originally posted by smtalk
Just comment out "skip-innodb" in /etc/my.cnf ( #skip-innodb ) and then restart mysqld.

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

 

[MarcosBL]

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