Ошибка соединения базы данных phpmyadmin

Oleksa1718 · Post by **Oleksa1718** » Mon Apr 13, 2015 2:19 pm

На почу пришло письмо по всем пользователям в панели Vesta:

Can't connect to localhost
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

При входе на сайт пишет: ошибка соединения с базой данных.

Зайти в phpmyadmin под своими паролями не получилось ни в одну базу данных из восьми сайтов.

Перезагрузила панель Веста-все заработало, но необходимо найти причину проблемы.

Техподдержка на мои вопросы посоветовала мне проверить есть ли свободное место на сервере, после моего ответа, что свободного места предостаточно они посоветовали:
"По данному вопргосу рекомендуем посмотреть логи сервера и поискать ответы в сети интернет."

Как и где мне посмотреть логи сервера и определить причину отключения баз данных?

Post by **skurudo** » Mon Apr 13, 2015 2:53 pm

Нужно посмотреть в /var/log на предмет ошибок.

Дисковое пространство тоже не помешает проверить, но не только его, но и количество свободных инодов (вторая команда:

Code: Select all

df -h

Code: Select all

df -i

PS: Девушка-админ - это такая редкость :)
PS2: ОС было бы неплохо указать, а также характеристики сервера и конфиг my.cnf

Oleksa1718 · Post by **Oleksa1718** » Mon Apr 13, 2015 4:19 pm

Дисковое пространстов использовано 7%
Свободных инодов использовано 2%

Filesystem Size Used Avail Use% Mounted on
/dev/xvda1 50G 2.9G 44G 7% /
none 491M 0 491M 0% /dev/shm

Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/xvda1 3276800 58170 3218630 2% /
none 125455 1 125454 1% /dev/shm

Смотрела эти данные с помощью утилиты Putty через SSH соединения, вводя указанные вами в предыдущем сообщении команды, тут же пробовала ввести /var/log что бы посмотреть логи, но у мне ничего не показало, система пишет :
-bash: /var/log: is a directory
...понимаю что видно что-то не туда ввожу :))), но как мне все-таки посмотреть эти логи? помогите плиз.
Может быть эти логи смотреть где-то в самой панели? (все что я нашла в панели-это логи сайтов по каждому сайту, но мне кажется это не то что нужно)

ОС: CentOS 6.4 32bit
Панель Веста установлена на виртуальном сервере, какие именно указать характеристики?

PS: Админом меня назвать сложно, просто перенесла свои сайты на виртуальный сервер, вот теперь и приходится в этом всем копаться, что бы они (эти мои сайты) работали и дальше :))).

Post by **skurudo** » Mon Apr 13, 2015 4:36 pm

Oleksa1718 wrote:-bash: /var/log: is a directory
...понимаю что видно что-то не туда ввожу :))), но как мне все-таки посмотреть эти логи? помогите плиз.
Может быть эти логи смотреть где-то в самой панели? (все что я нашла в панели-это логи сайтов по каждому сайту, но мне кажется это не то что нужно)

Для просмотра лога mysql:

Code: Select all

cat /var/log/mysqld.log

Перейти в директорию - cd

Можно использовать файловый менеджер - mc
возможно его придется сначала установить - yum install mc

Oleksa1718 wrote:ОС: CentOS 6.4 32bit
Панель Веста установлена на виртуальном сервере, какие именно указать характеристики?

Характеристики тарифного плана - процессор, сколько памяти
ну и не помешает конфигурационный файл mysql - /etc/my.cnf

Code: Select all

cat  /etc/my.cnf

Oleksa1718 wrote:PS: Админом меня назвать сложно, просто перенесла свои сайты на виртуальный сервер, вот теперь и приходится в этом всем копаться, что бы они (эти мои сайты) работали и дальше :))).

Безумству храбрых... Смелый шаг :)

Oleksa1718 · Post by **Oleksa1718** » Mon Apr 13, 2015 4:57 pm

Вот что показало после ввода команды

Code: Select all

cat /var/log/mysqld.log

логи ошибок mysqlShow

