Nagios Support Forum

Code: Select all

service mysqld stop

service nagios restart

service mysqld start

Code: Select all

++ dirname backup_xi.sh
+ BASEDIR=.
+ php ./import_xiconfig.php
Could not open input file: ./import_xiconfig.php
+ . ./config.dat
+ rm -rf ./config.dat
+ '[' -n '' ']'
+ '[' -z ']'
+ rootdir=/store/backups/nagiosxi
+ cd /store/backups/nagiosxi
++ date +%s
+ ts=1392052722
+ mydir=/store/backups/nagiosxi/1392052722
+ mkdir -p /store/backups/nagiosxi/1392052722
+ echo 'Backing up Core Config Manager (NagiosQL)...'
Backing up Core Config Manager (NagiosQL)...
+ tar czfps /store/backups/nagiosxi/1392052722/nagiosql.tar.gz /var/www/html/nagiosql
tar: Removing leading `/' from member names
+ tar czfps /store/backups/nagiosxi/1392052722/nagiosql-etc.tar.gz /etc/nagiosql
tar: Removing leading `/' from member names
+ echo 'Backing up Nagios Core...'
Backing up Nagios Core...
+ tar czfps /store/backups/nagiosxi/1392052722/nagios.tar.gz /usr/local/nagios
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/ndo.sock: socket ignored
+ echo 'Backing up Nagios XI...'
Backing up Nagios XI...
+ tar czfps /store/backups/nagiosxi/1392052722/nagiosxi.tar.gz /usr/local/nagiosxi
tar: Removing leading `/' from member names
+ echo 'Backing up MRTG...'
Backing up MRTG...
+ tar czfps /store/backups/nagiosxi/1392052722/mrtg.tar.gz /var/lib/mrtg
tar: Removing leading `/' from member names
+ cp /etc/mrtg/mrtg.cfg /store/backups/nagiosxi/1392052722/
+ echo 'Backing up MySQL databases...'
Backing up MySQL databases...
+ mkdir -p /store/backups/nagiosxi/1392052722/mysql
+ echo 'rlgdebug --  = '
rlgdebug --  = 
+ 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

Code: Select all

#!/bin/sh

BASEDIR=$(dirname $0)

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


###############################
# USAGE / HELP
###############################
usage () {
        echo ""
        echo "Use this script to backup Nagios XI."
        echo ""
                echo " -n | --name              Set the name of the backup minus the .tar.gz"
        echo " -p | --prepend           Prepend a string to the .tar.gz name"
        echo " -a | --append            Append a string to the .tar.gz name"
        echo " -d | --directory         Change the directory to store the compressed backup"
        echo ""
}

###############################
# ADDING LOGIC FOR NEW BACKUPS
###############################
while [ -n "$1" ]; do
        case "$1" in
                -h | --help)
                        usage
                        exit 0
                        ;;
                -n | --name)
                        fullname=$2
                        ;;
                -p | --prepend)
                        prepend=$2"."
                        ;;
                -a | --append)
                        append="."$2
                        ;;
                -d | --directory)
                        rootdir=$2
                        ;;
        esac
        shift
done

# Must be root
#me=`whoami`
#if [ $me != "root" ]; then
#       echo "You must be root to run this script."
#       exit 1
#fi
# No longer need root because of file permissions -JO

if [ -z $rootdir ]; then
        rootdir=/store/backups/nagiosxi
fi

# Make root directory to store backups
#mkdir -p $rootdir
cd $rootdir
# Directory is created upon XI install -JO

# Get current Unix timestamp
ts=`date +%s`

# My working directory
mydir=$rootdir/$ts

# Make directory for this specific backup
mkdir -p $mydir

##############################
# BACKUP DIRS
##############################

echo "Backing up Core Config Manager (NagiosQL)..."
#cp -rp /var/www/html/nagiosql $mydir
#cp -rp /etc/nagiosql $mydir/nagiosql-etc
tar czfps $mydir/nagiosql.tar.gz /var/www/html/nagiosql
tar czfps $mydir/nagiosql-etc.tar.gz /etc/nagiosql

