Page 1 of 1

Error while taking NagiosXI Backup

Posted: Tue Apr 20, 2021 7:14 am
by RIDS_I2MP
Hi Team,

We are getting below error while taking backup of Nagios XI manually. Could you please help us how we can to get this resolved.

Error backing up MySQL database 'nagios' - check the password in this script!

NagiosXI Backup on 10.144.223.155:
[root@eu1papu002 nagiosxi]# /usr/local/nagiosxi/scripts/backup_xi.sh
\nStarting new backup....\n
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/ndo.sock: socket ignored
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var: file changed as we read it
tar: /usr/local/nagios/share/perfdata/EU1PAPU084/_log01_usage.rrd: file changed as we read it
tar: /usr/local/nagios/share/perfdata/EU1PAPU084/_HOST_.rrd: file changed as we read it
tar: /usr/local/nagios/share/perfdata/EU1PAPU084: file changed as we read it
tar: /usr/local/nagios/share/perfdata/EU1RFSW018/_HOST_.rrd: file changed as we read it
tar: /usr/local/nagios/share/perfdata/EU1RFSW018: file changed as we read it
tar: /usr/local/nagios/share/perfdata/C08AAPW160/Committed_Bytes_In_Use.xml: file changed as we read it
tar: /usr/local/nagios/share/perfdata/C08AAPW160: file changed as we read it
tar: /usr/local/nagios/share/perfdata/EU1RAPW076/_HOST_.rrd: file changed as we read it
tar: /usr/local/nagios/share/perfdata/EU1RAPW076: file changed as we read it
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
tar: /var/lib/mrtg/10.149.250.2_65.rrd: file changed as we read it
tar: /var/lib/mrtg/10.144.249.121_44.rrd: file changed as we read it
tar: /var/lib/mrtg: file changed as we read it
Backing up the SNMP directories
tar: Removing leading `/' from member names
tar: Removing leading `/' from member names
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up Nagvis...
tar: Removing leading `/' from member names
Backing up nagios user home dir...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got errno 28 on write
Error backing up MySQL database 'nagios' - check the password in this script!
You have new mail in /var/spool/mail/root
[root@eu1papu002 nagiosxi]#


Thanks
Nitin Parate

Re: Error while taking NagiosXI Backup

Posted: Tue Apr 20, 2021 12:19 pm
by dchurch
What's the output from the following command?

Code: Select all

df -h

Re: Error while taking NagiosXI Backup

Posted: Wed Apr 21, 2021 10:09 am
by RIDS_I2MP
[root@eu1papu002 nagiosxi]# df -h /store
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rootvg-storelv 19G 11G 8.0G 57% /store
[root@eu1papu002 nagiosxi]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 7.8G 0 7.8G 0% /dev
tmpfs 7.8G 0 7.8G 0% /dev/shm
tmpfs 7.8G 778M 7.0G 10% /run
tmpfs 7.8G 0 7.8G 0% /sys/fs/cgroup
/dev/mapper/rootvg-rootlv 9.1G 233M 8.4G 3% /
/dev/mapper/rootvg-usrlv 28G 20G 6.7G 75% /usr
/dev/sda1 9.1G 221M 8.4G 3% /boot
/dev/mapper/rootvg-homelv 14G 88M 14G 1% /home
/dev/mapper/rootvg-tmplv 9.1G 302M 8.3G 4% /tmp
/dev/mapper/rootvg-varlv 110G 4.8G 100G 5% /var
/dev/mapper/rootvg-storelv 19G 11G 8.0G 57% /store
tmpfs 1.6G 0 1.6G 0% /run/user/1001
tmpfs 1.6G 0 1.6G 0% /run/user/2101
You have mail in /var/spool/mail/root
[root@eu1papu002 nagiosxi]#

Re: Error while taking NagiosXI Backup

Posted: Wed Apr 21, 2021 2:40 pm
by vtrac
Hi
Backup Failed Mysqldump Got Errno 28 On Write

Code: Select all

Error Message
Backup failed: mysqldump: Got errno 28 on write

Meaning
Insufficient disk space to store output.

Solution
Free up some disk space. You might want to track down the reason you're low on disk space too.
https://sittinginoblivion.com/wiki/back ... o-28-write

Looks like you might want to clean up the "/store" and "/tmp" filesystems, then try the backup again.
/usr/local/nagiosxi/scripts/backup_xi.sh


Best Regards,
Vinh