Contenu | Rechercher | Menus

Annonce

Si vous avez des soucis pour rester connecté, déconnectez-vous puis reconnectez-vous depuis ce lien en cochant la case
Me connecter automatiquement lors de mes prochaines visites.

À propos de l'équipe du forum.

#1 Le 29/07/2020, à 14:34

Falinor

Coincé avec une installation Mysql instable

Bonjour à toutes et à tous!

J'ai besoin de votre aide. Il y a très longtemps j'ai installé mariadb sur mon système Ubuntu pour pouvoir m'initier aux bases de données avec le langage sql. Tout fonctionnait très bien. Avec le temps j'étais passé à d'autres projets, j'ai installé Ubuntu 20.04 et je n'avais pas retouché à mon serveur depuis un moment.

J'ai aujourd'hui un projet qui nécessite l'utilisation d'un sgbd. Or je trouvais ça curieux que je ne puisse utiliser ma base de donnée que par la commande:

sudo mysql

Je voulais pouvoir utiliser  la commande:

mysql -u root@localhost -p

Or je recevais le message d'erreur suivant:

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

En fouillant sur des forums il m'a été conseillé d'installer mysql-server, ce que je trouvais bizarre car avec mariadb c'était normalement déjà fait mais les internautes indiquaient que cela faisait réapparaître le mysqld.sock qui me manquait. En tentant d'installer mysql-server ce-dernier m'a informé qu'il avait besoin de mysql-server-8.0 mais qu'il ne voulait pas l'installer (j'ai perdu le message d'avertissement). Je lui ai donc forcé la main. Après ça même "sudo mysql" ne marchait plus, je n'avais désormais accès à rien.

J'ai donc tenté la politique de la terre brûlée, tout désinstaller ayant un rapport de près ou de loin avec mysql et tout réinstaller. Le problème tant que je ne parviens pas à réinstaller un serveur mysql opérationnel. J'obtiens systématique l'erreur suivante:

dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-8.0; however:
  Package mysql-server-8.0 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.
                                                                                                          Processing triggers for man-db (2.9.1-1) ...
Processing triggers for systemd (245.4-4ubuntu3.2) ...
Errors were encountered while processing:
 mysql-server-8.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Ci-dessous un extrait complet des manip's que j'ai faites:


(base) florian@CRexJr:~$ sudo apt install mysql-client mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server mysql-server-8.0 mysql-server-core-8.0
Reading package lists... Done
Building dependency tree       
Reading state information... Done
mysql-common is already the newest version (5.8+1.0.5ubuntu2).
mysql-common set to manually installed.
mysql-client-8.0 is already the newest version (8.0.21-0ubuntu0.20.04.3).
mysql-client-8.0 set to manually installed.
mysql-client-core-8.0 is already the newest version (8.0.21-0ubuntu0.20.04.3).
mysql-server is already the newest version (8.0.21-0ubuntu0.20.04.3).
mysql-server-8.0 is already the newest version (8.0.21-0ubuntu0.20.04.3).
mysql-server-8.0 set to manually installed.
mysql-server-core-8.0 is already the newest version (8.0.21-0ubuntu0.20.04.3).
The following NEW packages will be installed:
  mysql-client
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
Need to get 0 B/9420 B of archives.
After this operation, 111 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Selecting previously unselected package mysql-client.
(Reading database ... 307442 files and directories currently installed.)
Preparing to unpack .../mysql-client_8.0.21-0ubuntu0.20.04.3_all.deb ...
Unpacking mysql-client (8.0.21-0ubuntu0.20.04.3) ...
Setting up mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
mysqld: error while loading shared libraries: libprotobuf-lite.so.3.11.4: cannot open shared object file: No such file or directory
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-8.0 (--configure):
 installed mysql-server-8.0 package post-installation script subprocess returned error exit status 127
Setting up mysql-client (8.0.21-0ubuntu0.20.04.3) ...
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-8.0; however:
  Package mysql-server-8.0 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-8.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)


