tfentonz

dig spf command

$ dig +noall +answer @emily.ns.cloudflare.com roadsafetyrisk.co.nz txt
roadsafetyrisk.co.nz.  	900    	IN     	TXT    	"v=spf1 mx include:sendgrid.net -all"

Note: RFC 7208 section 3.1 SPF SPF records MUST be published as a DNS TXT.

• Sender Policy Framework

tfentonz

rsync -vaz -e "ssh -l USER" \
  --perms \
  --exclude-from FILE \
  --delete-excluded \
  /path/to/sync/ \
  123.45.6.78:/path/to/sync/

tfentonz

wget options

wget -r -q --user $FTP_USER --password $FTP_PASS ftp://erewhon.co.nz/some/path/ --cut-dirs=1 -nH -N

Logging and input file:
  -q,  --quiet                     quiet (no output)
  
Download:
 -N, --timestamping don't re-retrieve files unless newer than

tfentonz

Amazon CLI Commands

EC2

Get instance public hostname

Substitute <NAME> for instance name.

$ aws ec2 describe-instances --query 'Reservations[].Instances[].PublicDnsName' --filters Name=tag:Name,Values= --output text 

tfentonz

Elasticsearch REST API

https://www.elastic.co/guide/en/elasticsearch/reference/0.90/api-conventions.html

curl -w "\n" "localhost:9200/?pretty"

Indices

curl -w "\n" "http://localhost:9200/_stats/?pretty"

tfentonz

#!/bin/bash

aws rds describe-db-instances --query 'DBInstances[].{DBName:DBName,Engine:Engine,EngineVersion:EngineVersion}' |
  jq '[.[] | select(.Engine == "postgres") | {db_name:.DBName,engine:.Engine,engine_version:.EngineVersion}]'
  
exit 0

tfentonz

#!/bin/bash

# Requires an S3 bucket with website redirect for zone apx
# e.g. example.com -> www.example.com
# See http://docs.aws.amazon.com/general/latest/gr/rande.html#s3_region
# for alias target hosted zone ID.
hosted_zone_id="ZABCDEFGHIJ1K"
alias_target_hosted_zone_id="Z1WCIGYICN2BYD"

aws route53 change-resource-record-sets \

tfentonz

psql <database>
CREATE USER <user> WITH PASSWORD '<password>' VALID UNTIL 'infinity';
GRANT CONNECT ON DATABASE <database> TO <user>;
GRANT USAGE ON SCHEMA public TO <user>;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO <user>;
GRANT SELECT ON ALL TABLES IN SCHEMA public to <user>;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO <user>;

tfentonz

ln -nfs /usr/local/Cellar/postgis/2.3.2/share/postgresql/extension/postgis.control /usr/local/Cellar/postgresql@9.5/9.5.6/share/postgresql@9.5/extension/postgis.control
ln -nfs /usr/local/Cellar/postgis/2.3.2/share/postgresql/extension/postgis--2.3.2.sql /usr/local/Cellar/postgresql@9.5/9.5.6/share/postgresql@9.5/extension/postgis--2.3.2.sql

tfentonz

docker inspect $(docker ps -q --filter status=exited) |
  jq '.[].State | { Status: .Status, ExitCode: .ExitCode, FinishedAt: .FinishedAt }'