Project

General

Profile

Tâche #15795

Scénario #16264: Étudier le dysfonctionnement de Bareos + MySQL sur EOLE 2.6

Erreurs à l'installation des bases MySQL bareos sur 2.6

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

Status:
Fermé
Priority:
Normal
Assigned To:
Start date:
04/06/2016
Due date:
% Done:

100%

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

Description

## Réinitialisation des mots de passe Mysql ##
Warning: failed to get "dbname" from config, using default value "bareos", see /tmp/bareos-config.3982.log
Warning: failed to get "dbuser" from config, using default value "bareos", see /tmp/bareos-config.3982.log
Warning: failed to get "dbdriver" from config, see /tmp/bareos-config.3982.log
Creating mysql database
mysql: [Warning] Using a password on the command line interface can be insecure.
Creating of bareos database succeeded.
Warning: failed to get "dbname" from config, using default value "bareos", see /tmp/bareos-config.4018.log
Warning: failed to get "dbuser" from config, using default value "bareos", see /tmp/bareos-config.4018.log
Warning: failed to get "dbdriver" from config, see /tmp/bareos-config.4018.log
Making mysql tables
Warning: failed to get "dbpassword" from config, see /tmp/bareos-config.4018.log
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 ##
Warning: failed to get "dbname" from config, using default value "bareos", see /tmp/bareos-config.4075.log
Warning: failed to get "dbuser" from config, using default value "bareos", see /tmp/bareos-config.4075.log
Warning: failed to get "dbpassword" from config, see /tmp/bareos-config.4075.log
Warning: failed to get "dbdriver" from config, see /tmp/bareos-config.4075.log
Granting mysql tables
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1133 (42000) at line 2: Can't find any matching row in the user table
ERROR 1133 (42000) at line 3: Can't find any matching row in the user table
ERROR 1133 (42000) at line 4: Can't find any matching row in the user table
Privileges for user bareos granted ON database bareos.
Régénération du catalogue terminée
Suppression des anciens rapports d'état
Stop Systemd service mysql 

Related issues

Related to eole-bareos - Scénario #16747: Faire fonctionner Bareos pour EOLE 2.6.0 Terminé (Sprint) 09/06/2016 09/23/2016
Duplicated by eole-bareos - Tâche #16521: Résoudre SegFault 'libbareoscats-mysql.so' sur EOLE 2.6.0 Fermé 06/16/2016 07/08/2016

History

#1 Updated by Laurent Flori over 3 years ago

  • Status changed from Nouveau to En cours

#2 Updated by Laurent Flori over 3 years ago

  • Description updated (diff)
  • Assigned To set to Laurent Flori

#3 Updated by Joël Cuissinat over 3 years ago

  • Status changed from En cours to Nouveau
  • Assigned To deleted (Laurent Flori)
  • Parent task changed from #15762 to #16264

#4 Updated by Klaas TJEBBES over 3 years ago

  • Assigned To set to Klaas TJEBBES

#5 Updated by Klaas TJEBBES over 3 years ago

root@horus26k:~# cat /tmp/bareos-config.6103.log
21-juin 14:35 dbcheck JobId 0: Error: Unable to load shared library: /usr/lib/bareos/backends/libbareoscats-mysql.so ERR=<NULL>
21-juin 14:35 dbcheck ABORTING due to ERROR
Unable to load any shared library for libbareoscats-mysql.so
Error: executing /usr/sbin/bareos-dbcheck -B -c /etc/bareos/bareos-dir.conf

Le bug est connu chez bareos et corrigé dans certaines versions mais pas celle d'ubuntu (bareos 14.2.6)

https://groups.google.com/forum/#!topic/bareos-users/7_bTpp1DKCk

Il existe des paquets pour Debian 8 :

http://download.bareos.org/bareos/release/15.2/Debian_8.0/

mais ils dépendent d'un paquet qu'Ubuntu n'a pas :

Les paquets suivants contiennent des dépendances non satisfaites :
 bareos-database-mysql : Dépend: libmysqlclient18 (>= 5.5.24+dfsg-1) mais il n'est pas installable

# apt install libmysqlclient18
E: Le paquet « libmysqlclient18 » n'a pas de version susceptible d'être installée

# apt search  libmysqlclient
libmysqlclient20/xenial-security,xenial-updates,now 5.7.12-0ubuntu1 amd64  [installé, automatique]
  Bibliothèque cliente de la base de données MySQL

Signalement launchpad.
https://bugs.launchpad.net/ubuntu/+source/bareos/+bug/1595105

#6 Updated by Klaas TJEBBES over 3 years ago

  • Status changed from Nouveau to En cours

#7 Updated by Scrum Master over 3 years ago

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

Rapport de bug ouvert chez Ubuntu.
Scénario de suivi créé (#16747).

#8 Updated by Daniel Dehennin over 3 years ago

  • % Done changed from 0 to 100

Also available in: Atom PDF