scy

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

mttjohnson

Search through a specific user's gists

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

user:mttjohnson gist

davidalger

Setup memory log on php-fpm pool

1. 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';

davidalger

<?php

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

gboudreau

Generating Authy passwords on other authenticators

---

*update: TBC, but this new might affect how easy it is to use this technique past August 2024: Authy is shutting down its desktop app | The 2FA app Authy will only be available on Android and iOS starting in August

---

This gist, based in part on a gist by Brian Hartvigsen, allows you to export from Authy your TOTP tokens you have stored there.
Those can be "standard" 6-digits / 30 secs tokens, or Authy's own version, the 7-digits / 10 secs tokens.

CNanninga

#!/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"

erikhansen

#!/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

erikhansen

#!/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' {}

perryholden

<?php
/**
 * dangerous_functions.php
 * Perry Holden <perry.holden@gmail.com>
 *
 * 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])) {

davidalger

General cheatsheet

• https://tmuxcheatsheet.com/
• https://gist.github.com/MohamedAlaa/2961058

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