• We value your experience with Plesk during 2025
    Plesk strives to perform even better in 2026. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2025.
    Please take this short survey:
    https://survey.webpros.com/

Mysql won't start anymore

N

nunor

Guest
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
 
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.

Code: 
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
}
 
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
 
You must log in or register to reply here.

Similar threads

UnS3eN
Issue httpd won't start
Replies
9
Views
1K
pleskpanel
P
D
Issue Cannot get MariaDB working at all after broken upgrade
Replies
5
Views
2K
Deleted member 163062
D
A
Question Plesk install in ubuntu
Replies
2
Views
2K
alexk345
A
Matt N
Issue Maria DB 10.11 > 11.4 upgrade results in issues with Plesk Repair Tool - reports innodb corruption in ibdata1
Replies
12
Views
2K
Misho
Misho
P
Resolved SELinux is preventing /opt/plesk/php/8.3/sbin/php-fpm from connectto access on the unix_stream_socket /var/lib/mysql/mysql.sock
Replies
5
Views
929
Sebahat.hadzhi
Sebahat.hadzhi
Back
Top