Nick Venenga nijave

## migrate.sh
#!/bin/bash

export PGSSLMODE=prefer

DATABASE=postgres
USER=postgres
SOURCE_PASSWORD=postgres

SOURCE_HOST=$(docker inspect postgres-5433 | jq -r '.[0].NetworkSettings.IPAddress')
SOURCE_PORT=5432

## crystal-disk-mark-fio-bench.sh
#!/bin/bash

LOOPS=3 # How many times to run each test
SIZE=10240 # Size of each test, multiples of 32 recommended for Q32 tests to give the most accurate results.
WRITEZERO=0 # Set whether to write zeroes or randoms to testfile (random is the default for both fio and crystaldiskmark); dd benchmarks typically only write zeroes which is why there can be a speed difference.

QSIZE=$(($SIZE / 32)) #Size of Q32Seq tests
SIZE+=m
QSIZE+=m

## ssh-pod.sh
#!/usr/bin/env bash

pod_name=nick-ssh

# the first node
k8s_node=$(kubectl get nodes -o jsonpath='{.items[0].metadata.name}')

cat <<EOF | kubectl create -f -
apiVersion: v1
kind: Pod

## jellyfin-contine-watching.sql
SELECT
  key, COALESCE(ti.SortName, mi.sortname) SortName, COALESCE(ti.Path, mi.Path) Path
FROM UserDatas u
LEFT JOIN TypedBaseItems ti
ON
  u.key = ti.UserDataKey
  OR REPLACE(u.key, '-', '') = ti.PresentationUniqueKey
LEFT JOIN MediaItems mi
ON
  REPLACE(u.key, '-', '') = mi.PresentationUniqueKey

## iscsi.sh
# List targets
iscsiadm -m discovery --type sendtargets -p <portal host/socket>

# Login to a target
iscsiadm -m node -T <target IQN> -l

# List active/logged in targets
iscsiadm -m session

# Logout of a target

## dns.sh
resolvectl dns tap0 172.16.3.254
resolvectl domain tap0 ~.

## windows-event-logs.ps1
# List
Get-WmiObject win32_nteventlogfile
Remove-EventLog -LogName "Some Log Name"

## tethering.sh
#!/bin/sh

# Don't require DUN APN type
settings put global tether_dun_required 0

# use MagiskHide Props Config
# echo "net.tethering.noprovisioning=true" >> /system/build.prop

# iptables increment TTL for nat packets since carriers block these
# Requires kernel with CONFIG_IP_NF_TARGET_TTL enabled

## Python requests with retries configured
# see https://findwork.dev/blog/advanced-usage-python-requests-timeouts-retries-hooks/

import requests

from requests.adapters import HTTPAdapter, Retry

class TimeoutHTTPAdapter(HTTPAdapter):
    DEFAULT_TIMEOUT = 30

    def __init__(self, *args, **kwargs):

## cluster_dash.py
import boto3
import json

# assumes ASG has tag Name="ECS Cluster - cluster_name"
cluster_name = "some-clsuter"

asgs = [
  {
    "name": asg["AutoScalingGroupName"],
    "instance_type": asg["Instances"][0]["InstanceType"],
	#!/bin/bash

	export PGSSLMODE=prefer

	DATABASE=postgres
	USER=postgres
	SOURCE_PASSWORD=postgres

	SOURCE_HOST=$(docker inspect postgres-5433 \| jq -r '.[0].NetworkSettings.IPAddress')
	SOURCE_PORT=5432
	#!/bin/bash

	LOOPS=3 # How many times to run each test
	SIZE=10240 # Size of each test, multiples of 32 recommended for Q32 tests to give the most accurate results.
	WRITEZERO=0 # Set whether to write zeroes or randoms to testfile (random is the default for both fio and crystaldiskmark); dd benchmarks typically only write zeroes which is why there can be a speed difference.

	QSIZE=$(($SIZE / 32)) #Size of Q32Seq tests
	SIZE+=m
	QSIZE+=m
	#!/usr/bin/env bash

	pod_name=nick-ssh

	# the first node
	k8s_node=$(kubectl get nodes -o jsonpath='{.items[0].metadata.name}')

	cat <<EOF \| kubectl create -f -
	apiVersion: v1
	kind: Pod
	SELECT
	key, COALESCE(ti.SortName, mi.sortname) SortName, COALESCE(ti.Path, mi.Path) Path
	FROM UserDatas u
	LEFT JOIN TypedBaseItems ti
	ON
	u.key = ti.UserDataKey
	OR REPLACE(u.key, '-', '') = ti.PresentationUniqueKey
	LEFT JOIN MediaItems mi
	ON
	REPLACE(u.key, '-', '') = mi.PresentationUniqueKey
	# List targets
	iscsiadm -m discovery --type sendtargets -p <portal host/socket>

	# Login to a target
	iscsiadm -m node -T <target IQN> -l

	# List active/logged in targets
	iscsiadm -m session

	# Logout of a target
	# List
	Get-WmiObject win32_nteventlogfile
	Remove-EventLog -LogName "Some Log Name"
	#!/bin/sh

	# Don't require DUN APN type
	settings put global tether_dun_required 0

	# use MagiskHide Props Config
	# echo "net.tethering.noprovisioning=true" >> /system/build.prop

	# iptables increment TTL for nat packets since carriers block these
	# Requires kernel with CONFIG_IP_NF_TARGET_TTL enabled
	# see https://findwork.dev/blog/advanced-usage-python-requests-timeouts-retries-hooks/

	import requests

	from requests.adapters import HTTPAdapter, Retry

	class TimeoutHTTPAdapter(HTTPAdapter):
	DEFAULT_TIMEOUT = 30

	def __init__(self, args, *kwargs):
	import boto3
	import json

	# assumes ASG has tag Name="ECS Cluster - cluster_name"
	cluster_name = "some-clsuter"

	asgs = [
	{
	"name": asg["AutoScalingGroupName"],
	"instance_type": asg["Instances"][0]["InstanceType"],