mttjohnson

# Load environment secrets with with 1Password CLI Injection
# 
# Used with load_secrets.sh
# source load_secrets.sh

# AWS Service Account Credentials
AWS_ACCESS_KEY_ID={{ op://$OP_VAULT/$INF_PROJECT.aws_access_key/username }}
AWS_SECRET_ACCESS_KEY={{ op://$OP_VAULT/$INF_PROJECT.aws_access_key/password }}

# Project Secrets

mttjohnson

Dependencies

Install the following dependencies

brew install pipenv
brew install ffmpeg
pipenv install --python 3.10

Instructions

mttjohnson

-- Query the database to calculate a recommended innodb_buffer_pool_size
-- and get the currently configured value
-- The rollup as the bottom row gives the total for all DBs on the server, where each other row is recommendations per DB.

SELECT 
    TABLE_SCHEMA,
	CONCAT(CEILING(RIBPS/POWER(1024,pw)),SUBSTR(' KMGT',pw+1,1))
	Recommended_InnoDB_Buffer_Pool_Size,
	(
	SELECT 	CONCAT(CEILING(variable_value/POWER(1024,FLOOR(LOG(variable_value)/LOG(1024)))),SUBSTR(' KMGT',FLOOR(LOG(variable_value)/LOG(1024))+1,1))

mttjohnson

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

mttjohnson

# Some output format parameters require newer versions of curl
# These examples were done with Curl 7.54.0 with HTTP/2 Support



# The kind of output you would expect to see with the two functions here (time_url and url_ping) would look like this:

[user@683dd22606f5 /]# URL_TO_CHECK="https://venia.magento.com/graphql?query=query+getProductDetailForProductPage..."

[user@683dd22606f5 /]# time_url "${URL_TO_CHECK}"

mttjohnson

# The check_url recursive function
check_url() {
    THIS_URL="${1}"
    HTTP_RESP_CODE=$(curl -ksI "${THIS_URL}" | grep -i 'HTTP/' | cut -d' ' -f 2)
    echo "${THIS_URL} -> ${HTTP_RESP_CODE}"
    
    if [ "${HTTP_RESP_CODE}" == "301" ] ||  [ "${HTTP_RESP_CODE}" == "302" ]
    then
        HTTP_LOC=$(curl -ksI ${1} | grep -i 'Location: ' | cut -d'_' -f 2)
        HTTP_REDIRECT=$(echo "${HTTP_LOC}" | tail -c +11 | tr -d '\r' | tr -d '\n')

mttjohnson

new_hostname="my-new-hostname"

sudo scutil --set HostName ${new_hostname}
sudo scutil --set LocalHostName ${new_hostname}
sudo scutil --set ComputerName ${new_hostname}
dscacheutil -flushcache

# reboot mac

mttjohnson

# Verify SSL
ssl_domain=mydomainnametotest.com
openssl rsa -noout -modulus -in $ssl_domain.key | openssl md5
openssl req -noout -modulus -in $ssl_domain.csr | openssl md5
openssl x509 -noout -modulus -in $ssl_domain.crt | openssl md5

# Output text of certificate
openssl x509 -text -in /etc/nginx/ssl/$ssl_domain.crt

# Get details of all certs in .crt bundle file to verify certificate chain

mttjohnson

# find the biggest .png files in a sub directory
# referenced from https://www.cyberciti.biz/faq/how-do-i-find-the-largest-filesdirectories-on-a-linuxunixbsd-filesystem/

find . -type f -iname "*.png" -printf '%s %p\n'| sort -nr | head -25

# List all symlinks recursively in a directory
find ./ -type l -printf "%p -> %l\n"
find . -type l -ls

# List all broken symlinks

mttjohnson

#!/usr/bin/env bash

set -eu


########################################
## Introduction
########################################
HELP_INFO=$(cat <<'CONTENTS_HEREDOC'
input_filter v0.1