(base) florian@CRexJr:~$ sudo mysql
sudo: mysql: command not found


(base) florian@CRexJr:~$ man mysql
No manual entry for mysql


(base) florian@CRexJr:~$ sudo apt-get --fix-broken
E: Command line option --fix-broken is not understood in combination with the other options


(base) florian@CRexJr:~$ sudo apt-get --fix-broken install
Reading package lists... Done
Building dependency tree       
Reading state information... Done
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.
Setting up mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
mysqld: error while loading shared libraries: libprotobuf-lite.so.3.11.4: cannot open shared object file: No such file or directory
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-8.0 (--configure):
 installed mysql-server-8.0 package post-installation script subprocess returned error exit status 127
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-8.0; however:
  Package mysql-server-8.0 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-8.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)


(base) florian@CRexJr:~$ sudo apt-get remove --purge mysql-server mysql-client mysql-common
[sudo] password for florian: 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  mecab-ipadic mecab-ipadic-utf8 mecab-utils
Use 'sudo apt autoremove' to remove them.
The following packages will be REMOVED:
  mysql-client* mysql-client-8.0* mysql-common* mysql-server* mysql-server-8.0*
0 upgraded, 0 newly installed, 5 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 1877 kB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 307445 files and directories currently installed.)
Removing mysql-server (8.0.21-0ubuntu0.20.04.3) ...
Removing mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Removing mysql-client (8.0.21-0ubuntu0.20.04.3) ...
Removing mysql-client-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Removing mysql-common (5.8+1.0.5ubuntu2) ...
Processing triggers for man-db (2.9.1-1) ...
(Reading database ... 307391 files and directories currently installed.)
Purging configuration files for mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Purging configuration files for mysql-common (5.8+1.0.5ubuntu2) ...
Processing triggers for systemd (245.4-4ubuntu3.2) ...


(base) florian@CRexJr:~$ sudo apt-get --fix-broken
E: Command line option --fix-broken is not understood in combination with the other options


(base) florian@CRexJr:~$ sudo apt-get --fix-broken install
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  mecab-ipadic mecab-ipadic-utf8 mecab-utils
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.


(base) florian@CRexJr:~$ sudo apt-get install mysql-server-8.0
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  mysql-client-8.0 mysql-common
Suggested packages:
  mailx tinyca
The following NEW packages will be installed:
  mysql-client-8.0 mysql-common mysql-server-8.0
0 upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/1278 kB of archives.
After this operation, 1656 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 307374 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.8+1.0.5ubuntu2_all.deb ...
Unpacking mysql-common (5.8+1.0.5ubuntu2) ...
Selecting previously unselected package mysql-client-8.0.
Preparing to unpack .../mysql-client-8.0_8.0.21-0ubuntu0.20.04.3_amd64.deb ...
Unpacking mysql-client-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Setting up mysql-common (5.8+1.0.5ubuntu2) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-8.0.
(Reading database ... 307403 files and directories currently installed.)
Preparing to unpack .../mysql-server-8.0_8.0.21-0ubuntu0.20.04.3_amd64.deb ...
Unpacking mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Setting up mysql-client-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Setting up mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
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)
ERROR: Unable to start MySQL server:
mysqld: error while loading shared libraries: libprotobuf-lite.so.3.11.4: cannot open shared object file: No such file or directory
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-8.0 (--configure):
 installed mysql-server-8.0 package post-installation script subprocess returned error exit status 127
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for systemd (245.4-4ubuntu3.2) ...
Errors were encountered while processing:
 mysql-server-8.0
E: Sub-process /usr/bin/dpkg returned an error code (1)


(base) florian@CRexJr:~$ sudo apt-get --fix-broken install
Reading package lists... Done
Building dependency tree       
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
mysqld: error while loading shared libraries: libprotobuf-lite.so.3.11.4: cannot open shared object file: No such file or directory
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-8.0 (--configure):
 installed mysql-server-8.0 package post-installation script subprocess returned error exit status 127
