Project

General

Profile

Tâche #15036

Scénario #15042: portage glpi 2.5.2

Le template "glpi-update.sql" n'est pas compatible avec le schéma de la base de données glpi

Added by Joël Cuissinat about 5 years ago. Updated about 5 years ago.

Status:
Fermé
Priority:
Normal
Assigned To:
-
Start date:
02/15/2016
Due date:
% Done:

100%

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

Description

CreoleSet glpi_cas_auth oui + reconfigure :

run-parts: executing /usr/share/eole/posttemplate/01-eoledb reconfigure
Start Upstart service mysql                                                                                                                                                                                 [  OK  ]
GLPI : 
    >>> Passwords     [OK]
    >>> Create      [NA]
    >>> Update 
Traceback (most recent call last):
  File "/usr/bin/eole_db_gen", line 125, in <module>
    main()
  File "/usr/bin/eole_db_gen", line 115, in main
    if conn.update_db():
  File "/usr/lib/python2.7/dist-packages/eoledb/eoledbmysql.py", line 169, in update_db
    self.cursor.execute(elm)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'cas_host' in 'field list'")
Stop Upstart service mysql 

Associated revisions

Revision b56208df (diff)
Added by Benjamin Bohard about 5 years ago

Le script de configuration de la base doit être compatible avec la version 0.85

Ref #15036

Revision 1f8ca10d (diff)
Added by Benjamin Bohard about 5 years ago

Rendre compatible avec tous les modules.

Ref #15036

Revision e4b2d8aa (diff)
Added by Benjamin Bohard about 5 years ago

Utilisation de tables obsolètes dans un script de mise à jour.

Ref #15036

Revision 578a04af (diff)
Added by Benjamin Bohard about 5 years ago

Utiliser des variables pour les paramètres de mysql et l'emplacement des fichiers.

Ref #15036

Revision a79bd385 (diff)
Added by Benjamin Bohard about 5 years ago

Mise à jour des scripts et déplacement du script de mise à jour de la base de données.

Ref #15036

Revision 7af9e319 (diff)
Added by Benjamin Bohard about 5 years ago

Copier le script glpi-update.sql au bon endroit.

Ref #15036

Revision d44ea1b9 (diff)
Added by Benjamin Bohard about 5 years ago

Correction de la valeur d'une nouvelle variable de configuration glpi.

Ref #15036

History

#1 Updated by Thierry Bertrand about 5 years ago

  • Target version set to sprint 2016 07-09 - Equipe PNE-SR
  • Parent task set to #15042

#2 Updated by Nicolas PETITOT about 5 years ago

Le fichier /usr/share/eole/creole/distrib/glpi-update.sql n'était pas à jour.
Je l'ai corrigé pour qu'il corresponde au nouveau schéma de BD (vu avec Thierry BERTRAND)

#3 Updated by Benjamin Bohard about 5 years ago

  • Status changed from Nouveau to Résolu
  • % Done changed from 0 to 100
  • Estimated time set to 2.00 h
  • Remaining (hours) set to 0.25

#4 Updated by Thierry Bertrand about 5 years ago

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

Also available in: Atom PDF