Hi,
We are trying to generate a backup manually from a server in Prod and the operation is complited with error in backing up database.
We have nagios xi version 5.7.5 and there is the output of the script backup-xi.sh:
# sh backup_xi.sh
Backing up Nagios Core...
tar: Suppression de « / » au début des noms des membres
tar: /usr/local/nagios/share/perfdata/DCPRPSGMANDATI1.baridad.bamnet.ma/Memory_Usage.rrd : fichier modifié pendant sa lecture
tar: /usr/local/nagios/share/perfdata/DCPRPSGMANDATI1.baridad.bamnet.ma : fichier modifié pendant sa lecture
tar: /usr/local/nagios/var/rw/nagios.qh : socket ignorée
tar: /usr/local/nagios/var : fichier modifié pendant sa lecture
Backing up Nagios XI...
tar: Suppression de « / » au début des noms des membres
tar: /usr/local/nagiosxi/var/sysstat.log : fichier modifié pendant sa lecture
tar: /usr/local/nagiosxi/var : fichier modifié pendant sa lecture
Backing up MRTG...
tar: Suppression de « / » au début des noms des membres
Backing up the SNMP directories
tar: Suppression de « / » au début des noms des membres
tar: Suppression de « / » au début des noms des membres
Backing up NRDP...
tar: Suppression de « / » au début des noms des membres
Backing up Nagvis...
tar: Suppression de « / » au début des noms des membres
Backing up nagios user home dir...
tar: Suppression de « / » au début des noms des membres
Backing up MySQL databases...
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
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
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
Backing up cronjobs for Apache...
Backing up logrotate config files...
Backing up Apache config files...
Compressing backup...
===============
BACKUP COMPLETE
===============
Backup stored in /store/backups/nagiosxi/1746782683.tar.gz
Can help us?
Backup complited with errors
Re: Backup complited with errors
It seems the DB user doing the dump doesn't have permissions needed.
Do a web search on the error for more info.
Do a web search on the error for more info.
-
rachellela
- Posts: 1
- Joined: Mon May 19, 2025 11:50 pm
Re: Backup complited with errors
Your backup completed, but with warnings and partial MySQL backup failures due to missing privileges.
Issue: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation'
Fix:
Grant the required privilege to the MySQL user used in the script:
GRANT PROCESS ON *.* TO 'nagiosxi'@'localhost';
FLUSH PRIVILEGES;
(Replace 'nagiosxi' with the actual MySQL user if different.)
Other warnings (e.g., "file modified during read"):
These are normal if services are active during backup and can generally be ignored. To avoid them, stop services temporarily or use snapshot tools.
Issue: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation'
Fix:
Grant the required privilege to the MySQL user used in the script:
GRANT PROCESS ON *.* TO 'nagiosxi'@'localhost';
FLUSH PRIVILEGES;
(Replace 'nagiosxi' with the actual MySQL user if different.)
Other warnings (e.g., "file modified during read"):
These are normal if services are active during backup and can generally be ignored. To avoid them, stop services temporarily or use snapshot tools.