Domoticz

Code: Select all

#!/bin/bash
#
# 20201028 Modified to replace CR/LF (windows) to LF (Linux)
#
# LOCAL/FTP/SCP/MAIL PARAMETERS
#
SERVER="192.168.1.11"                                      # IP of Synology NAS, used for ftp
USERNAME="Domoticz"                                        # FTP username of Network disk used for ftp
PASSWORD="12345"                                           # FTP password of Network disk used for ftp
DESTDIR=" /tmp/"                                           # used for temorarily storage
DESTDIRNAS="/homes/domoticz/backup/"                       # Path to your Synology NAS backup folder
DOMO_IP="192.168.1.12"                                     # Domoticz IP
DOMO_PORT="8080"                                           # Domoticz port

### END OF USER CONFIGURABLE PARAMETERS

TIMESTAMP=`/bin/date +%Y%m%d%H%M%S`
BACKUPFILE="domoticz_$TIMESTAMP.db" # backups will be named "domoticz_YYYYMMDDHHMMSS.db.gz"
BACKUPFILEGZ="$BACKUPFILE".gz

#
### Create backup and ZIP it
#
/usr/bin/curl -s http://$DOMO_IP:$DOMO_PORT/backupdatabase.php > /tmp/$BACKUPFILE
gzip -9 /tmp/$BACKUPFILE
tar -zcvf /tmp/domoticz_scripts_$TIMESTAMP.tar.gz /home/pi/domoticz/scripts/
tar -zcvf /tmp/telegram_scripts_$TIMESTAMP.tar.gz /home/pi/tg/scripts/

#
### Send to Network disk through FTP
#
curl -s --disable-epsv -v -T"/tmp/$BACKUPFILEGZ" -u"$USERNAME:$PASSWORD" "ftp://$SERVER/$DESTDIRNAS"
curl -s --disable-epsv -v -T"/tmp/domoticz_scripts_$TIMESTAMP.tar.gz" -u"$USERNAME:$PASSWORD" "ftp://$SERVER/$DESTDIRNAS"
curl -s --disable-epsv -v -T"/tmp/telegram_scripts_$TIMESTAMP.tar.gz" -u"$USERNAME:$PASSWORD" "ftp://$SERVER/$DESTDIRNAS"

#
### Remove temp backup file
#
/bin/rm /tmp/$BACKUPFILEGZ
/bin/rm /tmp/domoticz_scripts_$TIMESTAMP.tar.gz
/bin/rm /tmp/telegram_scripts_$TIMESTAMP.tar.gz

#eoj
## Done!

Code: Select all

ls -ls /bin/bash

Code: Select all

ls -ls /home/pi/domoticz/scripts/domoticz_backup.sh

Code: Select all

chmod +x /home/pi/domoticz/scripts/domoticz_backup.sh

Code: Select all

 844 -rwxr-xr-x 1 root root 863400 Jan 15  2017 /bin/bash 

Code: Select all

 4 -rwxr-xr-x 1 pi pi 1604 Oct 27 21:57 /home/pi/domoticz/scripts/domoticz_backup.sh 

Code: Select all

 ls -ls /home/pi/domoticz/scripts/domoticz_backup.sh

Code: Select all

 4 -rwxrwxrwx 1 pi pi 1609 Oct 28 09:50 /home/pi/domoticz/scripts/domoticz_backup.sh

Code: Select all

 sudo sh /home/pi/domoticz/scripts/domoticz_backup.sh

Code: Select all

 tar: Removing leading `/' from member names
tar: /home/pi/domoticz/scripts/\r: Cannot stat: No such file or directory
tar: Exiting with failure status due to previous errors
tar: Removing leading `/' from member names
tar: /home/pi/tg/scripts/\r: Cannot stat: No such file or directory
tar: Exiting with failure status due to previous errors
'!b.gzCan't open '/tmp/domoticz_20201028100108
curl: try 'curl --help' or 'curl --manual' for more information
* Illegal characters found in URL
* Closing connection -1
* Illegal characters found in URL
* Closing connection -1
/bin/rm: cannot remove ‘/tmp/domoticz_20201028100108\r.db.gz\r\r’: No such file or directory
/bin/rm: cannot remove ‘/tmp/domoticz_scripts_20201028100108\r.tar.gz\r’: No such file or directory
/bin/rm: cannot remove ‘/tmp/telegram_scripts_20201028100108\r.tar.gz\r’: No such file or directory

Code: Select all

  sudo chmod +x /home/pi/domoticz/scripts/domoticz_backup.sh 

Code: Select all

 sudo /home/pi/domoticz/scripts/domoticz_backup.sh 

Code: Select all

 sudo: unable to execute /home/pi/domoticz/scripts/domoticz_backup.sh: No such file or directory 

Code: Select all

 sudo sh /home/pi/domoticz/scripts/domoticz_backup.sh 

