xchinjo hank xchinjo

MongoDB C# Driver Cheat Sheet

As of releasing MongoDB 3.4 and C# Driver v2.4, original cheatsheet by Derek is outdated. In addition, it has some deficiencies like connecting to MongoDB, creating indexes, etc. This updated version works fine with C# Driver v2.4.7 and MongoDB v3.4.

Setup

Define Document Models

Note: Defined models and collections will be used in entire cheatsheet.

How to setup next.js app on nginx with letsencrypt

next.js, nginx, reverse-proxy, ssl

1. Install nginx and letsencrypt

$ sudo apt-get update
$ sudo apt-get install nginx letsencrypt


	## Block SQL injections
	set $block_sql_injections 0;
	if ($query_string ~ "union.select.\(") {
	set $block_sql_injections 1;
	}

	if ($query_string ~ "union.all.select.*") {
	set $block_sql_injections 1;
	}

	### 1: Drop invalid packets ###
	/sbin/iptables -t mangle -A PREROUTING -m conntrack --ctstate INVALID -j DROP

	### 2: Drop TCP packets that are new and are not SYN ###
	/sbin/iptables -t mangle -A PREROUTING -p tcp ! --syn -m conntrack --ctstate NEW -j DROP

	### 3: Drop SYN packets with suspicious MSS value ###
	/sbin/iptables -t mangle -A PREROUTING -p tcp -m conntrack --ctstate NEW -m tcpmss ! --mss 536:65535 -j DROP

	### 4: Block packets with bogus TCP flags ###

	#!/bin/bash -e

	# --------------------------------------------------------
	# Generate iOS Launch items from a single image
	# (c) 2017 ePi Rational, Inc.
	#
	# Modified from original script which generated app icons for iOS,
	# originally written by
	# Ben Clayton, Calvium Ltd.
	# https://gist.github.com/benvium/2be6d673aa9ac284bb8a

	package chemp.notes.linenotify;
	import java.io.*;
	import java.net.*;
	import java.util.regex.Pattern;

	public class LineNotify {
	private static final String strEndpoint = "https://notify-api.line.me/api/notify";

	public boolean callEvent(String token, String message) {
	boolean result = false;

	# HEADER: This file was autogenerated at 2016-11-29 20:10:40 -0800
	# HEADER: by puppet. While it can still be managed manually, it
	# HEADER: is definitely not recommended.
	# -----------------------------
	# PostgreSQL configuration file
	# -----------------------------
	#
	# This file consists of lines of the form:
	#
	# name = value