Problème installation mysql-server

newty · Février 21, 2016, 1:27am

Bonjour,

Je suis en train d’installer nginx, php5-fpm, mysql (server et client) ainsi que phpmyadmin sur debian 6 mais le start de mysql-server ne fonctionne pas… Sauriez vous pourquoi ?

Voici ce que j’ai :

20:40 root@web ~ # apt-get install mysql-server
Reading package lists… Done
Building dependency tree
Reading state information… Done
The following extra packages will be installed:
libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16
libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-common
mysql-server-5.1 mysql-server-core-5.1 psmisc
Suggested packages:
libipc-sharedcache-perl libterm-readkey-perl tinyca
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16
libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-common mysql-server
mysql-server-5.1 mysql-server-core-5.1 psmisc
0 upgraded, 12 newly installed, 0 to remove and 21 not upgraded.
Need to get 23.4MB of archives.
After this operation, 55.1MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://packages.dotdeb.org squeeze/all mysql-common 5.1.56-0.dotdeb.1 [69.5kB]
Get:2 http://packages.dotdeb.org squeeze/all libmysqlclient16 5.1.56-0.dotdeb.1 [1926kB]
Get:3 http://packages.dotdeb.org squeeze/all mysql-client-5.1 5.1.56-0.dotdeb.1 [9604kB]
Get:4 http://ftp.debian.org squeeze/main libnet-daemon-perl 0.43-1 [46.6kB]
Get:5 http://ftp.debian.org squeeze/main libplrpc-perl 0.2020-2 [36.0kB]
Get:6 http://packages.dotdeb.org squeeze/all mysql-server-core-5.1 5.1.56-0.dotdeb.1 [3941kB]
Get:7 http://ftp.debian.org squeeze/main libdbi-perl 1.612-1 [879kB]
Get:8 http://packages.dotdeb.org squeeze/all mysql-server-5.1 5.1.56-0.dotdeb.1 [6522kB]
Get:9 http://packages.dotdeb.org squeeze/all mysql-server 5.1.56-0.dotdeb.1 [62.8kB]
Get:10 http://ftp.debian.org squeeze/main libdbd-mysql-perl 4.016-1 [138kB]
Get:11 http://ftp.debian.org squeeze/main psmisc 22.11-1 [122kB]
Get:12 http://ftp.debian.org squeeze/main libhtml-template-perl 2.9-2 [65.9kB]
Fetched 23.4MB in 2s (11.3MB/s)
Preconfiguring packages …
Selecting previously deselected package mysql-common.
(Reading database … 20011 files and directories currently installed.)
Unpacking mysql-common (from …/mysql-common_5.1.56-0.dotdeb.1_all.deb) …
Selecting previously deselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from …/libnet-daemon-perl_0.43-1_all.deb) …
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from …/libplrpc-perl_0.2020-2_all.deb) …
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from …/libdbi-perl_1.612-1_i386.deb) …
Selecting previously deselected package libmysqlclient16.
Unpacking libmysqlclient16 (from …/libmysqlclient16_5.1.56-0.dotdeb.1_i386.deb) …
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from …/libdbd-mysql-perl_4.016-1_i386.deb) …
Selecting previously deselected package mysql-client-5.1.
Unpacking mysql-client-5.1 (from …/mysql-client-5.1_5.1.56-0.dotdeb.1_i386.deb) …
Selecting previously deselected package psmisc.
Unpacking psmisc (from …/psmisc_22.11-1_i386.deb) …
Selecting previously deselected package mysql-server-core-5.1.
Unpacking mysql-server-core-5.1 (from …/mysql-server-core-5.1_5.1.56-0.dotdeb.1_i386.deb) …
Processing triggers for man-db …
Setting up mysql-common (5.1.56-0.dotdeb.1) …
Selecting previously deselected package mysql-server-5.1.
(Reading database … 20428 files and directories currently installed.)
Unpacking mysql-server-5.1 (from …/mysql-server-5.1_5.1.56-0.dotdeb.1_i386.deb) …
Selecting previously deselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from …/libhtml-template-perl_2.9-2_all.deb) …
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from …/mysql-server_5.1.56-0.dotdeb.1_all.deb) …
Processing triggers for man-db …
Setting up libnet-daemon-perl (0.43-1) …
Setting up libplrpc-perl (0.2020-2) …
Setting up libdbi-perl (1.612-1) …
Setting up libmysqlclient16 (5.1.56-0.dotdeb.1) …
Setting up libdbd-mysql-perl (4.016-1) …
Setting up mysql-client-5.1 (5.1.56-0.dotdeb.1) …
Setting up psmisc (22.11-1) …
Setting up mysql-server-core-5.1 (5.1.56-0.dotdeb.1) …
Setting up mysql-server-5.1 (5.1.56-0.dotdeb.1) …
Stopping MySQL database server: mysqld.
110406 20:41:26 [Note] Plugin ‘FEDERATED’ is disabled.
110406 20:41:26 InnoDB: Initializing buffer pool, size = 8.0M
110406 20:41:26 InnoDB: Completed initialization of buffer pool
110406 20:41:26 InnoDB: Started; log sequence number 0 44233
110406 20:41:26 InnoDB: Starting shutdown…
110406 20:41:32 InnoDB: Shutdown completed; log sequence number 0 44233
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action “start” failed.
dpkg: error processing mysql-server-5.1 (–configure):
subprocess installed post-installation script returned error exit status 1
Setting up libhtml-template-perl (2.9-2) …
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.1; however:
Package mysql-server-5.1 is not configured yet.
dpkg: error processing mysql-server (–configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.1
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
zsh: exit 100 apt-get install mysql-server

Ce que j’ai déjà fait :

mettre skip-bdb dans le fichier /etc/mysql/my.cnf
commenté le dépot dotdeb et faire un apt-get update && apt-get install mysql-server-5.1

Mais toujours rien…

Merci pour votre aide

linux78 · Février 21, 2016, 1:27am

Bonjour,

Au vu des messages que dpkg affiche, tu as des problèmes de dépendances pour les paquets mysql-server et mysql-server-5.1 (essaye un apt-get -f install en tant que root pour voir si apt peut résoudre les dépendances manquantes).

newty · Février 21, 2016, 1:28am

Non désolé mais j’ai toujours le même problème

linux78 · Février 21, 2016, 1:28am

Hmmm… Fais un apt-get purge des paquets de mysql server puis réinstalle les (ça devrait résoudre le problème).

newty · Février 21, 2016, 1:28am

Comme c’est une VM proxmox, à chaque fois, je restaure la sauvegarde avant l’installation de mysql-server. Je fais donc un apt-get install direct.

Mais cela ne fonctionne pas quelque soit le dépot ou le fichier de conf mysqld

linux78 · Février 21, 2016, 1:28am

Fais voir ton fichier /etc/apt/sources.list actuel et aussi fais un apt-get update avant d’installer (si jamais il y avait des mises à jour à faire).

newty · Février 21, 2016, 1:28am

deb ftp.debian.org/debian/ squeeze main
deb-src ftp.debian.org/debian/ squeeze main
deb security.debian.org/ squeeze/updates main
deb-src security.debian.org/ squeeze/updates main

#deb packages.dotdeb.org squeeze all

Et j’ai bien fait l’update avant

linux78 · Février 21, 2016, 1:28am

Bien essaye d’installer le serveur mysql et le client mysql séparément (au cas où il y aurait des problèmes de conflit ou de dépendances non résolues).

newty · Février 21, 2016, 1:28am

Alors justement, là, j’ai juste fait un apt-get install mysql-server-5.1

linux78 · Février 21, 2016, 1:28am

Et qu’est ce que te sort dpkg comme messages (pas d’erreurs ou erreurs?)

newty · Février 21, 2016, 1:29am

J’ai ceci :

apt-get -f install mysql-server-5.1
Reading package lists… Done
Building dependency tree
Reading state information… Done
The following extra packages will be installed:
libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16
libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-common
mysql-server-core-5.1 psmisc
Suggested packages:
libipc-sharedcache-perl libterm-readkey-perl tinyca
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16
libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-common
mysql-server-5.1 mysql-server-core-5.1 psmisc
0 upgraded, 11 newly installed, 0 to remove and 21 not upgraded.
Need to get 23.4MB of archives.
After this operation, 55.6MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 ftp.debian.org squeeze/main mysql-common 5.1.49-3 [70.9kB]
Get:2 ftp.debian.org squeeze/main libnet-daemon-perl 0.43-1 [46.6kB]
Get:3 ftp.debian.org squeeze/main libplrpc-perl 0.2020-2 [36.0kB]
Get:4 ftp.debian.org squeeze/main libdbi-perl 1.612-1 [879kB]
Get:5 ftp.debian.org squeeze/main libmysqlclient16 5.1.49-3 [1935kB]
Get:6 ftp.debian.org squeeze/main libdbd-mysql-perl 4.016-1 [138kB]
Get:7 ftp.debian.org squeeze/main mysql-client-5.1 5.1.49-3 [9605kB]
Get:8 ftp.debian.org squeeze/main psmisc 22.11-1 [122kB]
Get:9 ftp.debian.org squeeze/main mysql-server-core-5.1 5.1.49-3 [3937kB]
Get:10 ftp.debian.org squeeze/main mysql-server-5.1 5.1.49-3 [6528kB]
Get:11 ftp.debian.org squeeze/main libhtml-template-perl 2.9-2 [65.9kB]
Fetched 23.4MB in 22s (1029kB/s)
Preconfiguring packages …
Selecting previously deselected package mysql-common.
(Reading database … 20011 files and directories currently installed.)
Unpacking mysql-common (from …/mysql-common_5.1.49-3_all.deb) …
Selecting previously deselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from …/libnet-daemon-perl_0.43-1_all.deb) …
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from …/libplrpc-perl_0.2020-2_all.deb) …
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from …/libdbi-perl_1.612-1_i386.deb) …
Selecting previously deselected package libmysqlclient16.
Unpacking libmysqlclient16 (from …/libmysqlclient16_5.1.49-3_i386.deb) …
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from …/libdbd-mysql-perl_4.016-1_i386.deb) …
Selecting previously deselected package mysql-client-5.1.
Unpacking mysql-client-5.1 (from …/mysql-client-5.1_5.1.49-3_i386.deb) …
Selecting previously deselected package psmisc.
Unpacking psmisc (from …/psmisc_22.11-1_i386.deb) …
Selecting previously deselected package mysql-server-core-5.1.
Unpacking mysql-server-core-5.1 (from …/mysql-server-core-5.1_5.1.49-3_i386.de b) …
Processing triggers for man-db …
Setting up mysql-common (5.1.49-3) …
Selecting previously deselected package mysql-server-5.1.
(Reading database … 20430 files and directories currently installed.)
Unpacking mysql-server-5.1 (from …/mysql-server-5.1_5.1.49-3_i386.deb) …
Selecting previously deselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from …/libhtml-template-perl_2.9-2_all.deb) . …
Processing triggers for man-db …
Setting up libnet-daemon-perl (0.43-1) …
Setting up libplrpc-perl (0.2020-2) …
Setting up libdbi-perl (1.612-1) …
Setting up libmysqlclient16 (5.1.49-3) …
Setting up libdbd-mysql-perl (4.016-1) …
Setting up mysql-client-5.1 (5.1.49-3) …
Setting up psmisc (22.11-1) …
Setting up mysql-server-core-5.1 (5.1.49-3) …
Setting up mysql-server-5.1 (5.1.49-3) …
Stopping MySQL database server: mysqld.
110408 12:57:31 [Note] Plugin ‘FEDERATED’ is disabled.
110408 12:57:31 InnoDB: Started; log sequence number 0 44233
110408 12:57:31 InnoDB: Starting shutdown…
110408 12:57:36 InnoDB: Shutdown completed; log sequence number 0 44233
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action “start” failed.
dpkg: error processing mysql-server-5.1 (–configure):
subprocess installed post-installation script returned error exit status 1
Setting up libhtml-template-perl (2.9-2) …
Errors were encountered while processing:
mysql-server-5.1
E: Sub-process /usr/bin/dpkg returned an error code (1)
zsh: exit 100 apt-get -f install mysql-server-5.1