Errors were encountered while processing:
 mysql-server-8.0
E: Sub-process /usr/bin/dpkg returned an error code (1)


(base) florian@CRexJr:~$ sudo apt-get remove --purge mysql-server mysql-client mysql-common
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Package 'mysql-client' is not installed, so not removed
Package 'mysql-server' is not installed, so not removed
The following packages were automatically installed and are no longer required:
  mecab-ipadic mecab-ipadic-utf8 mecab-utils
Use 'sudo apt autoremove' to remove them.
The following packages will be REMOVED:
  mysql-client-8.0* mysql-common* mysql-server-8.0*
0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 1656 kB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 307437 files and directories currently installed.)
Removing mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Removing mysql-client-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Removing mysql-common (5.8+1.0.5ubuntu2) ...
Processing triggers for man-db (2.9.1-1) ...
(Reading database ... 307391 files and directories currently installed.)
Purging configuration files for mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Purging configuration files for mysql-common (5.8+1.0.5ubuntu2) ...
Processing triggers for systemd (245.4-4ubuntu3.2) ...


(base) florian@CRexJr:~$ sudo apt-get remove --purge mysql-server-8.0
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Package 'mysql-server-8.0' is not installed, so not removed
The following packages were automatically installed and are no longer required:
  mecab-ipadic mecab-ipadic-utf8 mecab-utils
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.


(base) florian@CRexJr:~$ sudo apt autoremove
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be REMOVED:
  mecab-ipadic mecab-ipadic-utf8 mecab-utils
0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded.
After this operation, 54,5 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 307373 files and directories currently installed.)
Removing mecab-ipadic-utf8 (2.7.0-20070801+main-2.1) ...
update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
Removing mecab-ipadic (2.7.0-20070801+main-2.1) ...
Removing mecab-utils (0.996-10build1) ...


(base) florian@CRexJr:~$ sudo apt autoclean
Reading package lists... Done
Building dependency tree       
Reading state information... Done


(base) florian@CRexJr:~$ sudo apt install -f
Reading package lists... Done
Building dependency tree       
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.


(base) florian@CRexJr:~$ sudo apt install mysql
Reading package lists... Done
Building dependency tree       
Reading state information... Done
E: Unable to locate package mysql


(base) florian@CRexJr:~$ sudo apt install mysql-client mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-common mysql-server-8.0
Suggested packages:
  mailx tinyca
The following NEW packages will be installed:
  mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client mysql-client-8.0 mysql-common mysql-server mysql-server-8.0
