From 9330113df08676ec82639aec8cca290709b7936e Mon Sep 17 00:00:00 2001
From: Silvio Rhatto <rhatto@riseup.net>
Date: Tue, 27 Sep 2011 18:07:24 -0300
Subject: Action backup-site now dumping db and storing things in the right
 place

---
 share/hydractl/backup-restore-site |  8 ++++-
 share/hydractl/backup-site         | 61 ++++++++++++++++++++++++++++----------
 share/hydractl/puppet-reset-stored |  6 +++-
 3 files changed, 58 insertions(+), 17 deletions(-)

(limited to 'share')

diff --git a/share/hydractl/backup-restore-site b/share/hydractl/backup-restore-site
index 16ebf93..d02fb79 100755
--- a/share/hydractl/backup-restore-site
+++ b/share/hydractl/backup-restore-site
@@ -60,7 +60,6 @@ fi
 # Site
 if [ -e "$FOLDER/site" ]; then
   chown -R $SITE.$SITE $FOLDER/site
-  echo "Databases should be manually restored"
 fi
 
 # Drupal
@@ -71,3 +70,10 @@ if [ -e "$FOLDER/drupal" ]; then
   chown root.$SITE $FOLDER/drupal/settings.php
   chmod 640 $FOLDER/drupal/settings.php
 fi
+
+# Restore database
+if [ -f "$RESTOREDIR/var/backups/mysql/sqldump/$SITE.sql.gz" ]; then
+  hydra_truncate_database $SITE
+else
+  echo "Databases should be manually restored"
+fi
diff --git a/share/hydractl/backup-site b/share/hydractl/backup-site
index 53119da..79bc4ec 100755
--- a/share/hydractl/backup-site
+++ b/share/hydractl/backup-site
@@ -2,31 +2,62 @@
 #
 # Pack a website.
 #
-# TODO: put on $SITES/backups/site/$SITE, with htaccess and correct
-#       ownership/permission.
-#
-# TODO: optionally backup database before packing
-#
-# TODO: add backup files in a dated folder
 
 # Arguments
 SITES="/var/sites"
 SITE="$1"
 PACK="$1.tar.bz2"
+DATE="`date +%Y%m%d`"
+DEST="$SITES/backups/site/$SITE/$DATE"
 
+# Syntax check
 if [ -z "$SITE" ]; then
   hydra_action_usage
   exit 1
-elif [ ! -d "$SITES/$SITE" ]; then
-  echo "No such site $SITE"
-  exit 1
 fi
 
-mkdir -p $SITES/backups/$SITE
-cd $SITES/backups/$SITE
+# Create folder
+mkdir -p $DEST
+cd $DEST
 
-tar jcvf $PACK $SITES/$SITE
-md5sum $PACK  > $PACK.md5
-sha1sum $PACK > $PACK.sha1
+# Password setup
+if [ ! -e "$SITES/backups/site/$SITE/.htpasswd" ]; then
+  touch $SITES/backups/site/$SITE/.htpasswd
+  chmod 640 $SITES/backups/site/$SITE/.htpasswd
+  chown root.backups $SITES/backups/site/$SITE/.htpasswd
+fi
 
-echo "Saved $SITES/backups/$SITE/$PACK"
+# Access setup
+if [ ! -e "$SITES/backups/site/$SITE/.htaccess" ]; then
+  echo > $SITES/backups/site/$SITE/.htaccess <<EOF
+AuthType Basic
+AuthName "Backup $SITE"
+AuthUserFile $SITES/backups/site/$SITE/.htpasswd
+Require valid-user
+EOF
+fi
+
+# Backup site
+if [ ! -d "$SITES/$SITE" ]; then
+  echo "Backing up site folder..."
+  tar jcvf $PACK $SITES/$SITE
+  md5sum $PACK  > $PACK.md5
+  sha1sum $PACK > $PACK.sha1
+  chown root.backups $PACK*
+  chmod 640 $PACK*
+  echo "Saved $DEST/$PACK"
+fi
+
+# Backup database
+if [ -d "/var/lib/mysql/$SITE" ]; then
+  echo "Backing up database $SITE..."
+  mysqldump $SITE > $SITE.sql
+  bzip2 $SITE.sql
+  md5sum $SITE.sql.bz2 > $SITE.sql.bz2.md5
+  sh1sum $SITE.sql.bz2 > $SITE.sql.bz2.sha1
+  chown root.backups $SITE.sql*
+  chmod 640 $SITE.sql*
+  echo "Saved $DEST/$SITE.sql.bz2"
+else
+  echo "Database not found, please backup it manually"
+fi
diff --git a/share/hydractl/puppet-reset-stored b/share/hydractl/puppet-reset-stored
index 48a3dc1..090917f 100755
--- a/share/hydractl/puppet-reset-stored
+++ b/share/hydractl/puppet-reset-stored
@@ -3,4 +3,8 @@
 # Reset puppet stored configs
 #
 
-mysql puppet -e "drop database puppet ; create database puppet;"
+# Load.
+source $APP_BASE/lib/hydra/functions || exit 1
+hydra_config_load
+
+hydra_truncate_database puppet
-- 
cgit v1.2.3