Matt Johnson mttjohnson

Opening and closing an SSH tunnel in a shell script the smart way

I recently had the following problem:

From an unattended shell script (called by Jenkins), run a command-line tool that accesses the MySQL database on another host.
That tool doesn't know that the database is on another host, plus the MySQL port on that host is firewalled and not accessible from other machines.

We didn't want to open the MySQL port to the network, but it's possible to SSH from the Jenkins machine to the MySQL machine. So, basically you would do something like

ssh -L 3306:localhost:3306 remotehost

Search through a specific user's gists

https://gist.github.com/search?q=user%3Amttjohnson+gist

user:mttjohnson gist

Setup memory log on php-fpm pool

Added the following to /usr/local/lib/strangecode_php_memory_log.php

 <?php
 function strangecode_php_memory_log()
 {
     $current = memory_get_usage() / 1024 / 1024;
     $peak = memory_get_peak_usage() / 1024 / 1024;

$uri = $_SERVER['REQUEST_URI'] ?? 'n/a';

Exporting your 2FA tokens from Authy to transfer them into another 2FA application

IMPORTANT - Update regarding deprecation of Authy desktop apps

Past August 2024, Authy stopped supported the desktop version of their apps:
See Authy is shutting down its desktop app | The 2FA app Authy will only be available on Android and iOS starting in August for details.

And indeed, after a while, Authy changed something in their backend which now prevents the old desktop app from logging in. If you are already logged in, then you are in luck, and you can follow the instructions below to export your tokens.

If you are not logged in anymore, but can find a backup of the necessary files, then restore those files, and re-install Authy 2.2.3 following the instructions below, and it should work as expected.

General cheatsheet

long buffer support

Add the following to ~/.tmux.conf for long buffer support and ability to write to file afterwards:

set-option -g history-limit 250000

	#!/bin/bash

	SOURCE_DB_NAME="example_prod"
	SOURCE_ROOT_DIR="/var/www/prod"
	SOURCE_DUMP_FILENAME=example_prod_$(date +%F).sql.gz

	TARGET_DB_NAME="example_stage"
	TARGET_ROOT_DIR="/var/www/stage"
	TARGET_SSH_USER="www-stage"
	TARGET_SSH_HOST="stage.example.com"

	#!/bin/bash
	# stop on errors
	set -e
	# turn on debugging if you're running into issues
	#set -x

	# Static variables
	ENVIRONMENT=$1
	RED='\033[0;31m'
	NC='\033[0m' # No Color

	#!/bin/bash
	# This script crawls all urls in a /sitemap.xml file and loads them, effectively priming the cache
	# Usage: ./warm_cache.sh www.example.com

	time wget --quiet https://$1/sitemap.xml --output-document - \| \
	egrep -o "https?://[^<]+" \| \
	grep $1 \| \
	grep -v "jpg" \| \
	xargs -i -d '\n' curl --output /dev/null --silent --write-out '%{http_code} %{time_total}ms %{url_effective} \n' {}

	<?php
	/**
	* dangerous_functions.php
	* Perry Holden <[email protected]>
	*
	* Usage: php dangerous_functions.php [type: folder\|file] [folder_or_filename]
	* Example: php dangerous_functions.php folder vendor/businessname/module-name
	*/

	if (!isset($argv[1])) {

	<?php

	header('Cache-Control: private');
	phpinfo();