Skip to content

Instantly share code, notes, and snippets.

@woowa-hsw0
woowa-hsw0 / filesystem.txt
Created June 7, 2018 02:30
EKS Worker node info
$ tree /opt/
/opt/
├── aws
│   ├── apitools
│   │   ├── cfn-init -> ./cfn-init-1.4-30.amzn2
│   │   └── cfn-init-1.4-30.amzn2
│   │   ├── bin
│   │   │   ├── cfn-elect-cmd-leader
│   │   │   ├── cfn-get-metadata
│   │   │   ├── cfn-hup
@woowa-hsw0
woowa-hsw0 / copy_database.sql
Created December 14, 2017 23:55
RENAME DATABASE / COPY DATABASE in MySQL
SELECT @src_schema := 'dbname', @dst_schema := 'dbname_bak';
SELECT concat(
'CREATE TABLE ',
'`', @dst_schema, '`', '.',
'`', TABLE_NAME, '`', ' LIKE ',
'`', @src_schema, '`', '.',
'`', TABLE_NAME, '`', ';'
) q
@woowa-hsw0
woowa-hsw0 / assume_role.sh
Last active January 11, 2023 11:36
Start AWS CLI Session with MFA Enabled (+Yubikey)
#!/bin/bash
set -eu
umask 0022
if [[ $# -lt 1 ]]; then
echo "Usage: $0 role_name [AWS ACCOUNT NUMBER]" >&2
exit 1
fi
@woowa-hsw0
woowa-hsw0 / iam_to_smtp.py
Created November 24, 2016 01:17
AWS Secret key -> SES SMTP Password
#!/usr/bin/env python
# -*- coding: utf-8 -*-
# https://docs.aws.amazon.com/ko_kr/ses/latest/DeveloperGuide/smtp-credentials.html
from getpass import getpass
from hmac import HMAC
from hashlib import sha256
key = getpass('AWS Secret Access Key: ')

Keybase proof

I hereby claim:

  • I am woowa-hsw0 on github.
  • I am woowa_hsw0 (https://keybase.io/woowa_hsw0) on keybase.
  • I have a public key ASDgMRMsgG2O0H6Rnapo-aQVY5_nqBP_Z0fE50kQJ38qbgo

To claim this, I am signing this object:

@woowa-hsw0
woowa-hsw0 / pgp-3A8DBA5E.pub
Last active March 6, 2019 01:57
PGP Public key
-----BEGIN PGP PUBLIC KEY BLOCK-----
mQINBFbX/wABEADh76i6ZReJPQnK027d657EU0uOmFTveije+BStPONJEiYq7+WK
P2s+YGmQP+KbhQHPt6qQB5hwJmYCBNnse41Tu2TF+dpQuOkfIakfyX+v9Z9h/bfH
SswSKo/A3iFhAxLkVdK7L7MJyM9yE+RrjsK50hsBknLyd6F8f3E/jUN5p+v9YC0q
mpjyMb5SgVidxTytj88C5oLCTvi4mfd2Qb17MazUN73aG+rYd7oRvLVR/Or+r393
qwrqLLeG1LK1UoHT/8sKEElDhISPL+iJRH9ojdmhmT9G61Uz342BoxxNb41nMRNp
z0IJt34duLUfBffqQplAuXy5oZefDSG8/KlCZjQie2Nj2rQG8M1if98mvp2KdHcB
BzMs0viZwpP4+HpG7zwvfPK0l/+wlt0r8TuySBByLYWiCq3tCzScpvdqyZBRBa0V
BSfa3U1li8tFFgRtAmC0L/a3bjXSL5OvkHZAx+ZtH5zWA8oZ5W5CAJNq3FTyJnVm