hazmei

### application path for custom binaries ie. terraform / trivy
export PATH=/Users/***/Desktop/app:$PATH

### git aliases ###
alias g="git"
alias ga="git add"
alias gd="git diff"
alias gg="git grep"
alias gl="git log"
alias gm="git merge"

hazmei

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

hazmei

Keybase proof

I hereby claim:

• I am hazmei on github.
• I am hazmei (https://keybase.io/hazmei) on keybase.
• I have a public key ASDcHKwdCclf6b2fyX3LOmzl-Krivv-x718df-INcVmtsQo

To claim this, I am signing this object:

hazmei

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname

hazmei

# save it as /etc/profile.d/ssh-telegram.sh
USERID="<target_user_id>"
KEY="<bot_private_key>"
TIMEOUT="10"
URL="https://api.telegram.org/bot$KEY/sendMessage"
DATE_EXEC="$(date "+%d %b %Y %H:%M")"
TMPFILE='/tmp/ipinfo-$DATE_EXEC.txt'
if [ -n "$SSH_CLIENT" ]; then
	IP=$(echo $SSH_CLIENT | awk '{print $1}')
	PORT=$(echo $SSH_CLIENT | awk '{print $3}')

hazmei

#!/usr/bin/python
import os
import os.path
import re
import time
import json
import subprocess

# script to create an ssh tunnel from a public server back to a private (firewalled/NATted) machine; a poor man's VPN, basically