0 upgraded, 8 newly installed, 0 to remove and 0 not upgraded.
Need to get 6723 kB/8020 kB of archives.
After this operation, 56,3 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://fr.archive.ubuntu.com/ubuntu focal/main amd64 mecab-utils amd64 0.996-10build1 [4912 B]
Get:2 http://fr.archive.ubuntu.com/ubuntu focal/main amd64 mecab-ipadic all 2.7.0-20070801+main-2.1 [6714 kB]
Get:3 http://fr.archive.ubuntu.com/ubuntu focal/main amd64 mecab-ipadic-utf8 all 2.7.0-20070801+main-2.1 [4380 B]                                    
Fetched 6723 kB in 2min 17s (49,0 kB/s)                                                                                                              
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 307315 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.8+1.0.5ubuntu2_all.deb ...
Unpacking mysql-common (5.8+1.0.5ubuntu2) ...
Selecting previously unselected package mysql-client-8.0.
Preparing to unpack .../mysql-client-8.0_8.0.21-0ubuntu0.20.04.3_amd64.deb ...
Unpacking mysql-client-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Setting up mysql-common (5.8+1.0.5ubuntu2) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-8.0.
(Reading database ... 307344 files and directories currently installed.)
Preparing to unpack .../0-mysql-server-8.0_8.0.21-0ubuntu0.20.04.3_amd64.deb ...
Unpacking mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Selecting previously unselected package mecab-utils.
Preparing to unpack .../1-mecab-utils_0.996-10build1_amd64.deb ...
Unpacking mecab-utils (0.996-10build1) ...
Selecting previously unselected package mecab-ipadic.
Preparing to unpack .../2-mecab-ipadic_2.7.0-20070801+main-2.1_all.deb ...
Unpacking mecab-ipadic (2.7.0-20070801+main-2.1) ...
Selecting previously unselected package mecab-ipadic-utf8.
Preparing to unpack .../3-mecab-ipadic-utf8_2.7.0-20070801+main-2.1_all.deb ...
Unpacking mecab-ipadic-utf8 (2.7.0-20070801+main-2.1) ...
Selecting previously unselected package mysql-client.
Preparing to unpack .../4-mysql-client_8.0.21-0ubuntu0.20.04.3_all.deb ...
Unpacking mysql-client (8.0.21-0ubuntu0.20.04.3) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../5-mysql-server_8.0.21-0ubuntu0.20.04.3_all.deb ...
Unpacking mysql-server (8.0.21-0ubuntu0.20.04.3) ...
Setting up mecab-utils (0.996-10build1) ...
Setting up mysql-client-8.0 (8.0.21-0ubuntu0.20.04.3) ...
Setting up mysql-server-8.0 (8.0.21-0ubuntu0.20.04.3) ...
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)
ERROR: Unable to start MySQL server:
mysqld: error while loading shared libraries: libprotobuf-lite.so.3.11.4: cannot open shared object file: No such file or directory
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-8.0 (--configure):
 installed mysql-server-8.0 package post-installation script subprocess returned error exit status 127
Setting up mysql-client (8.0.21-0ubuntu0.20.04.3) ...
Setting up mecab-ipadic (2.7.0-20070801+main-2.1) ...
Compiling IPA dictionary for Mecab.  This takes long time...
reading /usr/share/mecab/dic/ipadic/unk.def ... 40
emitting double-array: 100% |###########################################| 
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
emitting double-array: 100% |###########################################| 
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix      : 100% |###########################################| 

done!
update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
Setting up mecab-ipadic-utf8 (2.7.0-20070801+main-2.1) ...
Compiling IPA dictionary for Mecab.  This takes long time...
reading /usr/share/mecab/dic/ipadic/unk.def ... 40
emitting double-array: 100% |###########################################| 
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
emitting double-array: 100% |###########################################| 
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix      : 100% |###########################################| 

done!
update-alternatives: using /var/lib/mecab/dic/ipadic-utf8 to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-8.0; however:
  Package mysql-server-8.0 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.
                                                                                                          Processing triggers for man-db (2.9.1-1) ...
Processing triggers for systemd (245.4-4ubuntu3.2) ...
Errors were encountered while processing:
 mysql-server-8.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Depuis je n'ai toujours accès à rien, je suis privé de serveur mysql et l'unique solution que j'entrevois est de faire revenir mon système entier à une sauvegarde antérieur mais qui me fera perdre beaucoup de mon travail, ce qui ne m'enchante pas du tout...

Merci de m'avoir lu, je serai très attentif à toute aide qui me parviendra sur ce sujet!

Je vous souhaite une très boonne journée!

Dernière modification par Falinor (Le 29/07/2020, à 14:38)

Hors ligne

#2 Le 29/07/2020, à 16:16

Falinor

Re : Coincé avec une installation Mysql instable

Le problème est résolu!

Voici le chemin que j'ai suivi... D'abord j'ai utilisé cette commande qui a tout nettoyé, tout ce qui était lié à mysql d'une quelconque manière a été supprimé, les fichiers de configuration effacés:

sudo apt-get remove --purge mysql-\*

Ensuite j'ai lancé ces deux commandes:

sudo rm /etc/apt/sources.list
sudo software-properties-gtk

