Da-Juan

"""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

Da-Juan

#!/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

Da-Juan

#!/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

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                          

Da-Juan

#!/usr/bin/python3
import random

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

Da-Juan

#!/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 = '=',

Da-Juan

#!/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                                                  

Da-Juan

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

Da-Juan

#!/bin/bash

# Enable Extended Globbing
shopt -s extglob

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

# Scriptable version
function join_by {

Da-Juan

docker run --name debian9 --hostname debian9 -d debian:9 /bin/bash -c "trap : TERM INT; sleep infinity & wait"