Project

General

Profile

Tâche #15779

eole-mysql - Scénario #15762: Mettre à niveau la configuration de MySQL sur 2.6

Faire fonctionner la modification du mot de passe root de MySQL sur 2.6

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

Status:
Fermé
Priority:
Normal
Assigned To:
Joël Cuissinat
Target version:
Distribution EOLE - sprint 2016 19-21 - Equipe MENESR
Start date:
04/05/2016
Due date:
% Done:

100%

Estimated time:
2.00 h
Spent time:
3.75 h
Remaining (hours):
0.0

Description

root@seshat:~# mysql_pwd.py 
## Réinitialisation des mots de passe Mysql ##

Nouveau mot de passe root mysql : toto21
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'field list'

=> http://stackoverflow.com/questions/30692812/mysql-user-db-does-not-have-password-columns-installing-mysql-on-osx

Associated revisions

Revision c72257cc (diff)
Added by Joël Cuissinat over 7 years ago

Les mots de passe sont désormais stockés dans `authentication_string`

  • scripts/mysql_pwd.py : `password` => `authentication_string`

Ref: #15779 @30m

Revision d973b177 (diff)
Added by Laurent Flori over 7 years ago

Suppression des warnings à la mise a jour des paswords

Ajout du fichier /etc/debian/debian.cnf lors de la modification
du mot de passe des applications web

ref: #15779 @1h

Revision 0512245d (diff)
Added by Joël Cuissinat over 7 years ago

Utilisation de mysql dans le conteneur mysql

Ref: #15779 @30m

Revision 20e97d51 (diff)
Added by Joël Cuissinat over 7 years ago

Utilisation de mysql dans le conteneur mysql (2)

Ref: #15779 @40m

Revision c81f49b9 (diff)
Added by Joël Cuissinat over 7 years ago

Simplification du script mysql_add.py

Ref: #15779 @20m

History

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

  • Project changed from eole-mysql to eolesql

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

  • % Done changed from 0 to 30

Les scripts génèrent également beaucoup de warning...

root@ubuntu:~# mysql_pwd.py 
## Réinitialisation des mots de passe Mysql ##

Nouveau mot de passe root mysql : tototo

Voulez-vous que les autres mots de passe soient modifiés ? [oui/non]
[non] : o
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.

#3 Updated by Klaas TJEBBES over 7 years ago

À propos des warnings

mysql: [Warning] Using a password on the command line interface can be insecure.

il faut utiliser un fichier de conf contenant le mot de passe plutôt que le passer sur la ligne de commande :
db=_mysql.connect(host="outhouse",db="thangs",read_default_file="~/.my.cnf")

voir http://mysql-python.sourceforge.net/MySQLdb.html#some-mysql-examples

#4 Updated by Laurent Flori over 7 years ago

  • Status changed from Nouveau to En cours

#5 Updated by Laurent Flori over 7 years ago

  • Assigned To set to Laurent Flori

#6 Updated by Laurent Flori over 7 years ago

  • Remaining (hours) changed from 2.0 to 0.0
  • Remaining (hours) changed from 0.0 to 0.5

#7 Updated by Laurent Flori over 7 years ago

  • Status changed from En cours to Résolu

#8 Updated by Lionel Morin over 7 years ago

  • % Done changed from 30 to 100
  • Remaining (hours) changed from 0.5 to 0.0

#9 Updated by Lionel Morin over 7 years ago

  • Status changed from Résolu to Fermé

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

  • Status changed from Fermé to En cours

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

Le commit d973b177 n'est pas compatible avec le mode conteneur !

mysql: [ERROR] Could not open required defaults file: /etc/mysql/debian.cnf
mysql: [ERROR] Fatal error in defaults handling. Program aborted!

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

  • Assigned To changed from Laurent Flori to Joël Cuissinat
  • Remaining (hours) changed from 0.0 to 2.0

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

  • Status changed from En cours to Résolu

#14 Updated by Lionel Morin over 7 years ago

  • Status changed from Résolu to En cours

Testé sur Scribe => OK
Testé sur Amonecole => on peut se connecter à mysql quelque soit le mot de passe => réouverture

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

  • Status changed from En cours to Fermé
  • Remaining (hours) changed from 2.0 to 0.0

OK sur AmonEcole :

root@amonecole:~# mysql_pwd.py eole21 no
## Réinitialisation des mots de passe Mysql ##
root@amonecole:~# mysql -h192.0.2.50 -ptoto
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'192.0.2.1' (using password: YES)
root@amonecole:~# mysql -h192.0.2.50 -peole21
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 76
Server version: 5.7.12-0ubuntu1 (Ubuntu)

Copyright (c) 2000, 2016, 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>

Also available in: Atom PDF