echo "Backing up Nagios Core..."
#cp -rp /usr/local/nagios $mydir
tar czfps $mydir/nagios.tar.gz /usr/local/nagios

echo "Backing up Nagios XI..."
#cp -rp /usr/local/nagiosxi $mydir
tar czfps $mydir/nagiosxi.tar.gz /usr/local/nagiosxi

echo "Backing up MRTG..."
#cp -rp /usr/local/nagiosxi $mydir
tar czfps $mydir/mrtg.tar.gz /var/lib/mrtg
cp /etc/mrtg/mrtg.cfg $mydir/

##############################
# BACKUP DATABASES
##############################
echo "Backing up MySQL databases..."
mkdir -p $mydir/mysql
echo "rlgdebug -- $cfg_db_info_ndoutils_dbserver = $cfg__db_info__ndoutils__dbserver" 
mysqldump -h $cfg__db_info__ndoutils__dbserver -u $cfg__db_info__ndoutils__user --password=$cfg__db_info__ndoutils__pwd --add-drop-database -B $cfg__db_info__ndoutils__db > $mydir/mysql/nagios.sql
res=$?
if [ $res != 0 ]; then
        echo "Error backing up MySQL database 'nagios' - check the password in this script!"
        exit $res;
fi
mysqldump -h $cfg__db_info__nagiosql__dbserver -u $cfg__db_info__nagiosql__user --password=$cfg__db_info__nagiosql__pwd --add-drop-database -B $cfg__db_info__nagiosql__db > $mydir/mysql/nagiosql.sql
res=$?
if [ $res != 0 ]; then
        echo "Error backing up MySQL database 'nagiosql' - check the password in this script!"
        exit $res;
fi

echo "Backing up PostgresQL databases..."
mkdir -p $mydir/pgsql
if [ -z $cfg__db_info__nagiosxi__dbserver ]; then
        cfg__db_info__nagiosxi__dbserver="localhost"
fi
pg_dump -h $cfg__db_info__nagiosxi__dbserver -c -U $cfg__db_info__nagiosxi__user $cfg__db_info__nagiosxi__db > $mydir/pgsql/nagiosxi.sql
res=$?
if [ $res != 0 ]; then
        echo "Error backing up PostgresQL database 'nagiosxi' !"
        exit $res;
fi

##############################
# BACKUP CRONJOB ENTRIES
##############################
# Not necessary

##############################
# BACKUP SUDOERS
##############################
# Not necessary

##############################
# BACKUP LOGROTATE
##############################
echo "Backing up logrotate config files..."
mkdir -p $mydir/logrotate
cp -rp /etc/logrotate.d/nagiosxi $mydir/logrotate

##############################
# BACKUP APACHE CONFIG FILES
##############################
echo "Backing up Apache config files..."
mkdir -p $mydir/httpd
cp -rp /etc/httpd/conf.d/nagios.conf $mydir/httpd
cp -rp /etc/httpd/conf.d/nagiosxi.conf $mydir/httpd
cp -rp /etc/httpd/conf.d/nagiosql.conf $mydir/httpd

#############################
# SET THE NAME
#############################
name=$fullname

if [ -z $fullname ]; then
        name=$prepend$ts$append
fi

##############################
# ZIP BACKUP
##############################
echo "Compressing backup..."
tar czfps $name.tar.gz $ts
rm -rf $ts

if [ -s $name.tar.gz ];then

        echo " "
        echo "==============="
        echo "BACKUP COMPLETE"
        echo "==============="
        echo "Backup stored in $rootdir/$name.tar.gz"

        exit 0;
else
        echo " "
        echo "==============="
        echo "BACKUP FAILED"
        echo "==============="
        echo "File was not created at $rootdir/$name.tar.gz"

        exit 1;
fi
[root@ubitmon-jf scripts]#

Code: Select all

mysql -p<new password>