150411 1:34:24 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:24 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:24 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:24 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:25 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:25 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:25 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:26 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:26 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:26 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:27 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:27 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:27 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:27 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:28 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:28 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:28 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:29 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:34:29 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:19 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:19 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:19 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:24 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:24 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:25 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:25 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:25 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:26 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:26 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:26 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:26 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:26 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:27 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:27 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:27 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:27 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:28 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:28 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:28 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:28 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:28 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:29 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:29 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:29 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:46 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:46 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:46 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:47 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:47 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:47 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:47 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:47 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:48 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:49 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:49 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:49 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:50 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:50 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:50 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:51 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:35:51 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:00 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:03 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:03 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:03 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:04 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:04 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:05 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:05 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:06 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:06 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:06 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:07 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:07 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:08 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:08 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:08 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:09 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:09 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:11 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:11 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:11 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:12 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:12 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:12 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:13 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:13 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:13 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:14 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:30 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:30 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:36 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:36 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:36 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:37 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:37 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:37 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:38 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:38 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:38 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:39 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:43 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:43 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:44 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:44 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:44 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:45 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:45 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:45 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:45 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:46 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:46 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:46 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:46 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:46 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:46 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:47 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:47 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:47 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:48 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:48 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:36:48 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:22 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:22 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:22 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:22 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:23 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:23 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:34 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:34 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:35 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:35 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:35 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:36 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:36 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:36 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:36 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:37 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:37 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:37 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:38 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:38 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:59 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:59 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:37:59 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:00 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:00 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:00 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:01 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:01 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:01 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:01 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:02 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:02 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:02 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:03 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:03 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:03 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:04 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:38:04 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:42:35 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:42:35 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:42:35 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:42:36 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:42:36 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:42:36 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:42:37 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:42:37 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:49 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:49 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:50 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:50 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:50 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:51 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:51 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:51 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:52 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:52 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:52 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:52 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:53 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:53 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:53 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:54 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:43:54 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 1:44:06 [Warning] IP address '107.160.20.148' could not be resolved: Temporary failure in name resolution
150411 10:08:34 [Warning] IP address '118.126.3.107' could not be resolved: Name or service not known
150411 11:51:45 [Warning] IP address '61.240.144.65' could not be resolved: Temporary failure in name resolution
150411 12:14:41 [Warning] IP address '60.169.80.233' could not be resolved: Name or service not known
150411 21:53:29 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:29 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:30 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:30 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:30 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:31 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:31 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:31 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:32 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:32 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:32 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:33 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:33 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:33 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:34 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:34 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:35 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:35 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:36 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:36 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:37 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:37 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:37 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:38 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:38 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:39 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:40 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:40 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:41 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:41 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:43 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:43 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:44 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:44 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:44 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:45 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:45 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:46 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:46 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:46 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:46 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:47 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:47 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:47 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:48 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:48 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:49 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:49 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:49 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:50 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:50 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:50 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:50 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:51 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:51 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:51 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:52 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:52 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:53 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:53 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:54 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:56 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:56 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 21:53:57 [Warning] IP address '198.13.108.254' could not be resolved: Temporary failure in name resolution
150411 23:24:00 [Warning] IP address '104.233.142.214' could not be resolved: Name or service not known
150412 7:58:00 [Warning] IP address '222.186.21.154' could not be resolved: Name or service not known
150412 9:47:34 [Warning] IP address '58.96.176.149' could not be resolved: Name or service not known
150412 11:36:12 mysqld_safe Number of processes running now: 0
150412 11:36:13 mysqld_safe mysqld restarted
150412 11:36:13 [Note] Plugin 'FEDERATED' is disabled.
150412 11:36:13 InnoDB: The InnoDB memory heap is disabled
150412 11:36:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150412 11:36:13 InnoDB: Compressed tables use zlib 1.2.3
150412 11:36:13 InnoDB: Using Linux native AIO
150412 11:36:13 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(135987200 bytes) failed; errno 12
150412 11:36:13 InnoDB: Completed initialization of buffer pool
150412 11:36:13 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150412 11:36:13 [ERROR] Plugin 'InnoDB' init function returned error.
150412 11:36:13 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150412 11:36:13 [ERROR] Unknown/unsupported storage engine: InnoDB
150412 11:36:13 [ERROR] Aborting