La première supprimes tous les dépôts desquels je télécharge les paquets. La seconde me permet de lancer le Software & Updates, j'ai recoché les 4 premières cases en partant du haut, laissé "main server" et j'ai fermé. Ca a recréé un nouveau sources.list.

La suite vous l'avez ci-dessous:

(base) florian@CRexJr:~$ sudo apt install mysql-client mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  libevent-core-2.1-7 libmecab2 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-common mysql-server-8.0
  mysql-server-core-8.0
Suggested packages:
  mailx tinyca
The following NEW packages will be installed:
  libevent-core-2.1-7 libmecab2 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client mysql-client-8.0 mysql-client-core-8.0 mysql-common
  mysql-server mysql-server-8.0 mysql-server-core-8.0
0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded.
Need to get 22,8 MB/29,5 MB of archives.
After this operation, 244 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://archive.ubuntu.com/ubuntu focal/main amd64 mysql-client-core-8.0 amd64 8.0.19-0ubuntu5 [4187 kB]
Get:2 http://archive.ubuntu.com/ubuntu focal/main amd64 mysql-client-8.0 amd64 8.0.19-0ubuntu5 [22,0 kB]                                              
Get:3 http://archive.ubuntu.com/ubuntu focal/main amd64 libevent-core-2.1-7 amd64 2.1.11-stable-1 [89,1 kB]                                           
Get:4 http://archive.ubuntu.com/ubuntu focal/main amd64 libmecab2 amd64 0.996-10build1 [233 kB]                                                       
Get:5 http://archive.ubuntu.com/ubuntu focal/main amd64 mysql-server-core-8.0 amd64 8.0.19-0ubuntu5 [17,0 MB]                                         
Get:6 http://archive.ubuntu.com/ubuntu focal/main amd64 mysql-server-8.0 amd64 8.0.19-0ubuntu5 [1215 kB]                                             
Get:7 http://archive.ubuntu.com/ubuntu focal/main amd64 mysql-client all 8.0.19-0ubuntu5 [9412 B]                                                    
Get:8 http://archive.ubuntu.com/ubuntu focal/main amd64 mysql-server all 8.0.19-0ubuntu5 [9544 B]                                                    
Fetched 22,8 MB in 4min 12s (90,4 kB/s)                                                                                                               
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 305814 files and directories currently installed.)
Preparing to unpack .../0-mysql-common_5.8+1.0.5ubuntu2_all.deb ...
Unpacking mysql-common (5.8+1.0.5ubuntu2) ...
Selecting previously unselected package mysql-client-core-8.0.
Preparing to unpack .../1-mysql-client-core-8.0_8.0.19-0ubuntu5_amd64.deb ...
Unpacking mysql-client-core-8.0 (8.0.19-0ubuntu5) ...
Selecting previously unselected package mysql-client-8.0.
Preparing to unpack .../2-mysql-client-8.0_8.0.19-0ubuntu5_amd64.deb ...
Unpacking mysql-client-8.0 (8.0.19-0ubuntu5) ...
Selecting previously unselected package libevent-core-2.1-7:amd64.
Preparing to unpack .../3-libevent-core-2.1-7_2.1.11-stable-1_amd64.deb ...
Unpacking libevent-core-2.1-7:amd64 (2.1.11-stable-1) ...
Selecting previously unselected package libmecab2:amd64.
Preparing to unpack .../4-libmecab2_0.996-10build1_amd64.deb ...
Unpacking libmecab2:amd64 (0.996-10build1) ...
Selecting previously unselected package mysql-server-core-8.0.
Preparing to unpack .../5-mysql-server-core-8.0_8.0.19-0ubuntu5_amd64.deb ...
Unpacking mysql-server-core-8.0 (8.0.19-0ubuntu5) ...
Setting up mysql-common (5.8+1.0.5ubuntu2) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-8.0.
(Reading database ... 306024 files and directories currently installed.)
Preparing to unpack .../0-mysql-server-8.0_8.0.19-0ubuntu5_amd64.deb ...
Unpacking mysql-server-8.0 (8.0.19-0ubuntu5) ...
Selecting previously unselected package mecab-utils.
Preparing to unpack .../1-mecab-utils_0.996-10build1_amd64.deb ...
Unpacking mecab-utils (0.996-10build1) ...
Selecting previously unselected package mecab-ipadic.
Preparing to unpack .../2-mecab-ipadic_2.7.0-20070801+main-2.1_all.deb ...
Unpacking mecab-ipadic (2.7.0-20070801+main-2.1) ...
Selecting previously unselected package mecab-ipadic-utf8.
Preparing to unpack .../3-mecab-ipadic-utf8_2.7.0-20070801+main-2.1_all.deb ...
Unpacking mecab-ipadic-utf8 (2.7.0-20070801+main-2.1) ...
Selecting previously unselected package mysql-client.
Preparing to unpack .../4-mysql-client_8.0.19-0ubuntu5_all.deb ...
Unpacking mysql-client (8.0.19-0ubuntu5) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../5-mysql-server_8.0.19-0ubuntu5_all.deb ...
Unpacking mysql-server (8.0.19-0ubuntu5) ...
Setting up libmecab2:amd64 (0.996-10build1) ...
Setting up mysql-client-core-8.0 (8.0.19-0ubuntu5) ...
Setting up mecab-utils (0.996-10build1) ...
Setting up libevent-core-2.1-7:amd64 (2.1.11-stable-1) ...
Setting up mysql-server-core-8.0 (8.0.19-0ubuntu5) ...
Setting up mysql-client-8.0 (8.0.19-0ubuntu5) ...
Setting up mysql-server-8.0 (8.0.19-0ubuntu5) ...
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)
mysqld will log errors to /var/log/mysql/error.log
mysqld is running as pid 12273
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Setting up mysql-client (8.0.19-0ubuntu5) ...
Setting up mecab-ipadic (2.7.0-20070801+main-2.1) ...
Compiling IPA dictionary for Mecab.  This takes long time...
reading /usr/share/mecab/dic/ipadic/unk.def ... 40
emitting double-array: 100% |###########################################| 
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
emitting double-array: 100% |###########################################| 
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix      : 100% |###########################################| 

