Unraid Vorbereitung für eine Installation als EmbyServer

#!/bin/bash
##############################
# $Author: AcidRain
# $Date:   2019-08-26
#-----------------------------
# $Description:
# This scripts simulates a Anacron job
# and saves timestamp of last run.
# It's possible to define three intervals, only executed
# if interval has commands. For every command use a new array index.
##############################




##############################
# Variables
##############################
# debug output
#     0 => no output
#     1 => [definition='1','0']log[/definition] to syslog and MyAnacron.[definition='1','0']log[/definition]
#     2 => [definition='1','0']log[/definition] to syslog
#     3 => [definition='1','0']log[/definition] to MyAnacron.[definition='1','0']log[/definition]
#     4 => output to console
debugMode=1
# path where to save the logfile (default for Unraid: "/boot/logs")
pathToLogfile="/boot/logs/"


# path where to save last runtimes of intervals ("." => same path as script)
pathToRuntimeFile="/boot/logs/"




# interval in days for commands_1
interval_1=1
# interval in days for commands_2
interval_2=3
# interval in days for commands_3
interval_3=7




# add here commands for first interval (add commands in '')
commands_1=()
commands_1+=('/usr/local/sbin/mover')


# add here commands for seconds interval (add commands in '')
commands_2=()
#commands_2+=('')


# add here commands for third interval (add commands in '')
commands_3=()
commands_3+=('docker exec mariadb /config/MySQLBackup.sh')
commands_3+=('chown nobody:users /mnt/user/_Docker/mariadb/*.sql')
commands_3+=('chmod 666 /mnt/user/_Docker/mariadb/*.sql')
commands_3+=('mv /mnt/user/_Docker/mariadb/*.sql /mnt/user0/_Backup/MySQL/')
commands_3+=('fstrim -v /mnt/cache')










##############################
# NOTHING TO CHANGE FROM HERE
##############################
# constant for name of script
readonly NAME_OF_SCRIPT=$(basename -s .sh "$0")


# constant for one day in seconds
readonly DAY=86400


# constant for timestamp of todays date without hour and minutes
readonly TODAY=`date -d $(date '+%Y-%m-%d') +%s`


# constant for timestamp for now
readonly NOW=`date +%s`


# filename for last runtimes of intervals
readonly LAST_RUNTIME_FILE="$pathToRuntimeFile/$NAME_OF_SCRIPT.lrt"




# variable for last run of first interval runtime
lastrun_1=0
# variable for last run of second interval runtime
lastrun_2=0
# variable for last run of third interval runtime
lastrun_3=0






# function for running the commands in the commands array
function doCommands() {
   arr=("$@")
   for (( i = 0; i < "${#arr[@]}" ; i++ )); do
      [definition='1','0']log[/definition] "Running command $((i+1)): ${arr[$i]}"
      eval "${arr[$i]}"
   done
}


# function for output / logging
[definition='1','0']log[/definition]() {
   case $debugMode in
      1) logger -t "$NAME_OF_SCRIPT" "$1"
         echo "`date`: $1" >> "$pathToLogfile/$NAME_OF_SCRIPT.[definition='1','0']log[/definition]" ;;
      2) logger -t "$NAME_OF_SCRIPT" "$1" ;;
      3) echo "`date`: $1" >> "$pathToLogfile/$NAME_OF_SCRIPT.[definition='1','0']log[/definition]" ;;
      4) echo "`date`: $1" ;;
   esac
}


# check if last runtime file exists
if [ ! -f "$LAST_RUNTIME_FILE" ]; then
   [definition='1','0']log[/definition] "File '$LAST_RUNTIME_FILE' doesn't exist, will create with default values!"
   echo `date -d '1980-01-01' +%s` >  "$LAST_RUNTIME_FILE"
   echo `date -d '1980-01-01' +%s` >> "$LAST_RUNTIME_FILE"
   echo `date -d '1980-01-01' +%s` >> "$LAST_RUNTIME_FILE"
fi


