Я установил Ubuntu бездисплейный сервер 14.04 вчера. Единственной вещью, в той точке, которую я установил, был ssh. Я обновил сервер, затем установил Plesk с их автоматизированным сценарием установки.
Это - виртуальный сервер, работающий гиперпротив, у меня есть 12 ядер, поршень на 16 ГБ, и HD на 500 ГБ выделил его.
Я получил доступ к веб-сайту без проблемы. У меня еще нет действительного сертификата SSL, поскольку я не получил это далеко. Я затем установил лицензию на Plesk. Я сделал немного отслеживания вокруг, чтобы видеть, как оно работает и затем легло спать. Я запустил этим утром на нем, и сайт не подойдет. Я продолжал делать пересадку, отказался, когда я пытался получить доступ к сайту. Я читал вокруг, и это сказало для попытки этого для фиксации его:
cd /var
sudo mkdir mysql
sudo chmod 755 mysql
cd mysql
sudo ln -s /tmp/mysql.sock mysql.sock
Это позволило мне получать доступ к сайту. Когда я пытаюсь сделать что-либо в сайте, я получаю это:
ОШИБКА: PleskDBException: Невозможно подключиться к базой данных: mysql_connect (): Никакой такой файл или каталог/var/run/mysqld/mysqld.sock (Код ошибки: 2002). Проверьте, что сервер базы данных запущен и доступен. (Краткий обзор php:69)
Я проверил журналы в /var/log/mysql/error.log, mysql.error был нулевыми байтами:
151126 10:59:24 mysqld_safe Number of processes running now: 0
151126 10:59:24 mysqld_safe mysqld restarted
151126 10:59:24 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
151126 10:59:24 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0ubuntu0.14.04.2) starting as process 3082 ...
151126 10:59:24 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
151126 10:59:24 [Note] Plugin 'FEDERATED' is disabled.
151126 10:59:24 InnoDB: The InnoDB memory heap is disabled
151126 10:59:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151126 10:59:24 InnoDB: Compressed tables use zlib 1.2.8
151126 10:59:24 InnoDB: Using Linux native AIO
151126 10:59:24 InnoDB: Initializing buffer pool, size = 128.0M
151126 10:59:24 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
151126 10:59:24 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
Я не внес изменений кроме какой я вышеизложенный. У кого-либо есть какие-либо предложения, где посмотреть или что сделать?
Дополнительная информация:
[24-Nov-2015 20:23:38 America/Chicago] PHP Warning: chgrp(): Operation not permitted; File: /opt/psa/admin/plib/Plesk/Log.php, Line: 66
[2015-11-24 20:23:38] ERR [1] PHP Warning: chgrp(): Operation not permitted; File: /opt/psa/admin/plib/Plesk/Log.php, Line: 66
[2015-11-24 20:24:19] ERR [1] Module configs is not installed.
[2015-11-24 21:18:21] ERR [panel] [Action Log] Failed login attempt with login 'techguyalabama' from IP 50.2.213.12
[2015-11-24 21:18:28] ERR [panel] [Action Log] Failed login attempt with login 'admin' from IP 50.2.213.12
[2015-11-25 09:30:45] ERR [util_exec] proc_close() failed ['/opt/psa/admin/bin/spammng' '--status'] with exit code [1]
[2015-11-25 09:30:45] ERR [1] '/opt/psa/admin/bin/spammng' '--status' failed with code 1.
stdout:
stderr:
ERROR:spammng:[Errno 2] No such file or directory: '/etc/default/spamassassin'
[2015-11-25 12:49:51] ERR [panel] [Action Log] Failed login attempt with login '<invalid>' from IP 104.238.110.138
[2015-11-26 06:25:03] ERR [panel] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 10:27:18] ERR [panel] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.:
0: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:69
CommonPanel_Application_Abstract::initDbAdapter()
1: /opt/psa/admin/plib/Session/Helper.php:150
Plesk\Session\Helper::initStorage()
2: /opt/psa/admin/plib/auth.php:325
AutoPrepend->initUserSession()
3: /opt/psa/admin/plib/auth.php:230
AutoPrepend->run()
4: /opt/psa/admin/plib/auth.php:759
[2015-11-26 10:27:18] ERR [1] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 10:51:37] ERR [panel] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.:
0: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:69
CommonPanel_Application_Abstract::initDbAdapter()
1: /opt/psa/admin/plib/Session/Helper.php:150
Plesk\Session\Helper::initStorage()
2: /opt/psa/admin/plib/auth.php:325
AutoPrepend->initUserSession()
3: /opt/psa/admin/plib/auth.php:230
AutoPrepend->run()
4: /opt/psa/admin/plib/auth.php:759
[2015-11-26 10:51:37] ERR [1] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 10:59:31] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 10:59:32] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 10:59:32] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 10:59:32] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:08:57] ERR [panel] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.:
0: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:69
CommonPanel_Application_Abstract::initDbAdapter()
1: /opt/psa/admin/plib/api-common/AbstractCu.php:1640
AbstractCu::initDb()
2: /opt/psa/admin/plib/api-common/AbstractCu.php:1666
AbstractCu::initCLI()
3: /opt/psa/admin/plib/scripts/setup-health-monitor.php:5
[2015-11-26 11:08:57] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:09:08] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:13:47] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:13:47] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:22:41] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:22:41] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:22:41] ERR [1] Unable to connect to database: /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:23:32] ERR [panel] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.:
0: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:69
CommonPanel_Application_Abstract::initDbAdapter()
1: /opt/psa/admin/plib/Session/Helper.php:150
Plesk\Session\Helper::initStorage()
2: /opt/psa/admin/plib/auth.php:325
AutoPrepend->initUserSession()
3: /opt/psa/admin/plib/auth.php:230
AutoPrepend->run()
4: /opt/psa/admin/plib/auth.php:759
[2015-11-26 11:23:32] ERR [1] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:23:52] ERR [panel] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.:
0: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:69
CommonPanel_Application_Abstract::initDbAdapter()
1: /opt/psa/admin/plib/Session/Helper.php:150
Plesk\Session\Helper::initStorage()
2: /opt/psa/admin/plib/auth.php:325
AutoPrepend->initUserSession()
3: /opt/psa/admin/plib/auth.php:230
AutoPrepend->run()
4: /opt/psa/admin/plib/auth.php:759
[2015-11-26 11:23:52] ERR [1] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:23:56] ERR [panel] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.:
0: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:69
CommonPanel_Application_Abstract::initDbAdapter()
1: /opt/psa/admin/plib/Session/Helper.php:150
Plesk\Session\Helper::initStorage()
2: /opt/psa/admin/plib/auth.php:325
AutoPrepend->initUserSession()
3: /opt/psa/admin/plib/auth.php:230
AutoPrepend->run()
4: /opt/psa/admin/plib/auth.php:759
[2015-11-26 11:23:56] ERR [1] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
[2015-11-26 11:24:00] ERR [panel] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.:
0: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:69
CommonPanel_Application_Abstract::initDbAdapter()
1: /opt/psa/admin/plib/Session/Helper.php:150
Plesk\Session\Helper::initStorage()
2: /opt/psa/admin/plib/auth.php:325
AutoPrepend->initUserSession()
3: /opt/psa/admin/plib/auth.php:230
AutoPrepend->run()
4: /opt/psa/admin/plib/auth.php:759
[2015-11-26 11:24:00] ERR [1] Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible.
Немного больше информации:
Разыскиваемый mysqld.sock и mysql.sock:
> sudo find . -name mysqld.sock
> sudo find . -name mysql.sock
./var/mysql/mysql.sock
> sudo find . -name my.cnf
./etc/mysql/my.cnf
Проверенный my.cnf и это имели это:
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
Этот каталог пуст:/var/run/mysqld
Я не настолько знаком с установкой MySql, но я полагал, что совместно использую это...
Сегодня я испытал это. Я просто остановил mysql и запустил его снова:
# service mysql stop
mysql stop/waiting
# service mysql start
mysql start/running, process 4042
я не уверен в надлежащей фиксации для этого.
После конца /var/log/mysql/error.log
я решил, что было несколько версий mysql, пытающегося работать. Я удалил /etc/init.d/mysql
и не получил эту ошибку на следующей перезагрузке.
РЕЗЕРВНОЕ КОПИРОВАНИЕ /etc/init.d/mysql
ПЕРВЫЙ
# This will maintian all file ownership and permissions
# and back this up in your home directory:
cp -ar /etc/init.d/mysql "$HOME"