done!
update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
Setting up mecab-ipadic-utf8 (2.7.0-20070801+main-2.1) ...
Compiling IPA dictionary for Mecab.  This takes long time...
reading /usr/share/mecab/dic/ipadic/unk.def ... 40
emitting double-array: 100% |###########################################| 
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
emitting double-array: 100% |###########################################| 
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix      : 100% |###########################################| 

done!
update-alternatives: using /var/lib/mecab/dic/ipadic-utf8 to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
Setting up mysql-server (8.0.19-0ubuntu5) ...
Processing triggers for systemd (245.4-4ubuntu3.2) ...
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for libc-bin (2.31-0ubuntu9) ...


(base) florian@CRexJr:~$ sudo mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.19-0ubuntu5 (Ubuntu)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> exit
Bye


(base) florian@CRexJr:~$ service mysql status
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: active (running) since Wed 2020-07-29 17:09:32 CEST; 1min 17s ago
   Main PID: 12489 (mysqld)
     Status: "Server is operational"
      Tasks: 39 (limit: 4447)
     Memory: 375.7M
     CGroup: /system.slice/mysql.service
             └─12489 /usr/sbin/mysqld

juil. 29 17:09:29 CRexJr systemd[1]: Starting MySQL Community Server...
juil. 29 17:09:32 CRexJr systemd[1]: Started MySQL Community Server.
(base) florian@CRexJr:~$ 

Hors ligne

#3 Le 29/10/2020, à 12:54

bruno

Re : Coincé avec une installation Mysql instable

Attention commandes dangereuses et inutiles dans la « solution » :

sudo rm /etc/apt/sources.list
sudo software-properties-gtk

Hors ligne