Tâche #31444: Etude du problème - Distribution EOLE - Ensemble Ouvert Libre Évolutif

Tâche #31444

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.

Etude du problème

Added by Matthieu Lamalle almost 3 years ago. Updated over 2 years ago.

Status:

Fermé

Priority:

Normal

Assigned To:

Matthieu Lamalle

Target version:

Prestation Cadoles MEN 52-01 (Noël)

Start date:

12/15/2020

Due date:

% Done:

100%

Estimated time:

0.00 h

Remaining (hours):

0.0

Associated revisions

Revision dec37fba (diff)
Added by Matthieu Lamalle over 2 years ago

utilisation no-tablespaces lors du mysqldump ref #31444

Revision 43e433e6 (diff)
Added by Matthieu Lamalle over 2 years ago

utilisation no-tablespaces lors du mysqldump ref #31444

History

#1 Updated by Matthieu Lamalle almost 3 years ago

Assigned To set to Matthieu Lamalle

#2 Updated by Matthieu Lamalle almost 3 years ago

Après tests, la commande retourne bien une erreur, mais le fichier cible est pourtant complet.

root@scribe:~# rm -f /var/lib/bareos/bareos.sql
root@scribe:~# /usr/share/eole/bareos/make_catalog_backup -n bareos -u bareos -a localhost -t mysql
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
root@scribe:~# tail -n 10 /var/lib/bareos/bareos.sql

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-12-18 12:23:38
root@scribe:~#

Comme les informations de tablespaces ne semblent pas utilisés, il est préférable d'utiliser l'option --no-tablespaces avec la commande mysqldump.