Lino Steenkamp linosteenkamp

Install the required MacOS software

brew install gnupg2 pinentry-mac
brew install --cask gpg-suite
brew install ykman

	#!/bin/bash

	# CSV to JSON converter using BASH
	# original script from https://gist.github.com/dsliberty/3de707bc656cf757a0cb
	# Usage ./csv2json.sh input.csv > output.json

	shopt -s extglob

	input="${1:-/dev/stdin}"
	SEP=","

	#!/bin/bash

	# Path to speedtest-cli (Change this to match the path to your speedtest-cli executable)
	SPEEDTEST_CLI_PATH="/usr/local/bin/speedtest-cli"

	# Path to the sqlite database (Change this to suit your needs)
	#DB_PATH="/home/lino/speedlog.db"
	DB_PATH="/var/www/speedtest-api/speedtest.db"

	# Create test table SQL statement

	#!/bin/bash

	# URL for speedtest-api (Change this to match your setup)
	URL="localhost:3000/api/test/create"

	# Path to speedtest-cli (Change this to match the path to your speedtest-cli executable)
	SPEEDTEST_CLI_PATH="/usr/local/bin/speedtest-cli"

	# Input Field Seperator for splitting the CSV result into an array
	IFS=","

	#!/bin/bash

	# Add md5 hash to the end every line in a CSV file
	# Usage ./hash_csv_records.sh input.csv > output.csv

	input="${1:-/dev/stdin}"
	SEP=";"


	if [[ $(uname) == 'Linux' ]]; then

	#! /bin/bash

	BACKUP_DESTINATION="/Users/linosteenkamp/Database/Backups"
	MYSQL_CONNECTION="aax-k8s-mysql-develop"

	display_usage() {
	if ! command -v mysql_config_editor > /dev/null; then
	Echo "MySQL not Installed!"
	Echo "Please install MySQL before using this script"
	exit 1

	backup_path="~/sql_restore/"

	dbs=$(find $backup_path -type f -name "*.gz" \| sort)

	echo "========================== Restore Database ===================================="

	for db in $dbs;
	do
	dbname=`echo $db \| basename $db \| awk '{print substr($0, 1, index($0, ".") -1 )}'`

	#!/bin/bash

	CKD_KEY="client-key-data"
	CCD_KEY="client-certificate-data"
	CAD_KEY="certificate-authority-data"

	json=$(kubectl config view --raw -o json)

	#- Retrieve Certificates and Keys for all contexts
	echo "$json" \| jq -c '.contexts[].context' \| while read line

	#!/bin/bash

	pemFiles=/etc/letsencrypt/live/steenkamps.org/*.pem
	pemMd5=/etc/letsencrypt/live/steenkamps.org/pem.md5
	certPath=/etc/letsencrypt/live/steenkamps.org
	cert=cert.pem
	key=privkey.pem
	sshIdentity=/root/.ssh/id_rsa
	mikrotikUser=admin
	mikrotikIp=192.168.1.254