Project

General

Profile

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 2 years ago. Updated over 1 year ago.

Status:
Fermé
Priority:
Normal
Assigned To:
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 1 year ago

utilisation no-tablespaces lors du mysqldump ref #31444

Revision 43e433e6 (diff)
Added by Matthieu Lamalle over 1 year ago

utilisation no-tablespaces lors du mysqldump ref #31444

History

#1 Updated by Matthieu Lamalle almost 2 years ago

  • Assigned To set to Matthieu Lamalle

#2 Updated by Matthieu Lamalle almost 2 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.

#3 Updated by Matthieu Lamalle almost 2 years ago

  • Status changed from Nouveau to En cours

#4 Updated by Matthieu Lamalle over 1 year ago

  • Status changed from En cours to Résolu

#5 Updated by Emmanuel GARETTE over 1 year ago

  • % Done changed from 0 to 100

#6 Updated by Fabrice Barconnière over 1 year ago

  • Status changed from Résolu to Fermé
  • Remaining (hours) set to 0.0

#7 Updated by Fabrice Barconnière over 1 year ago

  • Status changed from Fermé to En cours
  • Estimated time set to 0.00 h

#9 Updated by Matthieu Lamalle over 1 year ago

  • Status changed from En cours to Résolu

#10 Updated by Fabrice Barconnière over 1 year ago

  • Status changed from Résolu to Fermé

Also available in: Atom PDF