Project

General

Profile

Scénario #24573

EOLE 2.7.0 : vérifier la configuration de l'authentification root MySQL

Added by Joël Cuissinat over 4 years ago. Updated over 4 years ago.

Status:
Terminé (Sprint)
Priority:
Normal
Assigned To:
-
Category:
-
Start date:
08/27/2018
Due date:
09/14/2018
% Done:

100%

Spent time:
(Total: 1.50 h)
Story points:
2.0
Remaining (hours):
0.00 hour
Velocity based estimate:
Release:
Release relationship:
Auto

Description

Erreur au reconfigure avec Eolebase 2.7.0 + eole-mysql

TODO : vérifier en 2.6.2 :

run-parts: executing /usr/share/eole/postservice/00-mysql-native-password reconfigure
/usr/share/eole/postservice/00-mysql-native-password: ligne 6 : [: = : opérateur unaire attendu

Subtasks

Tâche #24714: Mise en place du patchFerméLaurent Flori


Related issues

Related to eole-mysql - Scénario #21688: Gérer les problèmes de connexion à phpMyAdmin avec le compte root Terminé (Sprint) 02/16/2018 03/09/2018

History

#1 Updated by Joël Cuissinat over 4 years ago

  • Related to Scénario #21688: Gérer les problèmes de connexion à phpMyAdmin avec le compte root added

#2 Updated by Joël Cuissinat over 4 years ago

Sorties Eolebase 2.7.0 (déjà instancié) :

root@eolebase:~# mysql --batch -e 'use mysql;select plugin from user where user="root" and plugin="auth_socket";'
root@eolebase:~# echo $?
0
root@eolebase:~# mysql --batch -e 'use mysql;select plugin from user where user="root";'
plugin
mysql_native_password

Sortie Horus 2.6.2 instancié :

root@horus:~# mysql --batch -e 'use mysql;select plugin from user where user="root" and plugin="auth_socket";'
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
root@horus:~# echo $?
1

#3 Updated by Joël Cuissinat over 4 years ago

  • Start date deleted (07/26/2018)

#4 Updated by Joël Cuissinat over 4 years ago

  • Parent task deleted (#24432)

#5 Updated by Joël Cuissinat over 4 years ago

  • Tracker changed from Tâche to Demande
  • Target version deleted (sprint 2018 29-34 Equipe MENSR (été 2018))

#6 Updated by Joël Cuissinat over 4 years ago

Voila une proposition de patch mais ce qui est étrange, c'est qu'on obtient pas le même résultat selon que les paquets sont installés avant instance (Horus) ou après (Eolebase) :

diff --git a/postservice/00-mysql-native-password b/postservice/00-mysql-native-password
index cd9f77b..b6e7146 100755
--- a/postservice/00-mysql-native-password
+++ b/postservice/00-mysql-native-password
@@ -3,7 +3,7 @@
 plugin=$(mysql --batch -e 'use mysql;select plugin from user where user="root" and plugin="auth_socket";' 2>/dev/null)
 [ $? -ne 0 ] && exit 0

-if [ ${plugin##plugin} = "auth_socket" ];then
+if [ "${plugin##plugin}" = "auth_socket" ];then
     echo "Modification du plugin d'authentification pour l'utilisateur root";
     mysql -e 'use mysql;update user set plugin="mysql_native_password" where user="root";flush privileges;'
 fi

#7 Updated by Joël Cuissinat over 4 years ago

  • Tracker changed from Demande to Scénario
  • Subject changed from EOLE 2.7.0 : Erreur au reconfigure avec Eolebase + MySQL to EOLE 2.7.0 : vérifier la configuration de l'authentification root MySQL
  • Description updated (diff)
  • Due date set to 09/14/2018
  • Target version set to sprint 2018 35-37 Equipe MENSR
  • Start date set to 08/27/2018
  • Release set to EOLE 2.7.0
  • Story points set to 2.0

#8 Updated by Scrum Master over 4 years ago

  • Status changed from Nouveau to Terminé (Sprint)

Also available in: Atom PDF