[ ratkaistu ] Ubuntu 18.04 pilvessä, mysql -asennus epäonnistuu

[teele]

Mysql -asennus epäonnistuu, tässä tulostuksia, joista voisi selvitä jotain sille, joka asioita ymmärtää

Koodia: [Valitse]

Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (auto-restart) (Result: exit-code) since Wed 2020-06-17 13:17:33 CEST; 21ms ago
  Process: 18383 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
  Process: 18362 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)

Jun 17 13:17:33 ubuntu-2gb-hel1-1 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jun 17 13:17:33 ubuntu-2gb-hel1-1 systemd[1]: Failed to start MySQL Community Server.
dpkg: error processing package mysql-server-5.7 (--configure):
 installed mysql-server-5.7 package post-installation script subprocess 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.27-3ubuntu1) ...
Processing triggers for systemd (237-3ubuntu10.41) ...
No apport report written because the error message indicates its a followup error from a previous failure.
        Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Processing triggers for ureadahead (0.100.0-21) ...
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Asennuspyyntö oli

Koodia: [Valitse]

sudo apt install mysql-server mysql-client

[nm]

Johtunee aiemmin asennetuista mysql-paketeista tai levylle jääneestä datasta. Poista mysql uudelleen ja varmista, että tietokantahakemistoa /var/lib/mysql ei ole olemassa.

Koodia: [Valitse]

ls -ld /var/lib/mysql
Tarkista pakettien poiston jälkeen vielä uudelleen, ettei mitään MySQL:ään liittyvää ole jäänyt jäljelle:

Koodia: [Valitse]

dpkg -l | grep mysql

[teele]

 hakemistoa ei ole

Koodia: [Valitse]

ls -ld /var/lib/mysql
ls: cannot access '/var/lib/mysql': No such file or directory

Mutta mikä on näiden merkitys

Koodia: [Valitse]

dpkg -l | grep mysql
ii  mysql-client                     5.7.30-0ubuntu0.18.04.1             all          MySQL database client (metapackage depending on the latest version)
ii  mysql-client-5.7                 5.7.30-0ubuntu0.18.04.1             amd64        MySQL database client binaries
ii  mysql-client-core-5.7            5.7.30-0ubuntu0.18.04.1             amd64        MySQL database core client binaries
ii  mysql-common                     5.8+1.0.4                           all          MySQL database common files, e.g. /etc/mysql/my.cnf

Mjuok.

Poistin asiakkaankin

Koodia: [Valitse]

sudo apt purge mysql-client
jos sillä olisi jotain vaikutusta asiaan

[nm]

mysql-common on myös syytä poistaa, ja /etc/mysql -hakemisto, jos se jää lojumaan levylle poistojen jälkeen.

[teele]

uusi yritys poistojen jälkeen

Koodia: [Valitse]

/var/lib/dpkg/info/mysql-server-5.7.postinst: line 191: /usr/share/mysql-common/configure-symlinks: No such file or directory
dpkg: error processing package mysql-server-5.7 (--configure):
 installed mysql-server-5.7 package post-installation script subprocess returned error exit status 127
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.27-3ubuntu1) ...No apport report written because the error message indicates its a followup error from a previous failure.

Processing triggers for systemd (237-3ubuntu10.41) ...
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Processing triggers for ureadahead (0.100.0-21) ...
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

eli jotain näyttäisi puuttuvan

Koodia: [Valitse]

/var/lib/dpkg/info/mysql-server-5.7.postinst: line 191: /usr/share/mysql-common/configure-symlinks: No such file or directory
tulostuksesta otettu ensimmäinen epäilyttävä rivi, siihen asti kaikki vaikuttaa menenvän niin, kuin pitääkin.

[nm]

Hmm. Onkohan järjestelmässä MariaDB:n ohjelmalähteitä? Mitä sanoo:

Koodia: [Valitse]

apt-cache policy mysql-common

[teele]

 näin väliaikatietona: yritin asentaa mariaDB:tä mutta se ei onnistunut, selvitän asiaa ...

Koodia: [Valitse]

