Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!

Ogłoszenie

Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.

#1  2017-05-03 16:47:13

  mike26 - Użytkownik

mike26
Użytkownik
Skąd: ~/
Zarejestrowany: 2013-10-16

Błąd przetwarzania pakietu mysql-server

Przy próbie aktualizacji lub instalacji jakiegokolwiek programu pojawia mi się błąd dotyczący mysql-server.
Problem może być spowodowany tym że kiedyś chciałem zaktualizować cups do wersji 2.2, niby się zainstalowała ale w liście programów widoczna jest wersja 1.75.

Kod:

The following partially installed packages will be configured:
  mysql-server mysql-server-5.5
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.
Setting up mysql-server-5.5 (5.5.55-0+deb8u1) ...
insserv: warning: script 'K01minidlna' missing LSB tags and overrides
insserv: warning: script 'K36cups' missing LSB tags and overrides
insserv: warning: script 'cups' missing LSB tags and overrides
insserv: warning: script 'minidlna' missing LSB tags and overrides
insserv: There is a loop between service smbd and mountnfs if started
insserv:  loop involving service mountnfs at depth 4
insserv:  loop involving service networking at depth 3
insserv: There is a loop between service cups and udev if started
insserv:  loop involving service udev at depth 1
insserv: There is a loop between service smbd and mountnfs if started
insserv: There is a loop between service cups and mountall if started
insserv:  loop involving service mountall at depth 4
insserv:  loop involving service checkfs at depth 3
insserv: There is a loop between service cups and mountall-bootclean if started
insserv:  loop involving service mountall-bootclean at depth 5
insserv:  loop involving service urandom at depth 7
insserv:  loop involving service kbd at depth 6
insserv: There is a loop between service cups and mountall if started
insserv:  loop involving service mountnfs-bootclean at depth 6
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv:  loop involving service cups at depth 5
insserv:  loop involving service smbd at depth 4
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: There is a loop at service rmnologin if started
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: There is a loop between service smbd and mountdevsubfs if started
insserv:  loop involving service mountdevsubfs at depth 1
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv:  loop involving service hdparm at depth 3
insserv:  loop involving service mountkernfs at depth 1
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Max recursions depth 99 reached
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: exiting now without changing boot order!
update-rc.d: error: insserv rejected the script header
dpkg: error processing package mysql-server-5.5 (--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.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Failed to perform requested operation on package.  Trying to recover:
Setting up mysql-server-5.5 (5.5.55-0+deb8u1) ...
insserv: warning: script 'K01minidlna' missing LSB tags and overrides
insserv: warning: script 'K36cups' missing LSB tags and overrides
insserv: warning: script 'cups' missing LSB tags and overrides
insserv: warning: script 'minidlna' missing LSB tags and overrides
insserv: There is a loop between service smbd and mountnfs if started
insserv:  loop involving service mountnfs at depth 4
insserv:  loop involving service networking at depth 3
insserv: There is a loop between service cups and udev if started
insserv:  loop involving service udev at depth 1
insserv: There is a loop between service smbd and mountnfs if started
insserv: There is a loop between service cups and mountall if started
insserv:  loop involving service mountall at depth 4
insserv:  loop involving service checkfs at depth 3
insserv: There is a loop between service cups and mountall-bootclean if started
insserv:  loop involving service mountall-bootclean at depth 5
insserv:  loop involving service urandom at depth 7
insserv:  loop involving service kbd at depth 6
insserv: There is a loop between service cups and mountall if started
insserv:  loop involving service mountnfs-bootclean at depth 6
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv:  loop involving service cups at depth 5
insserv:  loop involving service smbd at depth 4
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: There is a loop at service rmnologin if started
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: There is a loop between service smbd and mountdevsubfs if started
insserv:  loop involving service mountdevsubfs at depth 1
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv:  loop involving service hdparm at depth 3
insserv:  loop involving service mountkernfs at depth 1
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Max recursions depth 99 reached
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: Starting cups depends on rmnologin and therefore on system facility `$all' which can not be true!
insserv: exiting now without changing boot order!
update-rc.d: error: insserv rejected the script header
dpkg: error processing package mysql-server-5.5 (--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.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server

Próbowałem dpkg --configure -a; reinstalacja cups, mysql, mysql-server,
polecenie aptitude keep-all
Nie mam pojęcia jak to naprawić.

Kod:

uname -a
Linux OpiPC 3.4.113-sun8i #10 SMP PREEMPT Thu Feb 23 19:55:00 CET 2017 armv7l GNU/Linux

Kod:

lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 8.7 (jessie)
Release:        8.7
Codename:       jessie

Offline

 

#2  2017-05-03 16:57:28

  yossarian - Szczawiożerca

yossarian
Szczawiożerca
Skąd: Shangri-La
Zarejestrowany: 2011-04-25

Re: Błąd przetwarzania pakietu mysql-server

To nie ma nic wspólnego z mysql-server.

Komunikaty o tym jasno mówią.
Poczytaj o nagłówkach skryptów startowch. Albo je od razu przepisz na usługi systemd.

Offline

 

#3  2017-05-04 03:02:24

  Jacekalex - Podobno człowiek...;)

Jacekalex
Podobno człowiek...;)
Skąd: /dev/random
Zarejestrowany: 2008-01-07

Re: Błąd przetwarzania pakietu mysql-server

Mysql-5 już dawno ustąpił miejsca serwerowi Mariadb, stał się w ten sposób malutkim anachronizmem, pewnie dlatego ma nieaktualne skrypty instalacyjne w paczce.

Powinieneś zainstalować to:

Kod:

mariadb-server:
...
     10.0.30-0+deb8u1 500
        500 http://security.debian.org stable/updates/main amd64 Packages
        500 http://security.debian.org stable/updates/main i386 Packages

Pozdro

Ostatnio edytowany przez Jacekalex (2017-05-04 03:04:01)


W demokracji każdy naród ma taką władzę, na jaką zasługuje ;)
Si vis pacem  para bellum  ;)       |       Pozdrawiam :)

Offline

 

#4  2017-05-06 12:21:42

  mike26 - Użytkownik

mike26
Użytkownik
Skąd: ~/
Zarejestrowany: 2013-10-16

Re: Błąd przetwarzania pakietu mysql-server

Mówiąc o nagłówkach startowych chodzi ci o to?

Kod:

# Provides:          mysql
# Required-Start:    $remote_fs $syslog
# Required-Stop:     $remote_fs $syslog
# Should-Start:      $network $time
# Should-Stop:       $network $time
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: Start and stop the mysql database server daemon
# Description:       Controls the main MySQL database server daemon "mysqld"
#                    and its wrapper script "mysqld_safe".

Kod:

systemctl start mysql.service
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.

Kod:

systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: failed (Result: exit-code) since Sat 2017-05-06 12:10:39 CEST; 15s ago
  Process: 3693 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

May 06 12:10:39 OpiPC mysql[3693]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
May 06 12:10:39 OpiPC systemd[1]: mysql.service: control process exited, code=exited status=1
May 06 12:10:39 OpiPC systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
May 06 12:10:39 OpiPC systemd[1]: Unit mysql.service entered failed state.

Kod:

journalctl -xn
-- Logs begin at Sat 2017-05-06 12:02:30 CEST, end at Sat 2017-05-06 12:14:24 CEST. --
May 06 12:13:50 OpiPC systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
-- Subject: Unit mysql.service has begun with start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
May 06 12:14:24 OpiPC /etc/init.d/mysql[5579]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 06 12:14:24 OpiPC /etc/init.d/mysql[5579]: [61B blob data]
May 06 12:14:24 OpiPC /etc/init.d/mysql[5579]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 06 12:14:24 OpiPC /etc/init.d/mysql[5579]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 06 12:14:24 OpiPC /etc/init.d/mysql[5579]:
May 06 12:14:24 OpiPC mysql[4841]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
May 06 12:14:24 OpiPC systemd[1]: mysql.service: control process exited, code=exited status=1
May 06 12:14:24 OpiPC systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
May 06 12:14:24 OpiPC systemd[1]: Unit mysql.service entered failed state.

Kod:

cat /etc/init.d/mysql
#!/bin/bash
#
### BEGIN INIT INFO
# Provides:          mysql
# Required-Start:    $remote_fs $syslog
# Required-Stop:     $remote_fs $syslog
# Should-Start:      $network $time
# Should-Stop:       $network $time
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: Start and stop the mysql database server daemon
# Description:       Controls the main MySQL database server daemon "mysqld"
#                    and its wrapper script "mysqld_safe".
### END INIT INFO
#
set -e
set -u
${DEBIAN_SCRIPT_DEBUG:+ set -v -x}

test -x /usr/bin/mysqld_safe || exit 0

. /lib/lsb/init-functions

SELF=$(cd $(dirname $0); pwd -P)/$(basename $0)
CONF=/etc/mysql/my.cnf
MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"

# priority can be overriden and "-s" adds output to stderr
ERR_LOGGER="logger -p daemon.err -t /etc/init.d/mysql -i"

# Safeguard (relative paths, core dumps..)
cd /
umask 077

# mysqladmin likes to read /root/.my.cnf. This is usually not what I want
# as many admins e.g. only store a password without a username there and
# so break my scripts.
export HOME=/etc/mysql/

## Fetch a particular option from mysql's invocation.
#
# Usage: void mysqld_get_param option
mysqld_get_param() {
        /usr/sbin/mysqld --print-defaults \
                | tr " " "\n" \
                | grep -- "--$1" \
                | tail -n 1 \
                | cut -d= -f2
}

## Do some sanity checks before even trying to start mysqld.
sanity_checks() {
  # check for config file
  if [ ! -r /etc/mysql/my.cnf ]; then
    log_warning_msg "$0: WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz"
    echo                "WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz" | $ERR_LOGGER
  fi

  # check for diskspace shortage
  datadir=`mysqld_get_param datadir`
  if LC_ALL=C BLOCKSIZE= df --portability $datadir/. | tail -n 1 | awk '{ exit ($4>4096) }'; then
    log_failure_msg "$0: ERROR: The partition with $datadir is too full!"
    echo                "ERROR: The partition with $datadir is too full!" | $ERR_LOGGER
    exit 1
  fi
}

## Checks if there is a server running and if so if it is accessible.
#
# check_alive insists on a pingable server
# check_dead also fails if there is a lost mysqld in the process list
#
# Usage: boolean mysqld_status [check_alive|check_dead] [warn|nowarn]
mysqld_status () {
    ping_output=`$MYADMIN ping 2>&1`; ping_alive=$(( ! $? ))

    ps_alive=0
    pidfile=`mysqld_get_param pid-file`
    if [ -f "$pidfile" ] && ps `cat $pidfile` >/dev/null 2>&1; then ps_alive=1; fi

    if [ "$1" = "check_alive"  -a  $ping_alive = 1 ] ||
       [ "$1" = "check_dead"   -a  $ping_alive = 0  -a  $ps_alive = 0 ]; then
        return 0 # EXIT_SUCCESS
    else
        if [ "$2" = "warn" ]; then
            echo -e "$ps_alive processes alive and '$MYADMIN ping' resulted in\n$ping_output\n" | $ERR_LOGGER -p daemon.debug
        fi
        return 1 # EXIT_FAILURE
    fi
}

#
# main()
#

case "${1:-''}" in
  'start')
        sanity_checks;
        # Start daemon
        log_daemon_msg "Starting MySQL database server" "mysqld"
        if mysqld_status check_alive nowarn; then
           log_progress_msg "already running"
           log_end_msg 0
        else
            # Could be removed during boot
            test -e /var/run/mysqld || install -m 755 -o mysql -g root -d /var/run/mysqld

            # Start MySQL!
            /usr/bin/mysqld_safe > /dev/null 2>&1 &

            # 6s was reported in #352070 to be too few when using ndbcluster
            # 14s was reported in #736452 to be too few with large installs
            for i in $(seq 1 30); do
                sleep 1
                if mysqld_status check_alive nowarn ; then break; fi
                log_progress_msg "."
            done
            if mysqld_status check_alive warn; then
                log_end_msg 0
                # Now start mysqlcheck or whatever the admin wants.
                output=$(/etc/mysql/debian-start)
                [ -n "$output" ] && log_action_msg "$output"
            else
                log_end_msg 1
                log_failure_msg "Please take a look at the syslog"
            fi
        fi
        ;;

  'stop')
        # * As a passwordless mysqladmin (e.g. via ~/.my.cnf) must be possible
        # at least for cron, we can rely on it here, too. (although we have
        # to specify it explicit as e.g. sudo environments points to the normal
        # users home and not /root)
        log_daemon_msg "Stopping MySQL database server" "mysqld"
        if ! mysqld_status check_dead nowarn; then
          set +e
          shutdown_out=`$MYADMIN shutdown 2>&1`; r=$?
          set -e
          if [ "$r" -ne 0 ]; then
            log_end_msg 1
            [ "$VERBOSE" != "no" ] && log_failure_msg "Error: $shutdown_out"
            log_daemon_msg "Killing MySQL database server by signal" "mysqld"
            killall -15 mysqld
            server_down=
            for i in 1 2 3 4 5 6 7 8 9 10; do
              sleep 1
              if mysqld_status check_dead nowarn; then server_down=1; break; fi
            done
          if test -z "$server_down"; then killall -9 mysqld; fi
          fi
        fi

        if ! mysqld_status check_dead warn; then
          log_end_msg 1
          log_failure_msg "Please stop MySQL manually and read /usr/share/doc/mysql-server-5.5/README.Debian.gz!"
          exit -1
        else
          log_end_msg 0
        fi
        ;;

  'restart')
        set +e; $SELF stop; set -e
        $SELF start
        ;;

  'reload'|'force-reload')
        log_daemon_msg "Reloading MySQL database server" "mysqld"
        $MYADMIN reload
        log_end_msg 0
        ;;

  'status')
        if mysqld_status check_alive nowarn; then
          log_action_msg "$($MYADMIN version)"
        else
          log_action_msg "MySQL is stopped."
          exit 3
        fi
        ;;

  *)
        echo "Usage: $SELF start|stop|restart|reload|force-reload|status"
        exit 1
        ;;
esac

Kod:

 aptitude -f install
The following partially installed packages will be configured:
  mysql-server mysql-server-5.5
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.
Setting up mysql-server-5.5 (5.5.55-0+deb8u1) ...
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.5 (--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.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Failed to perform requested operation on package.  Trying to recover:
Setting up mysql-server-5.5 (5.5.55-0+deb8u1) ...
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.5 (--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.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server

@Jacekalex
W tej chwili ani zainstalować ani odinstalować. Jak wszystko będzie działało można pomyśleć nad mariadb.

Offline

 

#5  2017-05-06 13:49:26

  Jacekalex - Podobno człowiek...;)

Jacekalex
Podobno człowiek...;)
Skąd: /dev/random
Zarejestrowany: 2008-01-07

Re: Błąd przetwarzania pakietu mysql-server

Jak wszystko będzie działało?

Wywal w tej chwili Mysql-server i w jego miejsce zainstaluj Mariadb-server, to praktycznie taki sam serwer, poza tym, że Mariadb ma dużo lepsze wsparcie po tym, jak Orable przejęło Sun Microsystems i zaczęło majstrować przy projekcie Mysql.

Z tego samego powodu Libreoffice wyparł Openoffce.

MariaDB w akcji:

Kod:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 17
Server version: 10.0.30-MariaDB Source distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> \s;
--------------
mysql  Ver 15.1 Distrib 10.0.30-MariaDB, for Linux (x86_64) using readline 6.3

Connection id:        17
Current database:    
Current user:        root@localhost
SSL:            Cipher in use is DHE-RSA-AES256-SHA
Current pager:        /usr/bin/less
Using outfile:        ''
Using delimiter:    ;
Server:            MariaDB
Server version:        10.0.30-MariaDB Source distribution
Protocol version:    10
Connection:        Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:        /var/run/mysqld/mysqld.sock
Uptime:            2 hours 36 min 24 sec

Threads: 11  Questions: 24  Slow queries: 0  Opens: 7  Flush tables: 1  Open tables: 64  Queries per second avg: 0.002

Note that you are running in safe_update_mode:
UPDATEs and DELETEs that don't use a key in the WHERE clause are not allowed.
(One can force an UPDATE/DELETE by adding LIMIT # at the end of the command.)
SELECT has an automatic 'LIMIT 1000' if LIMIT is not used.
Max number of examined row combination in a join is set to: 1000000

Ostatnio edytowany przez Jacekalex (2017-05-06 13:51:19)


W demokracji każdy naród ma taką władzę, na jaką zasługuje ;)
Si vis pacem  para bellum  ;)       |       Pozdrawiam :)

Offline

 

Stopka forum

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson
Możesz wyłączyć AdBlock — tu nie ma reklam ;-)