# saving last runtime in variables for the intervals
lastrun_1=`sed -n '1p' "$LAST_RUNTIME_FILE" | awk '{print $1}'`
lastrun_2=`sed -n '2p' "$LAST_RUNTIME_FILE" | awk '{print $1}'`
lastrun_3=`sed -n '3p' "$LAST_RUNTIME_FILE" | awk '{print $1}'`


# output of values of last runtime
[definition='1','0']log[/definition] "Last run of $interval_1-day interval was on: `date -d @$lastrun_1 '+%Y-%m-%d'`"
[definition='1','0']log[/definition] "Last run of $interval_2-day interval was on: `date -d @$lastrun_2 '+%Y-%m-%d'`"
[definition='1','0']log[/definition] "Last run of $interval_3-day interval was on: `date -d @$lastrun_3 '+%Y-%m-%d'`"




# checking if exist commands for interval 1
if [[ ! -z "${commands_1}" ]]; then
   [definition='1','0']log[/definition] "Checking $interval_1-day interval commands"
   [definition='1','0']log[/definition] "Diff from last run to now: $((NOW - lastrun_1))s ($interval_1 day is: $((DAY * $interval_1))s)"
   if [ $((NOW - lastrun_1)) -ge $((DAY * $interval_1)) ]; then
      [definition='1','0']log[/definition] "Running the commands"
      doCommands "${commands_1[@]}"
      lastrun_1=$TODAY
   fi
fi


# checking if exist commands for interval 2
if [[ ! -z "${commands_2}" ]]; then
   [definition='1','0']log[/definition] "Checking $interval_2-day interval commands"
   [definition='1','0']log[/definition] "Diff from last run to now: $((NOW - lastrun_2))s ($interval_2 days are: $((DAY * $interval_2))s)"
   if [ $((NOW - lastrun_2)) -ge $((DAY * $interval_2)) ]; then
      [definition='1','0']log[/definition] "Running the commands"
      doCommands "${commands_2[@]}"
      lastrun_2=$TODAY
   fi
fi


# checking if exist commands for interval 3
if [[ ! -z "${commands_3}" ]]; then
   [definition='1','0']log[/definition] "Checking $interval_3-day interval commands"
   [definition='1','0']log[/definition] "Diff from last run to now: $((NOW - lastrun_3))s ($interval_3 days are: $((DAY * $interval_3))s)"
   if [ $((NOW - lastrun_3)) -ge $((DAY * $interval_3)) ]; then
      [definition='1','0']log[/definition] "Running the commands"
      doCommands "${commands_3[@]}"
      lastrun_3=$TODAY
   fi
fi


# saving last runtimes of intervals in target file
echo $lastrun_1 > "$LAST_RUNTIME_FILE"
echo $lastrun_2 >> "$LAST_RUNTIME_FILE"
echo $lastrun_3 >> "$LAST_RUNTIME_FILE"

#!/bin/bash
# TARGET: Backup-Ziel
# IGNORE: Liste zu ignorierender Datenbanken (durch | getrennt)
# CONF: MySQL Config-Datei
TARGET=/config
IGNORE="phpmyadmin|mysql|information_schema|performance_schema|test"
CONF=/config/custom.cnf
if [ ! -r $CONF ]; then /usr/bin/logger "$0 - auf $CONF konnte nicht zugegriffen werden"; exit 1; fi
if [ ! -d $TARGET ] || [ ! -w $TARGET ]; then /usr/bin/logger "$0 - Backup-Verzeichnis nicht beschreibbar"; exit 1; fi


DBS="$(/usr/bin/mysql --defaults-extra-file=$CONF --user=root --password=GEHEIM -Bse 'show databases' | /bin/grep -Ev $IGNORE)"
NOW=$(date +"%Y-%m-%d")


for DB in $DBS; do
    echo "SET autocommit=0; SET unique_checks=0; SET foreign_key_checks=0;" > $TARGET/$NOW\_$DB.sql
    /usr/bin/mysqldump --defaults-extra-file=$CONF --user=root --password=GEHEIM --skip-extended-insert --skip-comments $DB >> $TARGET/$NOW\_$DB.sql
    echo "COMMIT;" >> $TARGET/$NOW\_$DB.sql
done




/usr/bin/logger "$0 - Backup von $NOW erfolgreich durchgefuehrt"
exit 0