apt-cache policy mysql-common
mysql-common:
  Installed: 5.8+1.0.4
  Candidate: 5.8+1.0.4
  Version table:
 *** 5.8+1.0.4 500
        500 http://archive.ubuntu.com/ubuntu bionic/main amd64 Packages
        500 http://archive.ubuntu.com/ubuntu bionic/main i386 Packages
        500 http://mirror.hetzner.de/ubuntu/packages bionic/main amd64 Packages
        500 http://mirror.hetzner.de/ubuntu/packages bionic/main i386 Packages
        100 /var/lib/dpkg/status


[teele]

 eli jotain on mariaDB:stä,

[nm]

mysql-common 5.8+1.0.4 vaikuttaa sinänsä oikealta paketilta, mutta varmista, ettei järjestelmässä ole mitään jäänteitä MariaDB:stä.

Koodia: [Valitse]

dpkg -l | grep mariadb

[teele]

ei ole mitään

Koodia: [Valitse]

dpkg -l | grep mariadb



[nm]

Jaa-a. Aika erikoinen ongelma. Mitä jos asennat pelkän mysql-common-paketin? Onko silloin tiedosto /usr/share/mysql-common/configure-symlinks paikallaan?

Koodia: [Valitse]

sudo apt install mysql-common

Koodia: [Valitse]

ls -l /usr/share/mysql-common/configure-symlinks
Ja mitä se sisältää?

Koodia: [Valitse]

cat /usr/share/mysql-common/configure-symlinks
Pitäisi näyttää tältä:

Koodia: [Valitse]

#!/bin/sh
set -e

case "$1" in
  install)
    variant="$2"
    my_cnf_path="$3"
    update-alternatives --install /etc/mysql/my.cnf my.cnf "$my_cnf_path" 200
  ;;
  remove)
    variant="$2"
    my_cnf_path="$3"
    update-alternatives --remove my.cnf "$my_cnf_path"
  ;;
esac

[teele]

tässä komento ja ilmoitukset, ei onnistunut, näyttää, että mysql-common olisi jo, olenko töpeksinyt sittekin poistoissa

Koodia: [Valitse]

sudo apt install mysql-common
[sudo] password for pilvikone:
Reading package lists... Done
Building dependency tree       
Reading state information... Done
mysql-common is already the newest version (5.8+1.0.4).
mysql-common set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 0 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.30-0ubuntu0.18.04.1) ...
/var/lib/dpkg/info/mysql-server-5.7.postinst: line 191: /usr/share/mysql-common/configure-symlinks: No such file or directory
dpkg: error processing package mysql-server-5.7 (--configure):
 installed mysql-server-5.7 package post-installation script subprocess returned error exit status 127
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
No apport report written because the error message indicates its a followup error from a previous failure.
         Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)


[teele]

katsoin vielä tämänkin

Koodia: [Valitse]

ls -l /usr/share/mysql-common/configure-symlinks
ls: cannot access '/usr/share/mysql-common/configure-symlinks': No such file or directory


[nm]

Voisi vielä kerran poistaa kaikki mysql-paketit ja asentaa mysql-common uudelleen ennen kuin asennat mysql-serverin. Löytyykö sitten tiedosto /usr/share/mysql-common/configure-symlinks

[teele]

Pakettien poistossa taitaa olla jotain häikkää,

Koodia: [Valitse]

sudo apt purge mysql-server
[sudo] password for pilvikone:
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  libevent-core-2.1-6 mysql-server-5.7 mysql-server-core-5.7
Use 'sudo apt autoremove' to remove them.
The following packages will be REMOVED:
  mysql-server*
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 111 kB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 40560 files and directories currently installed.)
Removing mysql-server (5.7.30-0ubuntu0.18.04.1) ...
Setting up mysql-server-5.7 (5.7.30-0ubuntu0.18.04.1) ...
/var/lib/dpkg/info/mysql-server-5.7.postinst: line 191: /usr/share/mysql-common/configure-symlinks: No such file or directory
dpkg: error processing package mysql-server-5.7 (--configure):
 installed mysql-server-5.7 package post-installation script subprocess returned error exit status 127
Errors were encountered while processing:
 mysql-server-5.7
E: Sub-process /usr/bin/dpkg returned an error code (1)

