Jimmy Bonney jbonney

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                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:

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

## drop_tables.sh
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}

## remove_kernels.sh
# 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

## encrypt_decrypt.sh
#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

## dbuser.sql
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 ;

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

## link.txt
https://github.com/styleguide/ruby

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

## link.txt
http://www.dynatable.com/
	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}
	# 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
	#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
	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 ;
	wget -qO- http://ipecho.net/plain ; echo
	curl ipecho.net/plain ; echo