• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    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. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Issue Mysql Broken after update

I

iceman333

Basic Pleskian
Plesk 17.5 Ubuntu 16.04

After MicroUpdate is broken today after the connection to Mysql.


ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Abstract.php:144)

Search for related Knowledge Base articles

ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$E0...', Array) #1 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('select param, v...', Array) #4 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query('select param, v...', Array) #5 /opt/psa/admin/plib/db.php(36): Db_Adapter_Pdo_Mysql->query('select param, v...') #6 /opt/psa/admin/plib/db.php(212): db_query('select param, v...', false) #7 /opt/psa/admin/plib/Plesk/Mode.php(433): get_param('disable_provisi...') #8 /opt/psa/admin (Abstract.php:144)

Search for related Knowledge Base articles


I can also not plesk repair.

What can I do that the server is running.

Wolfgang
 
First of all try to fix it with

# plesk repair installation
 
it is no runnig
This is mistake


plesk repair installation
[2017-05-30 11:26:37] ERR [panel] SQLSTATE[HY000] [2002] No such file or directory:
0: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:144
Zend_Db_Adapter_Pdo_Abstract->_connect()
1: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php:111
Zend_Db_Adapter_Pdo_Mysql->_connect()
2: /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php:460
Zend_Db_Adapter_Abstract->query(string 'select param, val from misc', array)
3: /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'select param, val from misc', array)
4: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:30
Db_Adapter_Pdo_Mysql->query(string 'select param, val from misc')
5: /opt/psa/admin/plib/db.php:36
db_query(string 'select param, val from misc', boolean false)
6: /opt/psa/admin/plib/db.php:212
get_param(string 'disable_provisioning')
7: /opt/psa/admin/plib/Plesk/Mode.php:433
Plesk_Mode::isProvisioningDisabled()
8: /opt/psa/admin/plib/common_func.php:95
util_exec(string 'send-error-report', array, array, string 'proc_open', NULL null)
9: /opt/psa/admin/plib/common_func.php:28
smart_exec(string 'send-error-report', array, array, string 'proc_open')
10: /opt/psa/admin/plib/Os.php:116
Os::exec(string 'send-error-report', array, string 'proc_open')
11: /opt/psa/admin/plib/CommonPanel/Exception.php:329
CommonPanel_Exception::_sendRuntimeReportXML(string 'Zend_Db_Adapter_Exception', string 'SQLSTATE[HY000] [2002] No such file or directory', string '/opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php', integer '144', integer '2002', string '#0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(string 'SET sql_mode = ''', array)
#3 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query(string 'SET sql_mode = ''', array)
#4 /opt/psa/admin/plib/CommonPanel/Application/Abstract.php(90): Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
#5 /opt/psa/admin/plib/api-common/AbstractCu.php(1647): CommonPanel_Application_Abstract::initDbAdapter()
#6 /opt/psa/admin/plib/api-cli/CliUtilityRunner.php(21): AbstractCu::initDb()
#7 /opt/psa/admin/plib/api-cli/CliUtilityRunner.php(35): CliUtilityRunner->run()
#8 /opt/psa/admin/plib/api-cli/repair.php(4): require_once(string '/opt/psa/admin/plib/api-cli/CliUtilityRunner.php')
--
#0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct(string 'mysql:dbname=psa;host=localhost;port=3306;charset=utf8', string 'admin', string '******', array)
#1 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#2 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect()
#3 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(string 'SET sql_mode = ''', array)
#4 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query(string 'SET sql_mode = ''', array)
#5 /opt/psa/admin/plib/CommonPanel/Application/Abstract.php(90): Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
#6 /opt/psa/admin/plib/api-common/AbstractCu.php(1647): CommonPanel_Application_Abstract::initDbAdapter()
#7 /opt/psa/admin/plib/api-cli/CliUtilityRunner.php(21): AbstractCu::initDb()
#8 /opt/psa/admin/plib/api-cli/CliUtilityRunner.php(35): CliUtilityRunner->run()
#9 /opt/psa/admin/plib/api-cli/repair.php(4): require_once(string '/opt/psa/admin/plib/api-cli/CliUtilityRunner.php')', integer '1', string '1f2f1b88afaae781b9e915d9ad540137', string '2eb8d2699e722503bf79ae1c7819dc4e')
12: /opt/psa/admin/plib/CommonPanel/Exception.php:170
CommonPanel_Exception::sendNotification(object of type Zend_Db_Adapter_Exception)
13: /opt/psa/admin/plib/api-common/AbstractCu.php:2432
AbstractCu::reportError(object of type Zend_Db_Adapter_Exception)
14: /opt/psa/admin/plib/api-cli/CliUtilityRunner.php:27
CliUtilityRunner->run()
15: /opt/psa/admin/plib/api-cli/CliUtilityRunner.php:35
require_once(string '/opt/psa/admin/plib/api-cli/CliUtilityRunner.php')
16: /opt/psa/admin/plib/api-cli/repair.php:4
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)
exit status 1
 
Try

# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components
 
done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
===> Tue May 30 11:30:00 CEST 2017, args: status
active
===> Tue May 30 11:30:00 CEST 2017, args: stop
Trying to start service mysql... /usr/sbin/mysqld is stopped
May 30 11:30:19 rv1331 systemd[1]: Failed to start MySQL Community Server.
May 30 11:30:19 rv1331 systemd[1]: mysql.service: Unit entered failed state.
May 30 11:30:19 rv1331 systemd[1]: mysql.service: Failed with result 'exit-code'.

WARNING!
Some problems are found during start service mysql(see log file: /var/log/plesk/psa_service.log)
 
In mysql logs try to find a reason why mysql service can't be started.
 
Now is runnig

there ist a Prob whis the last update


now i can repair

There are still some errors
 

Attachments

  • plesk_17.5.3_repair.log
    6.6 KB · Views: 12
iceman333 said:
There are still some errors
Click to expand...
I see nothing suspicious there except warning about server hostname:

Warning!
Unable to detect the fully qualified domain name of the host.
Please make sure that FQDN of the host is correctly specified in /etc/hosts and goes right after the host's IP address
(depending on your OS, you might need to set the host name in /etc/HOSTNAME or /etc/hostname).

Setting it to localhost.localdomain
Trying to resolve hostname 'localhost.localdomain' and validate its IP address... done
Click to expand...

You can set up server hostname with correct FQDN format or ignore this warning.
 
No idea what that is. The server has been running under the same name for years.

Is there guidance as I can change that
 
You must log in or register to reply here.

Similar threads

jola
Issue Plesk webserver inaccessible
2
Replies
20
Views
5K
jola
jola
learning_curve
Question Small Plesk Errors in the logs - Config Related - Local or Plesk or OS?
Replies
2
Views
950
FISHeR
F
N
Issue cURL request: SSL connection timeout
Replies
4
Views
1K
nico.exe
N
L
Issue Daily Maintenance Script Spawns Off A Bunch Of PHP-FPM processes Leading To Huge Load Spike
Replies
2
Views
1K
Ladylinux
L
S
Question High server resource and mysql error
Replies
7
Views
3K
Peter Debik
P
Back
Top