Onko muuta keinoa poistaa kaikki mysql -paketit.

[nm]

Lähteekö tällä:

Koodia: [Valitse]

sudo dpkg --remove --force-remove-reinstreq mysql-server-core-5.7 mysql-server-5.7 mysql-server

[teele]

Taisi lähteä

Koodia: [Valitse]

sudo  dpkg --remove --force-remove-reinstreq mysql-server-core-5.7 mysql-server-5.7 mysql-server
[sudo] password for slam1:
(Reading database ... 40556 files and directories currently installed.)
Removing mysql-server-5.7 (5.7.30-0ubuntu0.18.04.1) ...
dpkg: warning: ignoring request to remove mysql-server which isn't installed
Removing mysql-server-core-5.7 (5.7.30-0ubuntu0.18.04.1) ...
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...

jos varoitus ei haittaa,

Pehmolinkit ainakin näyttävät häipyneen

Koodia: [Valitse]

ls /usr/share/mysql-common/configure-symlinksls: cannot access '/usr/share/mysql-common/configure-symlinks': No such file or directory
Muok.
Eli nyt mysql-common ja sitten mysql-server ja mysql-client, tai mikä sen asiakkaan merkitys tässä on, ehkä sen voi laittaa sitten, jos palvelinasennus menee läpi.

[nm]

Jep. Asenna mysql-common ensin ja katso, että aiemmin puuttunut tiedosto on paikallaan.

[teele]

Näyttää siltä, että mysql-common ei olekaan poistunut eli eiliset poistoyritykset eivät kokonaan onnistuneet.

Koodia: [Valitse]

sudo apt install mysql-common
Reading package lists... Done
Building dependency tree       
Reading state information... Done
mysql-common is already the newest version (5.8+1.0.4).
The following package was automatically installed and is no longer required:
  libevent-core-2.1-6
Use 'sudo apt autoremove' to remove it.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Poistin sen

Koodia: [Valitse]

sudo apt-get purge mysql-common
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following package was automatically installed and is no longer required:
  libevent-core-2.1-6
Use 'sudo apt autoremove' to remove it.
The following packages will be REMOVED:
  mysql-client* mysql-client-5.7* mysql-common*
0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded.
After this operation, 31.3 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 40385 files and directories currently installed.)
Removing mysql-client (5.7.30-0ubuntu0.18.04.1) ...
Removing mysql-client-5.7 (5.7.30-0ubuntu0.18.04.1) ...
Removing mysql-common (5.8+1.0.4) ...
update-alternatives: warning: alternative /etc/mysql/my.cnf.fallback (part of link group my.cnf) doesn't exist; removing from list of alternatives
update-alternatives: warning: /etc/alternatives/my.cnf is dangling; it will be updated with best choice
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
(Reading database ... 40337 files and directories currently installed.)
Purging configuration files for mysql-common (5.8+1.0.4) ...

ja asensin uudestaan

Koodia: [Valitse]

sudo apt install mysql-common
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following package was automatically installed and is no longer required:
  libevent-core-2.1-6
Use 'sudo apt autoremove' to remove it.
The following NEW packages will be installed:
  mysql-common
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/7308 B of archives.
After this operation, 34.8 kB of additional disk space will be used.
Selecting previously unselected package mysql-common.
(Reading database ... 40334 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.8+1.0.4_all.deb ...
Unpacking mysql-common (5.8+1.0.4) ...
Setting up mysql-common (5.8+1.0.4) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode

nyt pehmolinkit ovat paikoilaan

Koodia: [Valitse]

ls -l /usr/share/mysql-common/configure-symlinks
-rwxr-xr-x 1 root root 276 Aug  3  2016 /usr/share/mysql-common/configure-symlinks
Seuraavaksi pitänee asentaa mysql-server ja mysql-client, mutta laitan tämän väliaikaisvarmistuskyselynä ennen kuin ehdin tehdä mitään asennuksia, joiden poistamisessa joudun ongelmiin.

[_Pete_]

Tuossa omituista että on eri versiota paketeista. Lähinnä kiinnostaa miten sellaisen on saanut aikaan?