Casey Link Ramblurr

DF Hack Cheat Sheet

Fun things to do with DF Hack.

DF Hack documentation - where you can find everything

This gist contains all the OpenWRT configuraion files needed to connect to Private Internet Access (PIA) VPN servers. The following files are included:

network: contains configuration to add a virtual network device (i.e. tun1366) and custom DNS servers
openvpn: OpenVPN configuration file to connect to PIA VPN servers
firewall: firewall configuration which passes all traffic through VPN and rejects any request when OpenVPN is down

NOTE: there are a number of other files required to be available under /etc/openvpn for this approach to work:

pia.auth: VPN credentials in two lines, first the username and the second the password

	;; problem: date, time, datetime, and timestamp types in sqlite are basically just strings or numbers.
	;; the sqlite jdbc driver doesn't coerce them into Timestamp, Date or Time types by default
	;; but we want to use proper java.time types!
	;;
	;; solution: supply a builder-fn [0] that correctly returns java.sql.{Date,Time,Timestamp} types (and Boolean while were at it)
	;;
	;; [0]: https://cljdoc.org/d/seancorfield/next.jdbc/1.2.659/doc/getting-started/tips-tricks#sqlite

	(def builder-fn
	(next.jdbc.result-set/builder-adapter

	---
	# Answer from Vladimir Botka @ https://serverfault.com/questions/1040246/how-to-select-network-interface-given-ip-address-in-ansible-across-debian-and-fr/1040273#1040273
	# Tested on Ansible 2.10
	# can this be simplified? Watch https://github.com/ansible/ansible/issues/69638

	- name: find interface name assigned given ip address
	hosts: all
	vars:
	ip_find_iface: "10.1.0.51"
	freebsd_query: >-

	(:requrie [next.jdbc.result-set :as rs]
	[next.jdbc.prepare :as prepare]
	[gungnir.model :as model]
	[jsonista.core :as json]
	[honeysql.format :as hf])
	;; given a table
	;; CREATE TABLE example ( id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, json_value JSONB );
	;; and the corresponding model

	(model/register!

	prebuild-install WARN install No prebuilt binaries found (target=12.16.1 runtime=node arch=x64 platform=linux)
	make: Entering directory '/var/home/ramblurr/src/screeps/screepers/screeps-multimeter/node_modules/bufferutil/build'
	CXX(target) Release/obj.target/bufferutil/src/bufferutil.o
	In file included from ../../nan/nan_converters.h:67,
	from ../../nan/nan.h:202,
	from ../src/bufferutil.cc:7:
	../../nan/nan_converters_43_inl.h: In static member function ‘static Nan::imp::ToFactoryBase<v8::Boolean>::return_t Nan::imp::ToFactory<v8::Boolean>::convert(v8::Local<v8::Value>)’:
	../../nan/nan_converters_43_inl.h:18:51: warning: ‘v8::MaybeLocal<v8::Boolean> v8::Value::ToBoolean(v8::Local<v8::Context>) const’ is deprecated: ToBoolean can never throw. Use Local version. [-Wdeprecated-declarations]
	18 \| val->To ## TYPE(isolate->GetCurrentContext()) \
	\| ^

	# a collection of ansible copypastas
	▄▄▖▄▄▖▄▄▖▄▄▖▄▄▖▄▄▖▄▄▖▄▄▖

	# get python/pip package installed version
	- name: check PACKAGENAME version
	shell: pip list [--user] --format=json \| jq --raw-output '.[] \| select(.name == "PACKAGENAME").version'
	register: PACKAGENAME_installed_version
	changed_when: false
	▄▄▖▄▄▖▄▄▖▄▄▖▄▄▖▄▄▖▄▄▖▄▄▖

	// ==UserScript==
	// @name Imgur: Mobile Cleanup
	// @namespace https://github.com/Zren/
	// @description Cleanup m.imgur.com and always load all images in the album.
	// @icon https://imgur.com/favicon.ico
	// @author Zren
	// @version 2
	// @include https://m.imgur.com/*
	// @grant GM_addStyle
	// ==/UserScript==

	https://jsfiddle.net/2y9jes63/20/
	https://jsbin.com/wesosuxifu/edit?js,output