• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

mysql won't start after upgrade

T

Tormente

Guest
--- pasted from terminal:

hosting:/etc/mysql# /etc/init.d/psa start
Starting xinetd service... done
Starting bind9 service... done
Starting mysql service... failed
Starting qmail service... done
Starting courier-imap service... done
Starting postgresql service... not installed
Starting psa-spamassassin service... done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
websrvmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
System error 2: No such file or directory
websrvmng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
System error 2: No such file or directory
websrvmng: Unable to connect to the mysql database

System error 2: No such file or directory
websrvmng: Unable to connect to the mysql database

System error 2: No such file or directory
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Starting Plesk... done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
hosting:/etc/mysql#

----

there is nothing in /var/run/mysqld/

any ideas? server is comlpletly down. no web, no control panel, no mail.
 
saw this in the server logs as I was trying to start mysql.

==> /var/log/syslog <==
Aug 13 14:17:11 hosting /etc/init.d/mysql[21570]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 13 14:17:11 hosting /etc/init.d/mysql[21570]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 13 14:17:11 hosting /etc/init.d/mysql[21570]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 13 14:17:11 hosting /etc/init.d/mysql[21570]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 13 14:17:11 hosting /etc/init.d/mysql[21570]:
 
Solved!

Apparently psa-firewall and psa-security (?) where causing a dependency conflict, so I removed psa-firewall. everything seems to be ok now - other than the fact that I have no firewall module.
 
Back
Top