Project

General

Profile

Tâche #30276

Scénario #30256: Traitement express MEN (25-27)

Faire évoluer le code SQL d'ecoStations pour EOLE 2.8.0

Added by Joël Cuissinat 4 months ago. Updated 3 months ago.

Status:
Fermé
Priority:
Normal
Assigned To:
Start date:
06/09/2020
Due date:
% Done:

100%

Remaining (hours):
0.0

Description

La base est-elle toujours utilisée ?

# Ajout de la base de données ecostations
Traceback (most recent call last):
  File "/usr/share/eole/sbin/gen_databases.py", line 177, in <module>
    main()
  File "/usr/share/eole/sbin/gen_databases.py", line 168, in main
    gen_databases(DB_TO_GEN)
  File "/usr/share/eole/sbin/gen_databases.py", line 94, in gen_databases
    db_conf['pregen'](db_handler)
  File "/usr/share/eole/applications/gen/ecostations.py", line 27, in pregen_func
    db_handler.simple_query("GRANT ALL PRIVILEGES ON ecoStations.* TO ecostations@localhost IDENTIFIED BY 'ecostations';")
  File "/usr/lib/python3/dist-packages/eolesql/db_layer.py", line 60, in simple_query
    return self.insert(query_str)
  File "/usr/lib/python3/dist-packages/eolesql/db_layer.py", line 67, in insert
    self.db.query(query_str)
MySQLdb._exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'ecostations'' at line 1")

Associated revisions

Revision cbf7608f (diff)
Added by Joël Cuissinat 3 months ago

Compatibilité MySQL 2.7/2.8

Ref: #30276

History

#1 Updated by Joël Cuissinat 4 months ago

  • Parent task changed from #30275 to #30256

#2 Updated by Joël Cuissinat 3 months ago

  • Status changed from Nouveau to En cours

#3 Updated by Joël Cuissinat 3 months ago

  • Description updated (diff)
  • Assigned To set to Joël Cuissinat

#4 Updated by Joël Cuissinat 3 months ago

Comme le changement de version de MySQL coïncide avec celui de python, je propose de m'appuyer sur cette différence afin de conserver un seul paquet pour les versions AD.

#5 Updated by Joël Cuissinat 3 months ago

=> paquet eole-ecostations 2.7.1-4 volontairement recompilé en eole-2.7-unstable puis testé en 2.7.1, copié dans eole-2.8-unstable et supprimé de eole-2.7-unstable :=

#6 Updated by Joël Cuissinat 3 months ago

  • Status changed from En cours to Résolu
  • % Done changed from 0 to 100

#7 Updated by Fabrice Barconnière 3 months ago

Le paquet est bien installé sur un Scribe 2.8.0 daily.
Je ne peux pas tester son fonctionnement, Scribe ne s'instancie pas.

#8 Updated by Fabrice Barconnière 3 months ago

  • Status changed from Résolu to Fermé
  • Remaining (hours) set to 0.0

Also available in: Atom PDF