Nicolas Rouanet Da-Juan

Here is a work around to automate OCSP stapling on Opnsense with HAproxy plugin.

Hope it helps :)

I created a script based on acme.sh's haproxy deploy hook.

As /tmp is emptied on reboot you need to regenerate ocsp files on startup so I put the script as a startup script: /usr/local/etc/rc.syshook.d/start/99-ocsp (symoblic links in rc.syshook.d don't work).

#!/bin/sh

ffmpeg cheat sheet

Re-encode mkv to h264 keeping audio and subtitles tracks

ffmpeg -i input.mkv -map 0:1 -map 0:a -map 0:s -c:a copy -c:s copy -c:v libx264 output.mkv

Explanations:

-map 0:1 select first video stream

	"""Prometheus exporter with background metrics gathering."""
	import signal
	import threading
	import time
	from typing import TYPE_CHECKING

	import schedule
	from flask import Flask
	from prometheus_client import Gauge, make_wsgi_app
	from werkzeug.middleware.dispatcher import DispatcherMiddleware

	#!/usr/bin/env bash

	# This script requires postgresqltuner.pl:
	# apt install libdbd-pg-perl libdbi-perl perl-modules
	# wget -O /usr/local/bin/postgresqltuner.pl https://postgresqltuner.pl
	# chmod +x /usr/local/bin/postgresqltuner.pl

	OUTPUT_DIR="/var/lib/postgresqltuner"
	# Max number of files to keep for each database
	MAX_COPIES=3

	#!/usr/bin/env bash
	#
	# Get certificates validity dates for a list of domains
	#
	while read -r domain; do
	echo "$domain"
	echo \| openssl s_client -connect "$domain":443 -status 2>&1 \| openssl x509 -dates -noout
	done < domains

	#!/usr/bin/python3
	import random

	people = [
	"Foo",
	"Bar",
	"Baz",
	"Qux",
	"Quux",
	"Corge",

	#!/usr/bin/env python3
	"""Display a progressbar."""
	import sys
	import time


	def progressbar(
	progress: int, total: int,
	percentage: bool = True, bar_width: int = 40,
	todo: str = ' ', done: str = '=',

	#!/usr/bin/env python3
	"""Percentage output."""
	count = 0
	items_nb = 500000

	while True:
	# You can replace .0f by .2f to output decimals
	print(f'{count * 100 / items_nb:.0f}%', end='\r')
	count += 1

	#!/bin/bash

	# Enable Extended Globbing
	shopt -s extglob

	# Simple version
	rm !(a\|b\|c)

	# Scriptable version
	function join_by {