Nagios Support Forum

Hi,

I'm passing by a problem, when I execute the script backup_xi.sh I get this error :

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

I read the script and I see that the username and password of database is filled by a variables: $cfg__db_info__ndoutils__user $cfg__db_info__ndoutils__pwd

I executed in debug mode:

+ echo 'Backing up MySQL databases...'
Backing up MySQL databases...
+ mkdir -p /store/backups/nagiosxi/1390229303/mysql
+ mysqldump -h -u --password= --add-drop-database -B
+ res=1
+ '[' 1 '!=' 0 ']'
+ echo 'Error backing up MySQL database '\''nagios'\'' - check the password in this script!'
Error backing up MySQL database 'nagios' - check the password in this script!
+ exit 1

The username and password wasn't filled.

This problem began when I updated NagiosXI from 2.5 to 2.7.

What I do?

Please run the following and post the output:

Ok,

I identified the problem

The problem was on the first line on this script.

#!/bin/sh

# IMPORT ALL XI CFG VARS
php import_xiconfig.php > config.dat
. ./config.dat
rm -rf config.dat


###############################
# USAGE / HELP
###############################

But I was executing with absolute path

/usr/local/nagiosxi/script/backup_xi.sh

I modified this script with:

#!/bin/sh

# IMPORT ALL XI CFG VARS
php import_xiconfig.php > config.dat
BASE=`echo $0 | awk -F"backup_xi.sh" '{print $1}'`
. $BASE/config.dat
rm -rf config.dat


###############################
# USAGE / HELP
###############################

Team Nagios need to fix this detail, because on the document, they say to execute this script with absolute path and not inside the directory.

Creating A Backup
You can create a backup of your Nagios XI installation by running the following script as the root user:
/usr/local/nagiosxi/scripts/backup_xi.sh
....
http://assets.nagios.com/downloads/nagi ... ing_XI.pdf

Thanks tmcdonald for your help.
So, Thanks everybody for help.

Have you filed a bug report for this or shall I do so?

Please do this for me,



Thanks

Submitted.

If you have more to discuss please do so, otherwise I will be closing this thread.

No more problems,

Can close.

Thanks.