Bring blog backup script under chef control

diff --git a/cookbooks/foundation/recipes/default.rb b/cookbooks/foundation/recipes/default.rb
index 7b1fa1d05c4293e8e3161ad84d7a5d66764d57a4..2f9b98849c3b75686f3eec7d8a2e1f11ad209dc7 100644 (file)
--- a/cookbooks/foundation/recipes/default.rb
+++ b/cookbooks/foundation/recipes/default.rb
@@ -48,3 +48,11 @@ wordpress_plugin "sitepress-multilingual-cms" do
   site "blog.osmfoundation.org"
   source "plugins/sitepress-multilingual-cms"
 end
+
+template "/etc/cron.daily/blog-backup" do
+  source "backup.cron.erb"
+  owner "root"
+  group "root"
+  mode 0750
+  variable :passwords => passwords
+end

diff --git a/cookbooks/foundation/templates/default/backup.cron.erb b/cookbooks/foundation/templates/default/backup.cron.erb
new file mode 100644 (file)
index 0000000..6ab8a63
--- /dev/null
+++ b/cookbooks/foundation/templates/default/backup.cron.erb
@@ -0,0 +1,18 @@
+#!/bin/sh
+
+# DO NOT EDIT - This file is being maintained by Chef
+
+T=$(mktemp -d -t -p /var/tmp osm-blog.XXXXXXXXXX)
+D=$(date +%Y-%m-%d)
+B=osm-blog-$D.tar.gz
+
+mkdir $T/osm-blog-$D
+mysqldump --user=osm-blog-user --password=<%= @passwords["osmf-blog-user"] %> --opt osm-blog > $T/osm-blog-$D/osm-blog.sql
+ln -s /srv/blog.openstreetmap.org $T/osm-blog-$D/www
+
+export GZIP="--rsyncable -9"
+
+nice tar --create --gzip --dereference --directory=$T --file=$T/$B osm-blog-$D
+nice rsync $T/$B backup::backup
+
+rm -rf $T