Project

General

Profile

Scénario #31424

Bareos : le script make_catalog_backup génère une erreur 'Access denied' lors du mysqldump sur un serveur mysql 5.7.

Added by Yoni Baude 4 months ago. Updated 3 months ago.

Status:
Terminé (Sprint)
Priority:
Normal
Assigned To:
Category:
-
Start date:
12/15/2020
Due date:
01/06/2021
% Done:

100%

Story points:
2.0
Remaining (hours):
0.00 hour
Velocity based estimate:
Release:
Release relationship:
Auto

Description

Bonjour,

Suite à la mise à jour de la version mysql 5.7 du mois de juillet, la commande /usr/share/eole/bareos/make_catalog_backup -n bareos -u bareos -a localhost -t mysql
génère une erreur 'Access denied' lors du mysqldump.

Log baréos:

> 2020-12-12T14:01:20.412579+01:00 horus.0140096d.rne.ac-caen.fr bareos-dir: 127.0.0.1-dir JobId 6: shell command: run BeforeJob "sudo /usr/share/eole/sbin/bareosmount.py --mount" 
> 2020-12-12T14:01:21.005435+01:00 horus.0140096d.rne.ac-caen.fr bareos-dir: 127.0.0.1-dir JobId 6: BeforeJob: Montage OK
> 2020-12-12T14:01:21.023929+01:00 horus.0140096d.rne.ac-caen.fr bareos-dir: 127.0.0.1-dir JobId 6: shell command: run BeforeJob "/usr/share/eole/bareos/make_catalog_backup -n bareos -u bareos -a localhost -t mysql" 
> 2020-12-12T14:01:21.180136+01:00 horus.0140096d.rne.ac-caen.fr bareos-dir: 127.0.0.1-dir JobId 6: BeforeJob: mysqldump: [Warning] Using a password on the command line interface can be insecure.
> 2020-12-12T14:01:21.217744+01:00 horus.0140096d.rne.ac-caen.fr bareos-dir: 127.0.0.1-dir JobId 6: BeforeJob: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tab
> 2020-12-12T14:01:21.218456+01:00 horus.0140096d.rne.ac-caen.fr bareos-dir: 127.0.0.1-dir JobId 6: BeforeJob: lespaces
> 2020-12-12T14:01:21.434314+01:00 horus.0140096d.rne.ac-caen.fr bareos-dir: 127.0.0.1-dir JobId 6: Start Backup JobId 6, Job=BackupCatalog.2020-12-12_13.49.57_19
> 2020-12-12T14:01:21.515310+01:00 horus.0140096d.rne.ac-caen.fr bareos-dir: 127.0.0.1-dir JobId 6: Pruning oldest volume "127.0.0.1-dir-catalog-0012" 
> 

Des solutions sont proposés sur ce lien : https://anothercoffee.net/how-to-fix-the-mysqldump-access-denied-process-privilege-error/

Quelle est votre préconisation ?

Bien à vous,
Yoni

En théorie à corriger sur EOLE >= 2.6.0
La sauvegarde devrait sortir en erreur sur ce genre de soucis.


Subtasks

Tâche #31444: Etude du problèmeFerméMatthieu Lamalle

History

#1 Updated by Gilles Grandgérard 4 months ago

Cela fait suite à un correctif de sécurité : https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-31.html#mysqld-5-7-31-security

Nous devons adapter notre configuration Mysql

#2 Updated by Gilles Grandgérard 4 months ago

  • Parent task set to #31415

#3 Updated by Joël Cuissinat 4 months ago

  • Parent task deleted (#31415)

#4 Updated by Joël Cuissinat 4 months ago

  • Tracker changed from Tâche to Scénario
  • Due date set to 01/08/2021

#5 Updated by Joël Cuissinat 4 months ago

  • Target version changed from sprint 2020 52-01 Equipe MENSR (Noël) to Prestation Cadoles MEN 52-01 (Noël)
  • Release set to EOLE 2.6.2.2
  • Story points set to 2.0

#6 Updated by Joël Cuissinat 4 months ago

  • Description updated (diff)

#7 Updated by Joël Cuissinat 4 months ago

  • Description updated (diff)

#8 Updated by Matthieu Lamalle 4 months ago

  • Assigned To set to Matthieu Lamalle

#9 Updated by Emmanuel GARETTE 3 months ago

  • Status changed from Nouveau to En cours

#10 Updated by Emmanuel GARETTE 3 months ago

  • Status changed from En cours to Résolu

#11 Updated by Fabrice Barconnière 3 months ago

  • Status changed from Résolu to Terminé (Sprint)

#12 Updated by Joël Cuissinat 3 months ago

  • Status changed from Terminé (Sprint) to Nouveau

#13 Updated by Joël Cuissinat 3 months ago

  • Status changed from Nouveau to En cours

#14 Updated by Fabrice Barconnière 3 months ago

  • Status changed from En cours to Terminé (Sprint)

Also available in: Atom PDF