Автор Тема: В p8 поломали mysql [РЕШЕНО]  (Прочитано 25384 раз)

Оффлайн yaleks

  • Мастер
  • ***
  • Сообщений: 6 222
В p8 поломали mysql [РЕШЕНО]
« : 29.05.2018 13:26:32 »
MySQL-server-5.7.21-alt4.M80P.1

# /etc/init.d/mysqld restart
Sending TERM signal to mysqld: Service mysqld is not running.[PASSED]
Waiting for mysqld to actually shut down: [ DONE ]
/etc/init.d/mysqld: line 36: [: missing `]'
Adjusting environment for mysqld: [ DONE ]
Starting mysqld service: Unable to determine if daemon is running: Success
[FAILED]
« Последнее редактирование: 01.06.2018 08:30:26 от Rider »

Оффлайн Rider

  • /usr/sbin/control
  • *******
  • Сообщений: 1 136
Re: В p8 поломали mysql
« Ответ #1 : 29.05.2018 17:29:41 »
да, сломалось на sysvinit.
исправление в task #207289

Оффлайн yaleks

  • Мастер
  • ***
  • Сообщений: 6 222
Re: В p8 поломали mysql
« Ответ #2 : 29.05.2018 23:20:00 »
фиг  :-(

# /etc/init.d/mysqld start
Adjusting environment for mysqld: [ DONE ]
Starting mysqld service: Unable to determine if daemon is running: Success
[FAILED]

Оффлайн yaleks

  • Мастер
  • ***
  • Сообщений: 6 222
Re: В p8 поломали mysql
« Ответ #3 : 29.05.2018 23:59:03 »
[Note] InnoDB: Loading buffer pool(s) from /db/ib_buffer_pool
[Note] Plugin 'FEDERATED' is disabled.
[Note] InnoDB: Buffer pool(s) load completed at 180529 23:48:32
[Warning] System table 'plugin' is expected to be transactional.
[Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
[ERROR] mysqld: Can't create/write to file '/var/lib/mysql/mysqld.pid' (Errcode: 2 - No such file or directory)
[ERROR] Can't start server: can't create PID file: No such file or directory

Оффлайн Rider

  • /usr/sbin/control
  • *******
  • Сообщений: 1 136
Re: В p8 поломали mysql
« Ответ #4 : 30.05.2018 07:47:59 »
фиг  :-(

# /etc/init.d/mysqld start
Adjusting environment for mysqld: [ DONE ]
Starting mysqld service: Unable to determine if daemon is running: Success
[FAILED]

mysql_upgrade делали как в post скрипте пакета сказано ?

Оффлайн Rider

  • /usr/sbin/control
  • *******
  • Сообщений: 1 136
Re: В p8 поломали mysql
« Ответ #5 : 30.05.2018 09:56:15 »
После dist-upgrade нужно сделать:
/usr/sbin/mysqld -C utf8 --skip-grant-tables
и в соседнем терминале
/usr/bin/mysql_upgrade
после завершения обновления таблиц - killall mysqld

Оффлайн Rider

  • /usr/sbin/control
  • *******
  • Сообщений: 1 136
Re: В p8 поломали mysql
« Ответ #6 : 30.05.2018 10:13:42 »
Если после обновления не заработает:
control mysqld-chroot disabled
в качестве временной меры, пока мы не разберёмся с его работой на sysvinit.

Оффлайн yaleks

  • Мастер
  • ***
  • Сообщений: 6 222
Re: В p8 поломали mysql
« Ответ #7 : 30.05.2018 13:18:02 »
Попробую, но на стабильном бранче такие пируэты с серверным софтом творить без предупреждения какой такой умник додумался?

Оффлайн yaleks

  • Мастер
  • ***
  • Сообщений: 6 222
Re: В p8 поломали mysql
« Ответ #8 : 30.05.2018 13:39:04 »
Если после обновления не заработает:
control mysqld-chroot disabled
в качестве временной меры, пока мы не разберёмся с его работой на sysvinit.
С этим версия alt6 запустилась

Оффлайн Rider

  • /usr/sbin/control
  • *******
  • Сообщений: 1 136
Re: В p8 поломали mysql
« Ответ #9 : 30.05.2018 13:41:22 »
Попробую, но на стабильном бранче такие пируэты с серверным софтом творить без предупреждения какой такой умник додумался?

В смысле ?
Все эти пируэты были отлично протестированы, но кто ж думал что кто-то догадается держать серверные системы на sysvinit на бранче, в котором эту самую поддержку sysvinit уже не тестируют ?

А MySQL 5.5 когда-то в ближайшем будущем end-of-life придёт, и лучше с него уйти.

8-ая версия  MySQL в stable branch уже не пойдёт, это я обещаю.

Оффлайн Rider

  • /usr/sbin/control
  • *******
  • Сообщений: 1 136
Re: В p8 поломали mysql
« Ответ #10 : 30.05.2018 13:42:28 »
Если после обновления не заработает:
control mysqld-chroot disabled
в качестве временной меры, пока мы не разберёмся с его работой на sysvinit.
С этим версия alt6 запустилась

Виновника уже нашли, обновление в пути в p8.

Оффлайн mig

  • Давно тут
  • **
  • Сообщений: 102
    • Email
Re: В p8 поломали mysql
« Ответ #11 : 30.05.2018 14:09:16 »
Спасибо!

Оффлайн yaleks

  • Мастер
  • ***
  • Сообщений: 6 222
Re: В p8 поломали mysql
« Ответ #12 : 30.05.2018 14:35:58 »
Все эти пируэты были отлично протестированы, но кто ж думал что кто-то догадается держать серверные системы на sysvinit на бранче, в котором эту самую поддержку sysvinit уже не тестируют ?

А MySQL 5.5 когда-то в ближайшем будущем end-of-life придёт, и лучше с него уйти.

8-ая версия  MySQL в stable branch уже не пойдёт, это я обещаю.
так вроде в p7 как было sysvinit на сервере, так и осталось при обновлении.

Обновлять версии можно, главное чтобы загодя были анонсы в людных местах.

Оффлайн Rider

  • /usr/sbin/control
  • *******
  • Сообщений: 1 136
Re: В p8 поломали mysql
« Ответ #13 : 30.05.2018 19:32:01 »
Везде (всем) не проанонсируешь и лучшего анонса чем в репозитории представить сложно.

Исправление запуска mysqld в конфигурации chrooted + sysVinit - уже в p8, завтра можно будет обновить. Там инитскрипт немного поправили.

Оффлайн yaleks

  • Мастер
  • ***
  • Сообщений: 6 222
Re: В p8 поломали mysql
« Ответ #14 : 31.05.2018 18:18:41 »
Вы вот это хотели что-ли победить?

Цитировать
-------- CVE Security Recommendations --------------------------------------------------------------
[!!] CVE-2018-2755(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Replication). Supported versions that are affected are 5.5.59 and prior
[!!] CVE-2018-2758(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server : Security : Privileges). Supported versions that are affected are 5.6.39 and prior and 5.7.21 and prior. Easily exploitable vulnerability allows low privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 6.5 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2759(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: InnoDB). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2761(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Client programs). Supported versions that are affected are 5.5.59 and prior
[!!] CVE-2018-2762(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Connection). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with logon to the infrastructure where MySQL Server executes to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.4 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:L/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2766(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: InnoDB). Supported versions that are affected are 5.6.39 and prior and 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2769(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Pluggable Auth). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2771(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Locking). Supported versions that are affected are 5.5.59 and prior
[!!] CVE-2018-2773(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Client programs). Supported versions that are affected are 5.5.59 and prior
[!!] CVE-2018-2775(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Optimizer). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows low privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 6.5 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2776(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Group Replication GCS). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via XCom to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2777(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: InnoDB). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2778(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Optimizer). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2779(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Optimizer). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2780(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Optimizer). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows low privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 6.5 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2781(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Optimizer). Supported versions that are affected are 5.5.59 and prior
[!!] CVE-2018-2782(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: InnoDB). Supported versions that are affected are 5.6.39 and prior and 5.7.21 and prior. Easily exploitable vulnerability allows low privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 6.5 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2784(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: InnoDB). Supported versions that are affected are 5.6.39 and prior and 5.7.21 and prior. Easily exploitable vulnerability allows low privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 6.5 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2786(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: InnoDB). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server as well as unauthorized update
[!!] CVE-2018-2787(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: InnoDB). Supported versions that are affected are 5.6.39 and prior and 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server as well as unauthorized update
[!!] CVE-2018-2810(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: InnoDB). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2812(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Optimizer). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server as well as unauthorized update
[!!] CVE-2018-2813(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: DDL). Supported versions that are affected are 5.5.59 and prior
[!!] CVE-2018-2816(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Optimizer). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2817(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: DDL). Supported versions that are affected are 5.5.59 and prior
[!!] CVE-2018-2818(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server : Security : Privileges). Supported versions that are affected are 5.5.59 and prior
[!!] CVE-2018-2819(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: InnoDB). Supported versions that are affected are 5.5.59 and prior
[!!] CVE-2018-2839(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: DML). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] CVE-2018-2846(<= 5.7.21) : "Vulnerability in the MySQL Server component of Oracle MySQL (subcomponent: Server: Performance Schema). Supported versions that are affected are 5.7.21 and prior. Easily exploitable vulnerability allows high privileged attacker with network access via multiple protocols to compromise MySQL Server. Successful attacks of this vulnerability can result in unauthorized ability to cause a hang or frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H)."
[!!] 29 CVE(s) found for your MySQL release.