Project

General

Profile

Tâche #17078

Scénario #16747: Faire fonctionner Bareos pour EOLE 2.6.0

Les tables SQL ne sont pas toutes créées

Added by Emmanuel GARETTE about 7 years ago. Updated about 7 years ago.

Status:
Fermé
Priority:
Normal
Assigned To:
Start date:
09/13/2016
Due date:
% Done:

100%

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

Description

root@scribe:~# /usr/share/eole/sbin/bareosregen.sh
La régénération du catalogue de la sauvegarde va écraser l'ancienne base, confirmez-vous ? [oui/non]
[non] : oui

## Régénération du catalogue Bareos##
Stop Systemd service bareos-dir                                                                                                                                         [  OK  ]
Stop Systemd service bareos-sd                                                                                                                                          [  OK  ]
## Réinitialisation des mots de passe Mysql ##
Dropping mysql database
mysql: [Warning] Using a password on the command line interface can be insecure.
Drop of bareos database succeeded.
Creating mysql database
mysql: [Warning] Using a password on the command line interface can be insecure.
Creating of bareos database succeeded.
Making mysql tables
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1067 (42000) at line 88: Invalid default value for 'CleaningDate'
ERROR 1067 (42000) at line 107: Invalid default value for 'SchedTime'
ERROR 1067 (42000) at line 140: Invalid default value for 'SchedTime'
ERROR 1067 (42000) at line 180: Invalid default value for 'Date'
ERROR 1067 (42000) at line 192: Invalid default value for 'CreateTime'
ERROR 1067 (42000) at line 215: Invalid default value for 'FirstWritten'
ERROR 1067 (42000) at line 310: Invalid default value for 'Time'
ERROR 1171 (42000) at line 379: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
Creation of Bareos MySQL tables succeeded.
## Réinitialisation des mots de passe Mysql ##
Granting mysql tables
mysql: [Warning] Using a password on the command line interface can be insecure.
Privileges for user bareos granted ON database bareos.
Régénération du catalogue terminée
Suppression des anciens rapports d'état
Start Systemd service bareos-dir                                                                                                                                        [  OK  ]
Start Systemd service bareos-sd                                                                                                                                         [  OK  ]

Related issues

Related to Distribution EOLE - Tâche #19562: Appliquer les changements requis au fichier sql de création des bases de données Fermé 02/21/2017

Associated revisions

Revision 5b4149bc (diff)
Added by Emmanuel GARETTE about 7 years ago

corriger la base de donnée pour mysql 5.7 (ref #17078 @3h)

History

#1 Updated by Emmanuel GARETTE about 7 years ago

  • % Done changed from 0 to 100
  • Remaining (hours) changed from 4.0 to 0.25

#2 Updated by Scrum Master about 7 years ago

  • Status changed from En cours to Résolu

#3 Updated by Laurent Flori about 7 years ago

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

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

  • Related to Tâche #19562: Appliquer les changements requis au fichier sql de création des bases de données added

Also available in: Atom PDF