Sara Lara natchiketa

Opening and closing an SSH tunnel in a shell script the smart way

I recently had the following problem:

From an unattended shell script (called by Jenkins), run a command-line tool that accesses the MySQL database on another host.
That tool doesn't know that the database is on another host, plus the MySQL port on that host is firewalled and not accessible from other machines.

We didn't want to open the MySQL port to the network, but it's possible to SSH from the Jenkins machine to the MySQL machine. So, basically you would do something like

ssh -L 3306:localhost:3306 remotehost

Port Forwarding in Mavericks

Since Mavericks stopped using the deprecated ipfw (as of Mountain Lion), we'll be using pf to allow port forwarding.

####1. anchor file Create an anchor file under /etc/pf.anchors/<anchor file> with your redirection rule like:

This has been incorporated in a small library.

Gist

This is a quick tutorial explaining how to get a static website hosted on Heroku.

Why do this?

Heroku hosts apps on the internet, not static websites. To get it to run your static portfolio, personal blog, etc., you need to trick Heroku into thinking your website is a PHP app. This 6-step tutorial will teach you how.

Basic Assumptions

Comparison of `npm scripts` vs Gulp

`npm scripts`

Pros

npm scripts are low-level and leverage the actual library you want to use (example: "lint": "eslint ./")
package.json is a central place to see what scripts are available (also npm run will list all scripts)
When things get too complicated you can always defer to another file (example: "complex-script": "babel-node tools/complex-script.js")
npm scripts are more powerful than one might first think (pre/post hooks, passing arguments, config variables, chaining, piping, etc...)

Managing plugins in Vim: The basics

Let's say the plugin is at a GitHub URL https://github.com/manasthakur/foo. First get the plugin by either cloning it (git clone https://github.com/manasthakur.foo.git) or simply downloading it as a zip (from its GitHub page).

Adding a plugin in Vim is equivalent to adding the plugin's code properly into its runtimepath (includes the $HOME/.vim directory by default). For example, if the layout of a plugin foo is as follows:

foo/autoload/foo.vim
foo/plugin/foo.vim

	Option 1
	su - postgres
	psql template1
	CREATE USER tom WITH PASSWORD 'myPassword';
	CREATE DATABASE jerry;
	GRANT ALL PRIVILEGES ON DATABASE jerry to tom;

	Option 2:
	su postgres
	postgres@debian: createuser tom

	describe("root context", function(){

	before(function(){
	console.log("before: root");
	});

	beforeEach(function(){
	console.log("beforeEach: root");
	});

	var aws = require('aws-sdk'),
	https = require('https'),
	zlib = require('zlib'),
	util = require('util');

	// If you've used KMS to encrypt your slack, insert your CiphertextBlob here
	var ENCRYPTED_URL = 'AQEC1423...';

	// IF NOT, you can take the risk to insert your Slack URL here
	// e.g. '/services/QWERTY/ASDFGHJ/zxYTinNLK';

 #-------------------------- #
 #
 # @author Ashley Engelund ([email protected]  weedySeaDragon @ github)
 # @date   1/13/17
 #
 # @desc   This is my answer to the Stack Overflow (SO) question:
 #         How can I use a default method to create something in a shared_example,
 #         sometimes overriding it with some other method and parameters for it?
 #
 #         @see http://stackoverflow.com/questions/24872199/rspec-with-reusable-method-for-shared-examples-context