linux78 · Février 21, 2016, 1:29am

Hmm… C’est bizarre qu’il n’arrive pas à le configurer (voici ce que me dit apt-cache sur le paquet mysql-server-5.1):

root@debian:~# apt-cache depends mysql-server
mysql-server
  Dépend: mysql-server-5.1
root@debian:~# apt-cache depends mysql-server-5.1
mysql-server-5.1
  Dépend: mysql-client-5.1
  Dépend: libdbi-perl
  Dépend: perl
  Dépend: libc6
  Dépend: libgcc1
  Dépend: libmysqlclient16
  Dépend: libstdc++6
  Dépend: zlib1g
 |Dépend: debconf
  Dépend: <debconf-2.0>
    cdebconf
    debconf
  Dépend: psmisc
  Dépend: passwd
  Dépend: lsb-base
  Dépend: mysql-server-core-5.1
  Pré-Dépend: mysql-common
  Pré-Dépend: adduser
  Pré-Dépend: debconf
  Suggère: tinyca
  Recommande: <mailx>
    heirloom-mailx
    mailutils
    bsd-mailx
  Recommande: libhtml-template-perl

Or mysql-server-5.1 est en conflit avec ces paquets:
Est en conflit avec: mysql-server
Est en conflit avec: <mysql-server-4.1>
Remplace: libmysqlclient-dev
Remplace: mysql-server
Remplace: <mysql-server-5.0>
mysql-server-5.1

Et dpkg a tenté d’installer mysql-server (comme tu l’as mentionné dans ton premier post) qui est en conflit avec ce paquet qu’il remplace.

newty · Février 21, 2016, 1:29am

Franchement, j’ai tout essayé et je désespère… Peut être prendre un autre template proxmox de debian 6 ?

newty · Février 21, 2016, 1:29am

Bon, c’est bon j’ai trouvé pourquoi ^^
Il n’y avait pas la loopback

linux78 · Février 21, 2016, 1:29am

Ah l’interface lo (essentielle pour tout ce qui utilise le pc local (localhost)).
Tu vas donc pouvoir marquer le problème comme résolu

newty · Février 21, 2016, 1:29am

Fait

Merci en tout cas pour ton aide !

lol · Février 21, 2016, 1:29am

Salut,

Noooon, pas résolu dans le titre! La “coche verte” suffit.
Je m’en occupe. Merci.