Code: Select all

 tar: Removing leading `/' from member names
tar: /home/pi/domoticz/scripts/\r: Cannot stat: No such file or directory
tar: Exiting with failure status due to previous errors
tar: Removing leading `/' from member names
tar: /home/pi/tg/scripts/\r: Cannot stat: No such file or directory
tar: Exiting with failure status due to previous errors
'!b.gzCan't open '/tmp/domoticz_20201028104943
curl: try 'curl --help' or 'curl --manual' for more information
* Illegal characters found in URL
* Closing connection -1
* Illegal characters found in URL
* Closing connection -1
/bin/rm: cannot remove ‘/tmp/domoticz_20201028104943\r.db.gz\r\r’: No such file or directory
/bin/rm: cannot remove ‘/tmp/domoticz_scripts_20201028104943\r.tar.gz\r’: No such file or directory
/bin/rm: cannot remove ‘/tmp/telegram_scripts_20201028104943\r.tar.gz\r’: No such file or directory

Code: Select all

  sudo /home/pi/domoticz/scripts/domoticz_backup.sh  

Code: Select all

  sudo: unable to execute /home/pi/domoticz/scripts/domoticz_backup.sh: No such file or directory 

Code: Select all

  844 -rwxr-xr-x 1 root root 863400 Jan 15  2017 /bin/bash  

Code: Select all

#!/usr/bin/env /bin/bash

SCRIPTNAME=`basename "$0"`
SCRIPTNAME=${SCRIPTNAME%.*}
LOGFILE=/var/log/$SCRIPTNAME.log
ERRORLOG=/var/log/$SCRIPTNAME_ERROR.log
HOSTNAME=$(hostname)
DOMO_IP="127.0.0.1"      # Domoticz IP
DOMO_PORT="8080"         # Domoticz port
REMOTEHOST="192.168.2.xxx"
REMOTEPATH="/volume1/RaspberryPi/Domoticz_DB/$HOSTNAME"
SOURCEFILE="domoticz.db"
SOURCEPATH="/home/pi/domoticz/"
MOUNTPOINT="/mnt/$SCRIPTNAME"
### END OF USER CONFIGURABLE PARAMETERS

# Start Timestamp
STARTTIME=$(date +"%s.%N")

# Place in the log file information concerning the execution of this script
echo -n "Domoticz database backup start at " >> $LOGFILE
echo $(date) >> $LOGFILE

if [ ! -d $MOUNTPOINT ]; then
    sudo mkdir $MOUNTPOINT
fi

if ! mountpoint -q $MOUNTPOINT; then
    sudo mount -t nfs $REMOTEHOST:$REMOTEPATH $MOUNTPOINT
fi
if ! /bin/mountpoint -q $MOUNTPOINT; then
    touch $ERRORLOG
    chmod 0666 $ERRORLOG
    echo "Mount $MOUNTPOINT ERROR!!!" >> $ERRORLOG
    exit 99
fi

#Delete backups older than 3 days = 864 (288 per day is saved every 5 minutes)
cd $MOUNTPOINT
ls -tr | head -n -864 | xargs --no-run-if-empty rm

### Create backup
TIMESTAMP=`/bin/date +%Y%m%d%H%M%S`
DB_VERSION=`sqlite3 $SOURCEPATH$SOURCEFILE "Select nValue from Preferences WHERE Key = 'DB_Version'"`
BACKUPFILE=$HOSTNAME"_"$TIMESTAMP"_"$DB_VERSION".db" # backups will be named "domoticz_YYYYMMDDHHMMSS_ZZZ.db"

/usr/bin/curl -s http://$DOMO_IP:$DOMO_PORT/backupdatabase.php > $MOUNTPOINT/$BACKUPFILE

sync
sudo /bin/umount -l $MOUNTPOINT

# End timestamp
ENDTIME=$(date +"%s.%N")

# Convert nanoseconds to milliseconds
# crudely by taking first 3 decimal places
TIMEDIFF=`echo "$ENDTIME - $STARTTIME" | bc | awk -F"." '{print $1"."substr($2,1,3)}'`
SEC=`echo "$TIMEDIFF % 60" | bc`

echo "Total of $SEC seconds elapsed." >> $LOGFILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOGFILE

### Done!

Code: Select all

#!/bin/sh
NOW=$(date +"%Y-%m-%d")
BPATH=/volume1/homes/guy/backup
RUNLOG=/volume1/homes/guy/log/$NOW.txt
NAME="Domoticz"
echo  ------------------- START $NAME -- $(date) | tee -a $RUNLOG
SOURCE="[email protected]:/domoticz/"
DESTINATION="$BPATH/$NAME/$NOW"
mkdir -p "$DESTINATION"
rsync -aP -e "ssh -i /root/.ssh/home" --stats --delete-after --links --ignore-errors --link-dest="../__prev/" "$SOURCE" "$DESTINATION" | tee -a $RUNLOG
rm -f "$BPATH/$NAME/__prev"
ln -s "$BPATH/$NAME/$NOW" "$BPATH/$NAME/__prev"
echo  ------------------- END  $NAME -- $(date) | tee -a $RUNLOG

Code: Select all

sudo sqlite3 /opt/domoticz/domoticz/db  '.backup myBackup.db'

Code: Select all

/usr/bin/sqlite3 $SOURCEPATH$SOURCEFILE ".backup $MOUNTPOINT/$BACKUPFILE"