150412 11:36:13 [Note] /usr/libexec/mysqld: Shutdown complete

150412 11:36:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150413 10:03:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150413 10:03:47 [Note] Plugin 'FEDERATED' is disabled.
150413 10:03:47 InnoDB: The InnoDB memory heap is disabled
150413 10:03:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150413 10:03:47 InnoDB: Compressed tables use zlib 1.2.3
150413 10:03:47 InnoDB: Using Linux native AIO
150413 10:03:47 InnoDB: Initializing buffer pool, size = 128.0M
150413 10:03:47 InnoDB: Completed initialization of buffer pool
150413 10:03:47 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
150413 10:03:47 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
150413 10:03:48 InnoDB: Waiting for the background threads to start
150413 10:03:49 InnoDB: 5.5.42 started; log sequence number 18428463
150413 10:03:49 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150413 10:03:49 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150413 10:03:49 [Note] Server socket created on IP: '0.0.0.0'.
150413 10:03:49 [Note] Event Scheduler: Loaded 0 events
150413 10:03:49 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.42' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi

"Характеристики тарифного плана процессор, сколько памяти"
1 GB RAM
1 CPU Xeon Core 3.3 GHz
Диск 50 GB

"ну и не помешает конфигурационный файл mysql - /etc/my.cnf"
cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
max_connections=200
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
#log-queries-not-using-indexes
#log-slow-queries=/var/log/mysql/log-slow-queries.log

#innodb_use_native_aio = 0
innodb_file_per_table

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Post by **skurudo** » Mon Apr 13, 2015 5:05 pm

Похоже, закончилась память в какой-то момент.

Попробуйте более скромный конфигурационный файл:

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
#max_connections=40
#max_user_connections=20
wait_timeout=10
interactive_timeout=50
long_query_time=5
#log-queries-not-using-indexes
#log-slow-queries=/var/log/mysql/log-slow-queries.log

key_buffer_size = 64M
myisam_sort_buffer_size = 32M
join_buffer_size=1M
read_buffer_size=1M
sort_buffer_size=2M
table_cache=512
thread_cache_size=8
interactive_timeout=25
connect_timeout=5
max_allowed_packet=1M
max_connect_errors=1000
query_cache_limit=2M
query_cache_size=128M
query_cache_type=1
tmp_table_size=16M

#innodb_use_native_aio = 0
innodb_file_per_table

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Oleksa1718 · Post by **Oleksa1718** » Mon Apr 13, 2015 9:31 pm

Спасибо, файл изменила.

Post by **skurudo** » Mon Apr 13, 2015 9:32 pm

Oleksa1718 wrote:Спасибо, файл изменила.

Не забудьте mysql перезапустить, чтобы применить изменения.

Oleksa1718 · Post by **Oleksa1718** » Tue Apr 14, 2015 7:51 am

Code: Select all

sudo service mysql restart

Могу это сделать данной командой через Putty ?

Oleksa1718 · Post by **Oleksa1718** » Tue Apr 14, 2015 8:45 am

или лучше вот так :

Code: Select all

/etc/init.d/mysql restart

Vesta Control Panel - Forum

Ошибка соединения базы данных phpmyadmin

Ошибка соединения базы данных phpmyadmin

Re: Ошибка соединения базы данных phpmyadmin

Re: Ошибка соединения базы данных phpmyadmin

Re: Ошибка соединения базы данных phpmyadmin

Re: Ошибка соединения базы данных phpmyadmin

Re: Ошибка соединения базы данных phpmyadmin

Re: Ошибка соединения базы данных phpmyadmin

Re: Ошибка соединения базы данных phpmyadmin

Re: Ошибка соединения базы данных phpmyadmin

Re: Ошибка соединения базы данных phpmyadmin

Login • Register