Добрый вечер парни, первый раз столкнулся с такой проблемой.
Установив apache2 ставлю (уже и так и сяк пробовал и + пересборка сервера) mysql, lamp, phpmyadmin (что не ставь то все ошибки) Errors were encountered while processing:
mysql-server-5.7
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Не знаю как их победить то уже, кто может помочь?
sudo apt-get update ----- > ставлю апач -------> sudo apt-get install mysql-server -------> ошибка ниже
root@alej:~# sudo apt install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server is already the newest version (5.7.21-0ubuntu0.16.04.1).
0 upgraded, 0 newly installed, 0 to remove and 195 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] Y
Setting up mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Renaming removed key_buffer and myisam-recover options (if present)
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@alej:~#
Пересборка тобишь обнулял весь сервак у провайдера, удалить и заного создать
Беру чистый сервер убунту 16 далее sudo apt-get update далее sudo apt-get install apache2 далее sudo apt install mysql-server затем просит ввести пароль для рут юзера и ввожу далее конфирмлю пароль и вот итоговый лог root@alej:~# sudo apt install mysql-server
Reading package lists... Done
Building dependency tree
Preparing to unpack .../mysql-server_5.7.21-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-server (5.7.21-0ubuntu0.16.04.1) ...
Processing triggers for systemd (229-4ubuntu16) ...
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for man-db (2.7.5-1) ...
Setting up libaio1:amd64 (0.3.110-2) ...
Setting up mysql-client-core-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Setting up mysql-client-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Setting up mysql-server-core-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Setting up libevent-core-2.0-5:amd64 (2.0.21-stable-2ubuntu0.16.04.1) ...
Setting up mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Processing triggers for libc-bin (2.23-0ubuntu5) ...
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for systemd (229-4ubuntu16) ...
Processing triggers for ureadahead (0.100.0-19) ...
Errors were encountered while processing:
mysql-server-5.7
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@alej:~#
Собственно в процессе установки mysql-server почему-то не запустился:
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
Смотрим лог mysql, и в нём будет причина, почему он не запускается...
Mar 29 21:13:11 alej sshd[22890]: Disconnected from 221.194.47.236 port 42227 [preauth]
Mar 29 21:13:11 alej sshd[22890]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=221.194.
Mar 29 21:13:12 alej sshd[22892]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost
Mar 29 21:13:13 alej sshd[22892]: Failed password for root from 221.194.47.236 port 53182 ssh2
Mar 29 21:13:15 alej sshd[22892]: Failed password for root from 221.194.47.236 port 53182 ssh2
Mar 29 21:13:18 alej sshd[22892]: Failed password for root from 221.194.47.236 port 53182 ssh2
Mar 29 21:13:18 alej sshd[22892]: Received disconnect from 221.194.47.236 port 53182:11: [preauth]
Mar 29 21:13:18 alej sshd[22892]: Disconnected from 221.194.47.236 port 53182 [preauth]
Mar 29 21:13:18 alej sshd[22892]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=221.194.
Mar 29 21:13:20 alej sshd[22895]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost
Mar 29 21:13:22 alej sshd[22895]: Failed password for root from 221.194.47.236 port 57557 ssh2
Mar 29 21:13:22 alej sshd[22895]: Failed password for root from 221.194.47.236 port 57557 ssh2
Mar 29 21:13:24 alej sshd[22895]: Failed password for root from 221.194.47.236 port 57557 ssh2
Mar 29 21:13:27 alej sshd[22895]: Failed password for root from 221.194.47.236 port 57557 ssh2
Mar 29 21:13:27 alej sshd[22895]: Received disconnect from 221.194.47.236 port 57557:11: [preauth]
Mar 29 21:13:27 alej sshd[22895]: Disconnected from 221.194.47.236 port 57557 [preauth]
Mar 29 21:13:27 alej sshd[22895]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=221.194.
Mar 29 21:13:29 alej sshd[22897]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost
Mar 29 21:13:31 alej sshd[22897]: Failed password for root from 221.194.47.236 port 36788 ssh2
Mar 29 21:13:33 alej sshd[22897]: Failed password for root from 221.194.47.236 port 36788 ssh2
Mar 29 21:13:35 alej sshd[22897]: Failed password for root from 221.194.47.236 port 36788 ssh2
Mar 29 21:13:35 alej sshd[22897]: Received disconnect from 221.194.47.236 port 36788:11: [preauth]
Mar 29 21:13:35 alej sshd[22897]: Disconnected from 221.194.47.236 port 36788 [preauth]
Mar 29 21:13:35 alej sshd[22897]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=221.194.
Mar 29 21:13:38 alej sshd[22899]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost
Mar 29 21:13:41 alej sshd[22899]: Failed password for root from 221.194.47.236 port 39677 ssh2
Mar 29 21:13:43 alej sshd[22899]: Failed password for root from 221.194.47.236 port 39677 ssh2
Mar 29 21:13:45 alej sshd[22899]: Failed password for root from 221.194.47.236 port 39677 ssh2
Mar 29 21:13:46 alej sshd[22899]: Received disconnect from 221.194.47.236 port 39677:11: [preauth]
Mar 29 21:13:46 alej sshd[22899]: Disconnected from 221.194.47.236 port 39677 [preauth]
Mar 29 21:13:46 alej sshd[22899]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=221.194.
Mar 29 21:13:47 alej sshd[22901]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost
Mar 29 21:13:49 alej sshd[22901]: Failed password for root from 221.194.47.236 port 50596 ssh2
Mar 29 21:13:51 alej sshd[22901]: Failed password for root from 221.194.47.236 port 50596 ssh2
systemctl status mysql.service
● mysql.service
Loaded: not-found (Reason: No such file or directory)
Active: inactive (dead)
journalctl -xe вам показывает просто последние записи в журнале, если его и запускать, то сразу после перезапуска mysql. Кстати, по логу видно, что вам надо какой-нибудь fail2ban поставить, чтобы защититься от брутфорса паролей по ssh.
Заглянуть стоит в /var/log/mysql или journalctl -u mysql
2018-03-29T20:10:52.100560Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-03-29T20:10:52.125863Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-03-29T20:10:52.125937Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2018-03-29T20:10:52.125950Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-03-29T20:10:52.125966Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-03-29T20:10:52.125977Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-03-29T20:10:52.125988Z 0 [ERROR] Failed to initialize builtin plugins.
2018-03-29T20:10:52.125996Z 0 [ERROR] Aborting
Борис Сёмов, можно с вами в скайпе или еще где списаться? рою рою эти ошибки и наталкиваюсь то на одно то на второе но рез один и тот же, а в скайпе быстрее было бы!
Борис Сёмов, вопрос решен, всем спасибо парни, Борис, если есть возможность с вами все равно где нибудь "добавиться" буду рад, (скайп - xandr2410, isq 694807097)но эт просто мытарства что было на самом деле ХД
просто не хватило б** памяти, уже полностью отчаявшись пересмотря кучу инструкций и осунувшись я подумал как то что может взять сервак "пообъемнее?" и все прошло успешно
парни, берегите себя!!!:)
да все верно, сейчас он есть после очередной пересборки сервера
Вот полностью лог: root@alej:~# sudo apt install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server is already the newest version (5.7.21-0ubuntu0.16.04.1).
0 upgraded, 0 newly installed, 0 to remove and 195 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] Y
Setting up mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Renaming removed key_buffer and myisam-recover options (if present)
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@alej:~#
Ничего не делал на сервере кроме того что установил апач
vlarkanov, можешь добавить меня в скайп или еще куда то? а то на форуме оч долго (((
journalctl -xe выдает следующее:
Mar 29 21:13:11 alej sshd[22890]: Disconnected from 221.194.47.236 port 42227 [preauth]
Mar 29 21:13:11 alej sshd[22890]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=221.194.
Mar 29 21:13:12 alej sshd[22892]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost
Mar 29 21:13:13 alej sshd[22892]: Failed password for root from 221.194.47.236 port 53182 ssh2
Mar 29 21:13:15 alej sshd[22892]: Failed password for root from 221.194.47.236 port 53182 ssh2
Mar 29 21:13:18 alej sshd[22892]: Failed password for root from 221.194.47.236 port 53182 ssh2
Mar 29 21:13:18 alej sshd[22892]: Received disconnect from 221.194.47.236 port 53182:11: [preauth]
Mar 29 21:13:18 alej sshd[22892]: Disconnected from 221.194.47.236 port 53182 [preauth]
Mar 29 21:13:18 alej sshd[22892]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=221.194.
Mar 29 21:13:20 alej sshd[22895]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost
Mar 29 21:13:22 alej sshd[22895]: Failed password for root from 221.194.47.236 port 57557 ssh2
Mar 29 21:13:22 alej sshd[22895]: Failed password for root from 221.194.47.236 port 57557 ssh2
Mar 29 21:13:24 alej sshd[22895]: Failed password for root from 221.194.47.236 port 57557 ssh2
Mar 29 21:13:27 alej sshd[22895]: Failed password for root from 221.194.47.236 port 57557 ssh2
Mar 29 21:13:27 alej sshd[22895]: Received disconnect from 221.194.47.236 port 57557:11: [preauth]
Mar 29 21:13:27 alej sshd[22895]: Disconnected from 221.194.47.236 port 57557 [preauth]
Mar 29 21:13:27 alej sshd[22895]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=221.194.
Mar 29 21:13:29 alej sshd[22897]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost
Mar 29 21:13:31 alej sshd[22897]: Failed password for root from 221.194.47.236 port 36788 ssh2
Mar 29 21:13:33 alej sshd[22897]: Failed password for root from 221.194.47.236 port 36788 ssh2
Mar 29 21:13:35 alej sshd[22897]: Failed password for root from 221.194.47.236 port 36788 ssh2
Mar 29 21:13:35 alej sshd[22897]: Received disconnect from 221.194.47.236 port 36788:11: [preauth]
Mar 29 21:13:35 alej sshd[22897]: Disconnected from 221.194.47.236 port 36788 [preauth]
Mar 29 21:13:35 alej sshd[22897]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=221.194.
Mar 29 21:13:38 alej sshd[22899]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost
Mar 29 21:13:41 alej sshd[22899]: Failed password for root from 221.194.47.236 port 39677 ssh2
Mar 29 21:13:43 alej sshd[22899]: Failed password for root from 221.194.47.236 port 39677 ssh2
Mar 29 21:13:45 alej sshd[22899]: Failed password for root from 221.194.47.236 port 39677 ssh2
Mar 29 21:13:46 alej sshd[22899]: Received disconnect from 221.194.47.236 port 39677:11: [preauth]
Mar 29 21:13:46 alej sshd[22899]: Disconnected from 221.194.47.236 port 39677 [preauth]
Mar 29 21:13:46 alej sshd[22899]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=221.194.
Mar 29 21:13:47 alej sshd[22901]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost
Mar 29 21:13:49 alej sshd[22901]: Failed password for root from 221.194.47.236 port 50596 ssh2
Mar 29 21:13:51 alej sshd[22901]: Failed password for root from 221.194.47.236 port 50596 ssh2
systemctl status mysql.service
● mysql.service
Loaded: not-found (Reason: No such file or directory)
Active: inactive (dead)
Просто не влезало по памяти. Можно было бы уменьшить innodb_buffer_pool_size, например, или где-нибудь ещё уменьшить потребеление памяти, чтобы mysql мог запуститься.
McBernar Ошибка как в последней строчке может быть в массе различных случаев, часто даже не связанных с dpkg, искать её в гугле совершенно бесполезно как таковую, без контекста.