jbonney’s gists

jbonney / keybase.md

Created December 11, 2017 20:40

Keybase proof

I hereby claim:

I am jbonney on github.
I am jbonney (https://keybase.io/jbonney) on keybase.
I have a public key ASBgDeWYjOtPoyZhuSwq-zuANFYogofsPCrYtKgGj_XwRQo

To claim this, I am signing this object:

jbonney / crontab

Last active August 29, 2015 14:22

Script to check the internet connection of a kiosk and reload the active page in case the connection drops and then comes back online. Sources: -http://alexba.in/blog/2015/01/14/automatically-reconnecting-wifi-on-a-raspberrypi/ - http://raspberrypi.stackexchange.com/questions/6981/auto-refresh-for-midori - http://www.lynsayshepherd.com/blog/2014…

*/2 * * * * DISPLAY=:0 sh /usr/local/bin/wifi_reloader.sh

jbonney / drop_tables.sh

Created September 17, 2014 06:03

Drop all tables in a database. Taken from http://lowendtalk.com/discussion/8203/quick-trick-drop-all-tables-in-mysql-database-in-one-step

	user=...
	pass=...
	host=localhost # or remote if necessary
	database=...
	mysqldump -u${user} -p${pass} -h ${host} --add-drop-table --no-data ${database} \| grep ^DROP \| mysql -u${user} -p${pass} -h ${host} ${database}

jbonney / remove_kernels.sh

Created July 31, 2014 06:56

Remove old kernels on Ubuntu server (http://ubuntuforums.org/showthread.php?t=2058377)

	# Get info about current kernel
	uname -a
	# List installed kernels
	dpkg-query -l \| awk '/linux-image-*/ {print $2}'
	# Remove old kernel and dependencies (DO NOT DELETE KERNEL FROM uname -a)
	sudo apt-get --purge remove <Kernel>
	sudo apt-get autoremove
	# Update grub (usually not necessary)
	sudo update-grub

jbonney / encrypt_decrypt.sh

Created February 18, 2014 10:12

Encrypt tar archive with openssl. Taken from http://codeblogging.net/blogs/1/16/creating-password-protected-targz-file-command-line. Alternative solution: http://askubuntu.com/questions/95920/encrypt-tar-gz-file-on-create

	#Encryption
	openssl enc -in important_backups.tar.gz -aes-256-cbc -e > important_backups_encrypted.tar.gz
	# Decryption
	openssl enc -in important_backups_encrypted.tar.gz -aes-256-cbc -d > important_backups_decrypted.tar.gz

jbonney / dbuser.sql

Created February 4, 2014 14:25

Create DB backup user. Taken from http://blog.roozbehk.com/post/25580691418/mysql-user-to-backup-databases

	CREATE USER 'dbbackup'@'localhost' IDENTIFIED BY '***';
	GRANT SELECT ,
	RELOAD ,
	FILE ,
	SUPER ,
	LOCK TABLES ,
	SHOW VIEW ON * . * TO 'dbbackup'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

jbonney / .bash_profile

Created February 4, 2014 13:43

Run ssh-agent when you login, and kill it when you logout. Add code to ~/.bash_profile. Taken from http://blog.xk72.com/post/75565726956/ssh-agent

	eval `/usr/bin/ssh-agent -s`
	trap "kill $SSH_AGENT_PID" 0

jbonney / link.txt

Created January 31, 2014 22:42

Ruby Styleguide from GitHub

https://github.com/styleguide/ruby

jbonney / external_ip.sh

Created January 31, 2014 22:25

Finding external IP using external services (http://askubuntu.com/questions/145012/how-can-i-find-my-public-ip-using-the-terminal)

	wget -qO- http://ipecho.net/plain ; echo
	curl ipecho.net/plain ; echo

jbonney / link.txt

Created December 13, 2013 09:51

HTML5+JSON interactive table plugin. Dynatable is a funner, semantic, interactive table plugin using jQuery, HTML5, and JSON. And it's not just for tables.

http://www.dynatable.com/

Jimmy Bonney jbonney

Keybase proof