Mysql won't start anymore

[nunor]

Hi,

Since this morning mysql is not working anymore. Plesk admin panel is also not working

ERROR: Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 0: /usr/local/psa/admin/auto_prepend/auth.php3:81 psaerror(string "Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)")

I checked in /var/log/mysqld.log

The error is

060130 11:08:57 mysqld started
060130 11:08:57 Can't start server: Bind on TCP/IP port: Address already in use
060130 11:08:57 Do you already have another mysqld server running on port: 3306 ?
060130 11:08:57 Aborting

060130 11:08:57 /usr/libexec/mysqld: Shutdown Complete

060130 11:08:57 mysqld ended

I havn't made any changes since yesterday?

I'm running Plesk 7.5.5 on Fedora Core 2

Can please someone help?

Many thanks

 

[DeanW]

Try from the prompt

service mysqld restart

Additionally, I have problems restarting MySQL with the command above every time on a default Plesk server... It seems to be due to MySQL stopping slowly and then starting too soon. I added a line "sleep 4;" to the stop() function in /etc/rc.d/init.d/mysqld to fix it server-wide.

stop(){
        /bin/kill `cat /var/run/mysqld/mysqld.pid  2> /dev/null ` > /dev/null 2>&1
        ret=$?
        if [ $ret -eq 0 ]; then
            action $"Stopping $prog: " /bin/true
        else
            action $"Stopping $prog: " /bin/false
        fi
        [ $ret -eq 0 ] && rm -f /var/lock/subsys/mysqld
        [ $ret -eq 0 ] && rm -f $datadir/mysql.sock
        sleep 4;
        return $ret
}

 

[nunor]

After a complete reboot Mysql is working again but it seems to 100%

I cannot access Plesk Admin Interface anymore

The web interface shows me:

ERROR: Unable to query: Can't open file: 'misc.InnoDB'. (errno: 1) 0: /usr/local/psa/admin/plib/common_func.php3:203 psaerror(string "Unable to query: Can't open file: 'misc.InnoDB'. (errno: 1)") 1: /usr/local/psa/admin/plib/common_func.php3:390 db_query(string "select param, val from misc") 2: /usr/local/psa/admin/plib/class.Session.php:113 get_param(string "login_timeout") 3: /usr/local/psa/admin/auto_prepend/auth.php3:139 Session->Session()

I tried to stop & restart Plesk from the console but I get this error:

Starting named: [ OK ]
Starting MySQL: [ OK ]
Starting qmail: [ OK ]
Starting Courier-IMAP server:
Starting imapd [ OK ]
Starting imap-ssl [ OK ]
Starting pop3 [ OK ]
Starting pop3-ssl [ OK ]

Starting postgresql service: [ OK ]
Unable to fetch SpamAssassin config from database: Can't open file: 'sa_conf.InnoDB'. (errno: 1)
Starting psa-spamassassin service: [FAILED]
ERROR 1016 at line 1: Can't open file: 'DomainServices.InnoDB'. (errno: 1)
ERROR 1016 at line 1: Can't open file: 'sessions.InnoDB'. (errno: 1)
Mysql error: Can't open file: 'key_history.InnoDB'. (errno: 1)
Processing config directory: /usr/local/psa/admin/conf/httpsd.*.include
/usr/local/psa/admin/bin/httpsdctl start: httpd started
Starting Plesk: [ OK ]
Starting up DrWeb(R) daemon: 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: http://support.drweb.com
To purchase: http://buy.drweb.com

Engine version: 4.32b
Loading /var/drweb/bases/drwtoday.vdb - Ok, virus records: 584
Loading /var/drweb/bases/drw43259.vdb - Ok, virus records: 806
Loading /var/drweb/bases/drw43258.vdb - Ok, virus records: 745
Loading /var/drweb/bases/drw43257.vdb - Ok, virus records: 720
Loading /var/drweb/bases/drw43256.vdb - Ok, virus records: 529
Loading /var/drweb/bases/drw43255.vdb - Ok, virus records: 901
Loading /var/drweb/bases/drw43254.vdb - Ok, virus records: 890
Loading /var/drweb/bases/drw43253.vdb - Ok, virus records: 863
Loading /var/drweb/bases/drw43252.vdb - Ok, virus records: 616
Loading /var/drweb/bases/drw43251.vdb - Ok, virus records: 714
Loading /var/drweb/bases/drw43250.vdb - Ok, virus records: 858
Loading /var/drweb/bases/drw43249.vdb - Ok, virus records: 763
Loading /var/drweb/bases/drw43248.vdb - Ok, virus records: 628
Loading /var/drweb/bases/drw43247.vdb - Ok, virus records: 652
Loading /var/drweb/bases/drw43246.vdb - Ok, virus records: 749
Loading /var/drweb/bases/drw43245.vdb - Ok, virus records: 591
Loading /var/drweb/bases/drw43244.vdb - Ok, virus records: 833
Loading /var/drweb/bases/drw43243.vdb - Ok, virus records: 630
Loading /var/drweb/bases/drw43242.vdb - Ok, virus records: 793
Loading /var/drweb/bases/drw43241.vdb - Ok, virus records: 780
Loading /var/drweb/bases/drw43240.vdb - Ok, virus records: 435
Loading /var/drweb/bases/drw43239.vdb - Ok, virus records: 775
Loading /var/drweb/bases/drw43238.vdb - Ok, virus records: 1011
Loading /var/drweb/bases/drw43237.vdb - Ok, virus records: 656
Loading /var/drweb/bases/drw43236.vdb - Ok, virus records: 850
Loading /var/drweb/bases/drw43235.vdb - Ok, virus records: 1001
Loading /var/drweb/bases/drw43234.vdb - Ok, virus records: 554
Loading /var/drweb/bases/drw43233.vdb - Ok, virus records: 632
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: 88971
Key file not found!
Plesk authorization failed: malformed response (no 'response=' field).
Error: Plesk Software not running.
[FAILED]

I don't really know if my license has DrWeb included or not (Pleask was inclued in the webhosting offer)

I couldn't find any solutions for this problem on this forums. Can please someone help?

Thanks
Nuno

 

[DeanW]

This is a tough one and I have very little experience with this particular problem. Check this out:
http://dev.mysql.com/doc/refman/4.1/en/innodb-troubleshooting-datadict.html

Try google for "innodb data dictionary repair"

Regards