Basri hbasria

Client Side Config

Open up your vpn.ovpn config file, it should add nobind and look something like this:

.....

nobind

.....

	apt-get update
	apt-get install ca-certificates curl
	install -m 0755 -d /etc/apt/keyrings
	curl -fsSL https://download.docker.com/linux/ubuntu/gpg -o /etc/apt/keyrings/docker.asc
	chmod a+r /etc/apt/keyrings/docker.asc

	# Add the repository to Apt sources:
	echo "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/ubuntu $(. /etc/os-release && echo "$VERSION_CODENAME") stable" \| tee /etc/apt/sources.list.d/docker.list > /dev/null
	apt-get update

	$ alias kubens='kubectl config set-context --current --namespace '
	$ alias kubectx='kubectl config use-context '

	// Usage
	$ kubens kube-system //Switch to a different namespace
	$ kubectx docker //Switch to separate context

-systemctl stop pve-cluster
-systemctl stop corosync
-pmxcfs -l
-rm -rf /etc/pve/corosync.conf
-rm -rf /etc/corosync/*

	-- 1. Create a group
	CREATE ROLE readaccess;

	-- 2. Grant usage on schema:
	GRANT USAGE ON SCHEMA schema_name TO readaccess;

	-- 3.1 Grant select for a specific table:
	GRANT SELECT ON table_name TO readaccess;

	-- 3.2 Grant select for multiple tables:

	# send logs for all traffic (including non-html) to google analytics
	#
	# in server block:
	# set $google_analytics_id "UA-THECORRECT-ID";
	# include /srv/nginx/google_analytics;
	#
	# in location blocks:
	# post_action @ga;
	#
	# notes: post_action has been referred to by nginx devs as a "dirty hack" and this approach may stop working one day.

	echo "source <(kubectl completion zsh)" >> ~/.zshrc
	echo 'alias k=kubectl' >> ~/.zshrc
	echo 'complete -F __start_kubectl k' >> ~/.zshrc

	SELECT table_schema AS "Database",
	ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"
	FROM information_schema.TABLES
	GROUP BY table_schema;


	SELECT table_name AS "Table",
	ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
	FROM information_schema.TABLES
	WHERE table_schema = "database_name"

	#!/bin/bash

	# https://gosysop.com/freeipa-password-expiry-notification-script-for-red-hat-identity-management/
	# notifies people a set number of days before expiry, once via email

	# open a kerberos ticket using keytab authentication
	# the following keytab file was made using ktutil with rc4-hmac

	/usr/bin/kinit [email protected] -k -t /sextoys/admin.keytab