Tâche #17078: Les tables SQL ne sont pas toutes créées - eole-bareos - Ensemble Ouvert Libre Évolutif

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:

Emmanuel GARETTE

Target version:

Distribution EOLE - sprint 2016 36-38 - Équipe MENSR

Start date:

09/13/2016

Due date:

% Done:

100%

Estimated time:

4.00 h

Spent time:

4.00 h

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