Skip to content

Instantly share code, notes, and snippets.

🎯
Focusing

Nicholas Cole ncole458

🎯
Focusing
View GitHub Profile
@ncole458
ncole458 / WIP.txt
Created May 19, 2020
AWS CLI Cheatsheet
View WIP.txt
# Connect Multiple AWS Accounts
aws configure --profile <your-profile-name>
View CronJobLeader.txt
# Inline policy for aws-elasticbeanstalk-ec2-role
{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "Stmt1409855610000",
"Effect": "Allow",
"Action": [
"autoscaling:DescribeAutoScalingGroups"
@ncole458
ncole458 / psql.md
Created Sep 15, 2019
PostgreSQL Cheatsheet
View psql.md

change to postgres user and open psql prompt

sudo -u postgres psql postgres

list databases

postgres=# \l

list roles

@ncole458
ncole458 / .gitignore
Created Mar 4, 2019
Python/Django .gitignore
View .gitignore
### Virtualenv
venv/
### PyCharm
.idea/
### Python
__pycache__/
*.py[cod]
View encode_test.py
# test .encode() and str()
a_string = 'test éurope'
print('a_string normal: ', a_string)
a_string = 'test éurope'
print('a_string utf-8 encoded: ', a_string.encode('utf-8')) # utf-8 is default so .encode() is same result
print('a_string ascii encoded: ', a_string.encode('ascii', 'replace')) # with error, i.e. replace, ignore etc.
print('a_string str: ', str(a_string))
company = 'éuropean company'
pro_comp_name = 'a løng campaigné name'
@ncole458
ncole458 / Ember.js
Created Oct 18, 2018
Ember.js fix node/bower cache issues
View Ember.js
# sometimes Ember builds break due to npm &/or bower cache, node changes etc.
# running below usually fixing any cache issues
rm -rf node_modules/ bower_components/ tmp/ dist/
npm cache clear
bower cache clear
npm install && bower install
ember s
@ncole458
ncole458 / ssl.txt
Last active Sep 15, 2018
TLS/SSL Certificate Generation & Installation
View ssl.txt
# create the cert key request
openssl req -newkey rsa:2048 -nodes -keyout domain.com.key -out domain.com.csr
# concat the bundle and certs
cat domain_com.crt domain_com.ca-bundle > website-bundle.crt
# SSL checker for after install
https://www.sslshopper.com/ssl-checker.html
@ncole458
ncole458 / docker.txt
Last active Oct 15, 2018
Docker commands
View docker.txt
# view container instances
docker container ls
# activate instance, i.e. nginx, django etc.
docker exec -i -t be821b60fa28 /bin/bash
@ncole458
ncole458 / remote-my-sql-ec2-etc.txt
Created Jun 4, 2018
Grant remote access to MySQL database
View remote-my-sql-ec2-etc.txt
# UPDATE AWS EC2 SECURITY GROUPS FIRST TO ALLOW MySQL CONNECTION VIA IP
---
# Edit /etc/mysql/my.cnf, and change the binding address to 0.0.0.0
bind-address = 0.0.0.0
# then restart mysql server
$ sudo /etc/init.d/mysql restart
@ncole458
ncole458 / default
Created May 2, 2018
React app breaks on refresh NGINX
View default
# update the location blocks try_files in your /sites-available/default
location / {
try_files $uri $uri/ /index.html$is_args$args;
}
You can’t perform that action at this time.