Stanley Zheng qwo

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

Setup Mac OS X

I've done the same process every couple years since 2013 (Mountain Lion, Mavericks, High Sierra, Catalina) and I updated the Gist each time I've done it.

I kinda regret for not using something like Boxen (or anything similar) to automate the process, but TBH I only actually needed to these steps once every couple years...

5 entertaining things you can find with the GitHub Search API

Let's have some command-line fun with curl, [jq][1], and the [new GitHub Search API][2].

Today we're looking for:

The hottest repositories created in the last week.
The oldest user accounts with zero followers. (So sad.)
Issue trends by language.
Clojure projects defying convention.

mkdir -p /usr/local/etc/nginx/sites-{enabled,available}
cd /usr/local/etc/nginx/sites-enabled
ln -s ../sites-available/default.conf
ln -s ../sites-available/default-ssl.conf

File locations:

nginx.conf to /usr/local/etc/nginx/
default.conf and default-ssl.conf to /usr/local/etc/nginx/sites-available
homebrew.mxcl.nginx.plist to /Library/LaunchDaemons/

Business Models

Advertising

Models	Examples
Display ads	Yahoo!
Search ads	Google

	var gulp = require('gulp'),
	gutil = require('gulp-util'),
	sass = require('gulp-sass'),
	csso = require('gulp-csso'),
	uglify = require('gulp-uglify'),
	jade = require('gulp-jade'),
	concat = require('gulp-concat'),
	livereload = require('gulp-livereload'), // Livereload plugin needed: https://chrome.google.com/webstore/detail/livereload/jnihajbhpnppcggbcgedagnkighmdlei
	tinylr = require('tiny-lr'),
	express = require('express'),

	// Future versions of Hyper may add additional config options,
	// which will not automatically be merged into this file.
	// See https://hyper.is#cfg for all currently supported options.

	module.exports = {
	config: {
	// default font size in pixels for all tabs
	fontSize: 14,

	// font family with optional fallbacks

	#!/usr/bin/env monkeyrunner

	import time

	from com.android.monkeyrunner import MonkeyRunner, MonkeyDevice

	device = MonkeyRunner.waitForConnection()

	# Touch down screen
	device.touch(100, 500, MonkeyDevice.DOWN)

	user www-data;
	worker_processes 4;

	error_log /var/log/nginx/error.log;
	pid /var/run/nginx.pid;

	events {
	worker_connections 1024;
	}