Mount share at boot

Save credentials at a local place where only you have rights

Mount share at boot
Save credentials at a local place where only you have rights
An easy way to backup files to a local share
The example backup’s the files from the /var/www/html directory
#change to website folders
cd /var/www/html/
#find all subsites
for D in *; do
if [ -d "${D}" ]; then
echo "Generating backup for $D > " `date +%Y-%m-%d_%H-%M-%S`-${D} # your processing here
tar -zcvf "/mnt/srv-ttp-nas/server/"`date +%Y-%m-%d_%H-%M-%S`-${D}.tar.gz ${D}
fi
done
#remove stale files
find /mnt/srv-ttp-nas/server/* -mtime +14 -exec rm {} \;
Add crontab to run backup every night at 3
sudo crontab -e
0 3 * * * /home/tom/backup_files.sh
Preview of data on share
I created an easy way to backup all mysql databases
/mnt/srv-ttp-nas/ is a location on a local NAS
#!/bin/sh
sleep 10
DB_USER="username"
DB_PASS="password"
BACKUP_DIR = "/mnt/srv-ttp-nas/bu/databases"
#find all databasses and backup them
databases=`mysql --user=$DB_USER --password=$DB_PASS -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
for db in $databases; do
echo "Dumping database: $db"
mysqldump $db -u $DB_USER -p --password=$DB_PASS | gzip > "/mnt/srv-ttp-nas/databases/"`date +%Y-%m-%d_%H-%M-%S`-$db.sql.gz
done
#remove files older than one month
find /mnt/srv-ttp-nas/databases/* -mtime +31 -exec rm {} \;
The power of this script is that if you add a new database this will automaticly be added.
Add to crontab to backup every 6 hours.
sudo crontab -e
0 0,6,12,18 * * * /home/tom/backup.sh
Preview of data on share
Enable unsafe apps
First we have to enable unsafe apps to connect to gmail.
https://myaccount.google.com/security
SMTP settings
smtp.gmail.com
SSL vereist: ja
TLS vereist: ja (indien beschikbaar)
Verificatie vereist: ja
Poort voor SSL: 465
Poort voor TLS/STARTTLS: 587
Download the correct software from Ubiquiti.
Change the name from the downloaded file to fwupdate.bin
Open WinSCP and connect to the AP using SCP protocol.
Copy the fwupdate.bin file to /tmp folder.
Close WinSCP and open Putty. Connect to the AP using ssh.
Issue the command syswrapper.sh upgrade2 & after this your session will close automatic and the AP will start the upgrade.