koliadych’s gists

koliadych / 21-show-env-and-log.sh

Created May 10, 2026 21:59

fintechner show env and log

	#!/bin/bash
	set -euo pipefail
	export AWS_PAGER=""
	REGION=ap-northeast-1
	INSTANCE_ID=i-089ad4a6b76132ba2

	CMD_ID=$(aws --region "$REGION" ssm send-command \
	--instance-ids "$INSTANCE_ID" \
	--document-name AWS-RunShellScript \
	--parameters 'commands=["sudo awk -F= \"{print $1\\\"=\\\"(length($2)>16?substr($2,1,8)\\\"...\\\":$2)}\" /etc/fintechner/connector.env","echo ---JOURNAL---","sudo journalctl -u fintechner-connector -n 30 --no-pager 2>&1"]' \

koliadych / 22-restore-env.sh

Created May 10, 2026 22:01

fintechner restore connector env

	#!/bin/bash
	# fintechner — rewrite /etc/fintechner/connector.env from Secrets Manager
	# after the hardening script clobbered it.

	set -euo pipefail
	export AWS_PAGER=""
	REGION=ap-northeast-1
	INSTANCE_ID=i-089ad4a6b76132ba2
	ADMIN_EMAIL="koliadych@gmail.com"

koliadych / 23-ws-diag.sh

Created May 10, 2026 22:04

fintechner ws diag

	#!/bin/bash
	set -euo pipefail
	export AWS_PAGER=""
	REGION=ap-northeast-1
	INSTANCE_ID=i-089ad4a6b76132ba2

	CMD_ID=$(aws --region "$REGION" ssm send-command \
	--instance-ids "$INSTANCE_ID" \
	--document-name AWS-RunShellScript \
	--parameters '{"commands":[

koliadych / 24-copy-diag.sh

Created May 10, 2026 22:08

fintechner copy diagnostic

	#!/bin/bash
	set -euo pipefail
	export AWS_PAGER=""
	REGION=ap-northeast-1
	INSTANCE_ID=i-089ad4a6b76132ba2

	CMD_ID=$(aws --region "$REGION" ssm send-command \
	--instance-ids "$INSTANCE_ID" \
	--document-name AWS-RunShellScript \
	--parameters '{"commands":[

koliadych / 25-copy-diag.sh

Created May 10, 2026 22:11

fintechner copy diag v2

	#!/bin/bash
	set -euo pipefail
	export AWS_PAGER=""
	REGION=ap-northeast-1
	INSTANCE_ID=i-089ad4a6b76132ba2

	CMD_ID=$(aws --region "$REGION" ssm send-command \
	--instance-ids "$INSTANCE_ID" \
	--document-name AWS-RunShellScript \
	--parameters '{"commands":[

koliadych / 26-balance-and-strategy-audit.sh

Created May 10, 2026 22:15

fintechner balance + strategy audit

	#!/bin/bash
	set -euo pipefail
	export AWS_PAGER=""
	REGION=ap-northeast-1
	INSTANCE_ID=i-089ad4a6b76132ba2

	CMD_ID=$(aws --region "$REGION" ssm send-command \
	--instance-ids "$INSTANCE_ID" \
	--document-name AWS-RunShellScript \
	--parameters '{"commands":[

koliadych / 27-audit-v2.sh

Created May 10, 2026 22:17

fintechner audit v2 correct schemas

	#!/bin/bash
	set -euo pipefail
	export AWS_PAGER=""
	REGION=ap-northeast-1
	INSTANCE_ID=i-089ad4a6b76132ba2

	CMD_ID=$(aws --region "$REGION" ssm send-command \
	--instance-ids "$INSTANCE_ID" \
	--document-name AWS-RunShellScript \
	--parameters '{"commands":[

koliadych / 28-audit-v3.sh

Created May 10, 2026 22:19

fintechner audit v3

	#!/bin/bash
	set -euo pipefail
	export AWS_PAGER=""
	REGION=ap-northeast-1
	INSTANCE_ID=i-089ad4a6b76132ba2

	# Bundle the SQL queries into a single shell script, run it via base64 on
	# the EC2. Avoids all the JSON-in-SSM-in-bash escape hell.
	SCRIPT_B64=$(base64 -w0 <<'INNER'
	psql() { sudo docker exec timescale psql -U fintechner -d fintechner -c "$1" 2>&1 \| head -15; }

koliadych / 29-redeploy-and-protect.sh

Created May 10, 2026 23:20

fintechner readiness gate 1 + redeploy

	#!/bin/bash
	# fintechner — redeploy (slippage + equity fixes) AND enable termination
	# protection in one shot. Idempotent.
	set -euo pipefail
	export AWS_PAGER=""

	REGION=ap-northeast-1
	INSTANCE_ID=i-089ad4a6b76132ba2

	echo "=== 1. Enable EC2 termination protection ==="

koliadych / 30-alarms.sh

Created May 10, 2026 23:28

fintechner CloudWatch health alarms

	#!/bin/bash
	# fintechner — readiness gate #6: CloudWatch health alarms + email SNS.
	# Catches "EC2 unreachable / instance dead" cases that in-process alerts
	# can't surface. ~$0/mo (SNS first 1k notifications free, alarms first 10 free).
	set -euo pipefail
	export AWS_PAGER=""

	REGION=ap-northeast-1
	INSTANCE_ID=i-089ad4a6b76132ba2
	EMAIL=koliadych@gmail.com

Fintechner koliadych