Distribution EOLE

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.