Patrick Tully mrpatrick

Professional guru by day, amateur photog, astronomer, road biker, and banjo player on weekends

mrpatrick / rackspace_statuspageio.sh

Created July 3, 2014 22:30

Get the status of Rackspace-ORD and set them on StatusPage.io Components

	#!/bin/bash

	# Set from statuspage.io
	PAGE_ID=""
	AUTH_TOKEN=""

	# Set from statuspage.io Component ID's
	COMP_SERVERS_NEXT=""
	COMP_SERVERS_FIRST=""
	COMP_LOAD_BALANCERS=""

mrpatrick / sed-tsv2mod_rewrite

Created September 5, 2014 19:39

sed command to create mod_rewrite rules from tab delimited spreadsheet.

cat redirects.tsv | sed -e 's/\(^\/\)\([a-zA-Z0-9\/!#$&-;=?%-_a-z~]*\)\(\t*\)\(.*\)/RewriteRule ^\/?\2$\4 [L,R=302]/'

mrpatrick / harvest_backup.worker

Created September 15, 2014 15:56

daily_harvest mysql backups automated on iron.io (worker file). http://workshop.avatarnewyork.com/project/daily-harvest/

mrpatrick / harvest_email.worker

Created September 15, 2014 16:15

daily_harvest email report automated on iron.io (worker file). http://workshop.avatarnewyork.com/project/daily-harvest/

mrpatrick / mysql_dump_import_ssh.sh

Created January 8, 2015 22:35

$ mysqldump -u user -p'password' db-name foo | ssh [email protected] mysql -u user -p'password' db-name foo

mrpatrick / force_git_pointer.sh

Last active August 29, 2015 14:23

Force branch pointer for current release

	git branch -f stage release-v1.0.1
	git push -f origin stage

mrpatrick / bad_robots_access_logs.sh

Created July 1, 2015 14:47

Find all robot user agents in logs, sort by hits

cat access_log | awk -F\" '{print $6}' | sort | uniq -c | sort -n |grep bot

mrpatrick / git_patch_file_branches.sh

Created July 2, 2015 11:10

From http://nicolasgallagher.com/git-checkout-specific-files-from-another-branch/ Patch a single file across branches

	# On branch master
	git checkout gh-pages
	git checkout master -- myplugin.js
	git commit -m "Update myplugin.js from master"

mrpatrick / rest_drupal_pwd.sh

Created July 8, 2015 13:27

reset drupal admin password

drush upwd admin --password="s3cr3t"

mrpatrick / gzip_uncompressed_file_size.sh

Created July 22, 2015 15:52

find uncompressed file size. The first line returns the uncompressed file size in bytes

	#!/bin/bash
	time zcat test.gz\| wc -c