Colin Wilson colinwilson

## postgresql-geoip.sql
--
-- GEOIP IN POSTGRESQL
--

-- We use two approaches. First using PostgreSQL inet and cidr types and indexing (PostgreSQL 9.4 and later),
-- and then using ip4r (https://github.com/RhodiumToad/ip4r).
-- The performance of ip4r indexes is significantly better than PostgreSQL's own index.
-- An operation that took 42s using ip4r took 47 minutes using PostgreSQL's cidr index.

--

## hb_h.265_720p.sh
#!/bin/bash

# This script uses HandBrakeCLI to automatically convert a folder containing video files to H.265 (HEVC).
# You need to substitute SRC -- Source folder, DEST -- Destination folder,
# PRESET -- Preset name, & PRESET_FILE -- Preset file (json) for your own values

SRC="/root/video_in"
DEST="/root/video_out"
DEST_EXT=mkv
HANDBRAKE_CLI=HandBrakeCLI

## hbap720p.json
{
  "PresetList": [
    {
      "AudioCopyMask": [
        "copy:aac",
        "copy:ac3",
        "copy:dtshd",
        "copy:dts",
        "copy:mp3",
        "copy:truehd",

## hb_h.265_2160p.sh
#!/bin/bash

# This script uses HandBrakeCLI to automatically convert a folder containing video files to H.265 (HEVC).
# You need to substitute SRC -- Source folder, DEST -- Destination folder,
# PRESET -- Preset name, & PRESET_FILE -- Preset file (json) for your own values

SRC="/root/video_in"
DEST="/root/video_out"
DEST_EXT=mkv
HANDBRAKE_CLI=HandBrakeCLI

## hbap4k.json
{
  "PresetList": [
    {
      "AudioCopyMask": [
        "copy:aac",
        "copy:ac3",
        "copy:dtshd",
        "copy:dts",
        "copy:mp3",
        "copy:truehd",

## kemp-cert-update_v1.2.sh
#!/bin/sh

#
# Title: Auto-Update & Upload LetsEncrypt Certs to KEMP LoadMaster
# Guide/Source: https://colinwilson.uk/2017/06/19/auto-update-ssl-certificates-on-kemp-loadmaster-via-pfsense-lets-encrypt/
# Created: 12/06/2017
# Update: 05/12/2018
# Author: Colin Wilson [https://github.com/colinwilson]
# Vendor or Software Link: https://www.pfsense.org/ , https://kemptechnologies.com
# Version: 1.2.1

## LICENCE SUBLIME TEXT
## Sublime Text 3 Serial key build is 3176

> * Added these lines into  /etc/hosts

127.0.0.1       www.sublimetext.com
127.0.0.1       license.sublimehq.com

> * Used the license key

----- BEGIN LICENSE -----

## KEMP SSO Image Set Partial Structure.txt
imagesets/    <------  tar this directory
    MY IMAGE SET/
        lm_initial.html
        lm_logout.html
        MANIFEST
        INFO
        lm_sso.js

        ....

## KEMP Blank SSO Image Set lm_inital.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; CHARSET=utf-8">
    <title>KEMP Login Screen</title>
    <meta content="NOINDEX, NOFOLLOW" name="Robots">
    <link rel="shortcut icon" href="/lm_auth_proxy?LMimage=favicon.ico" type="image/x-icon">
    <link href="/lm_auth_proxy?LMimage=kmgstyle.css" type="text/css" rel="stylesheet">
<style type="text/css">
body

## KEMP Custom SSO Image Set Structure.txt
imagesets/
    MY IMAGE SET/
        lm_initial.html
        lm_logout.html
        MANIFEST
        INFO
        lm_sso.js
        espblank.gif
        espbottom.gif
        favicon.ico