From 4bd0c0cbf61b0782604f9a731bab9e8bcc0a9056 Mon Sep 17 00:00:00 2001
From: lookshe <github@lookshe.org>
Date: Mon, 20 Mar 2017 13:52:34 +0100
Subject: get paths for tools also in db script

---
 backup_db.sh | 81 ++++++++++++++++++++++++++++++++++++++++++++++--------------
 1 file changed, 62 insertions(+), 19 deletions(-)

diff --git a/backup_db.sh b/backup_db.sh
index 501d9d8..840e6d9 100755
--- a/backup_db.sh
+++ b/backup_db.sh
@@ -1,6 +1,49 @@
 #!/bin/bash
 #set -x
 
+# get path to all needed tools
+# /bin
+echo=$(which echo)
+gzip=$(which gzip)
+grep=$(which grep)
+mktemp=$(which mktemp)
+mv=$(which mv)
+pwd=$(which pwd)
+rm=$(which rm)
+umount=$(which umount)
+# /usr/bin
+cut=$(which cut)
+dirname=$(which dirname)
+expr=$(which expr)
+head=$(which head)
+mysql=$(which mysql)
+mysqldump=$(which mysqldump)
+nice=$(which nice)
+rsync=$(which rsync)
+seq=$(which seq)
+ssh=$(which ssh)
+sshfs=$(which sshfs)
+tail=$(which tail)
+
+# check if all needed tools are installed (only the ones not installed under /bin/)
+alltoolsinstalled="yes"
+test "$cut" = "" && echo "'cut' not installed or not found by 'which'" && alltoolsinstalled="no"
+test "$dirname" = "" && echo "'dirname' not installed or not found by 'which'" && alltoolsinstalled="no"
+test "$expr" = "" && echo "'expr' not installed or not found by 'which'" && alltoolsinstalled="no"
+test "$head" = "" && echo "'head' not installed or not found by 'which'" && alltoolsinstalled="no"
+test "$mysql" = "" && echo "'mysql' not installed or not found by 'which'" && alltoolsinstalled="no"
+test "$mysqldump" = "" && echo "'mysqldump' not installed or not found by 'which'" && alltoolsinstalled="no"
+test "$nice" = "" && echo "'nice' not installed or not found by 'which'" && alltoolsinstalled="no"
+test "$rsync" = "" && echo "'rsync' not installed or not found by 'which'" && alltoolsinstalled="no"
+test "$ssh" = "" && echo "'ssh' not installed or not found by 'which'" && alltoolsinstalled="no"
+test "$sshfs" = "" && echo "'sshfs' not installed or not found by 'which'" && alltoolsinstalled="no"
+test "$tail" = "" && echo "'tail' not installed or not found by 'which'" && alltoolsinstalled="no"
+
+if [ "$alltoolsinstalled" = "no" ]
+then
+   exit 1
+fi
+
 # main configuration
 script_dir="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
 config_file="$script_dir/main.cfg"
@@ -16,14 +59,14 @@ function source_section {
    section_start="^\[$section_name\]$"
    section_end="^\[/$section_name\]$"
 
-   line_start=$(grep -n "$section_start" "$config_name" | cut -d: -f1)
-   line_end=$(expr $(grep -n "$section_end" "$config_name" | cut -d: -f1) - 1)
-   line_diff=$(expr $line_end - $line_start)
+   line_start=$($grep -n "$section_start" "$config_name" | $cut -d: -f1)
+   line_end=$($expr $($grep -n "$section_end" "$config_name" | $cut -d: -f1) - 1)
+   line_diff=$($expr $line_end - $line_start)
 
-   tmp_file=$(mktemp)
-   head -n $line_end "$config_name" | tail -n $line_diff > "$tmp_file"
+   tmp_file=$($mktemp)
+   $head -n $line_end "$config_name" | $tail -n $line_diff > "$tmp_file"
    source "$tmp_file"
-   rm -f "$tmp_file"
+   $rm -f "$tmp_file"
 }
 
 # copy file with rsync to server
@@ -32,11 +75,11 @@ function rsync_server {
    dirto="$2"
    #nice -n 19 rsync -rle "ssh -i $keyfile" "$filefrom" "$userserver:$dirto"
    # limit the bandwith
-   nice -n 19 rsync --bwlimit=100000 -rle "ssh -i $keyfile" "$filefrom" "$userserver:$dirto"
+   $nice -n 19 $rsync --bwlimit=100000 -rle "$ssh -i $keyfile" "$filefrom" "$userserver:$dirto"
    ret=$?
    if [ $ret -ne 0 ]
    then
-      echo "problem in rsync: $filefrom"
+      $echo "problem in rsync: $filefrom"
    fi
 }
 
@@ -47,33 +90,33 @@ source_section "$config_file" "general"
 cd "$db_dir"
 
 # get all databases
-databases=$(nice -n 19 mysql -u root -N -e "show databases;" | grep -v "^information_schema$" | grep -v "^mysql$" | grep -v "^performance_schema$")
+databases=$($nice -n 19 $mysql -u root -N -e "show databases;" | $grep -v "^information_schema$" | $grep -v "^mysql$" | $grep -v "^performance_schema$")
 
 # handle each database
 for database in $databases
 do
    # dump and gzip database
-   nice -n 19 mysqldump -u root "$database" > "$database.sql"
-   nice -n 19 gzip "$database.sql"
+   $nice -n 19 $mysqldump -u root "$database" > "$database.sql"
+   $nice -n 19 $gzip "$database.sql"
 
    # mount for renaming
-   sshfs $userserver:$backupdir $backupdir_local -o IdentityFile=$keyfile -o IdentitiesOnly=yes
+   $sshfs $userserver:$backupdir $backupdir_local -o IdentityFile=$keyfile -o IdentitiesOnly=yes
 
    # rotate old backups
    for count in `seq 7 -1 2`
    do
-      count_last=$(expr $count - 1)
-      rm -f "$backupdir_local/$backupdirsingle/$database.sql.gz.$count"
-      mv -f "$backupdir_local/$backupdirsingle/$database.sql.gz.$count_last" "$backupdir_local/$backupdirsingle/$database.sql.gz.$count" > /dev/null 2>&1
+      count_last=$($expr $count - 1)
+      $rm -f "$backupdir_local/$backupdirsingle/$database.sql.gz.$count"
+      $mv -f "$backupdir_local/$backupdirsingle/$database.sql.gz.$count_last" "$backupdir_local/$backupdirsingle/$database.sql.gz.$count" > /dev/null 2>&1
    done
-   rm -f "$backupdir_local/$backupdirsingle/$database.sql.gz.1"
-   mv -f "$backupdir_local/$backupdirsingle/$database.sql.gz" "$backupdir_local/$backupdirsingle/$database.sql.gz.1" > /dev/null 2>&1
+   $rm -f "$backupdir_local/$backupdirsingle/$database.sql.gz.1"
+   $mv -f "$backupdir_local/$backupdirsingle/$database.sql.gz" "$backupdir_local/$backupdirsingle/$database.sql.gz.1" > /dev/null 2>&1
 
    # unmount
-   umount $backupdir_local
+   $umount $backupdir_local
 
    rsync_server "$database.sql.gz" "$backupdir/$backupdirsingle/"
 
    # delete temporary file
-   rm -f "$database.sql.gz"
+   $rm -f "$database.sql.gz"
 done # for database in $databases
-- 
cgit v1.2.3