Skip to content

Instantly share code, notes, and snippets.


Paul Fawkesley fawkesley

View GitHub Profile
fawkesley /
Created Feb 7, 2020
change a booking date

booking server:

select * from bookings where primary_email='<EMAIL>';

(write down the booking UUID, game UUID)

update bookings SET date='<DATE>', game_url='', sent_joining_instructions=false WHERE uuid = '<UUID>';
fawkesley /
Last active Apr 30, 2021
utm_medium / utm_source / utm_campaign
  • utm_medium required - can be e.g. referral, social, email
  • utm_source is required - e.g.
  • utm_campaign is optional e.g. june-giveaway

Use these utm_* parameters in these scenarios:

facebook ad (boosted post / ad)

fawkesley /
Last active Dec 16, 2019
SSH user / authorized keys
export NEW_USER=exampleuser
export NEW_HOME=/home/$NEW_USER
sudo useradd $NEW_USER \
--home $NEW_HOME \
--create-home \
--shell /bin/bash \
--groups ssh
sudo passwd $NEW_USER
fawkesley / .gitconfig
Created Mar 11, 2019
.gitconfig snippet for nice `git log` showing signature status
View .gitconfig
date = relative
pretty = "%C(yellow)%h %C(blue)%<(50,trunc)%s %C(green)%<(8,trunc)%ad %C(reset)%ae%n%>(69,trunc)%C(magenta)%G? %GS%n%-b"
fawkesley /
Created Jan 11, 2019
Raid-1 + LUKS encrypted filesystem

make encrypted luks partition on raid-1 array from free space

  • use cfdisk /dev/sda to create a new partition in free space with type "Linux RAID"
  • repeat for /dev/sdb
  • cat /proc/mdstat to see what /dev/mdX device is next
$ mdadm --create --verbose /dev/md4 --level=1 --raid-devices=2 /dev/sda6 /dev/sdb6
View termtosvg-emoji.svg
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
#!/bin/sh -eu
# fksync
# This scripts keeps your PGP keys in sync with your team by:
# 1. periodically uploading your key to the keyservers
# 2. periodically downloading their keys from the keyservesr
# Note: it can't handle *new* team members. You'll need to get their key the
fawkesley /
Last active Mar 29, 2021
Firefox profile addons and settings
fawkesley / hockeypuck-supervisor.conf
Last active Sep 23, 2018
Installing Hockeypuck with PostgreSQL on
View hockeypuck-supervisor.conf
# /etc/supervisor/conf.d/hockeypuck-supervisor.conf
# Do `service supervisor reload` then start/stop with `supervisorctl start hockeypuck`
command=/home/hockeypuck/bin/hockeypuck -config /home/hockeypuck/etc/hockeypuck/hockeypuck.conf