fenchu

NSSM cheatsheat

See: NSSM - the Non-Sucking Service Manager

Create a new service
List parameters for a service
Set a parameter for a service
Parameter list

Create a new service

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

	#!groovy
	# Best of Jenkinsfile
	# `Jenkinsfile` is a groovy script DSL for defining CI/CD workflows for Jenkins
	node {
	}

	# Compile/install GEOS. Taken from:
	# http://grasswiki.osgeo.org/wiki/Compile_and_Install_Ubuntu#GEOS_2

	cd /tmp
	wget http://download.osgeo.org/geos/geos-3.4.2.tar.bz2
	bunzip2 geos-3.4.2.tar.bz2
	tar xvf geos-3.4.2.tar

	cd geos-3.4.2

	#!/bin/bash

	sudo apt-get install git python-pip make build-essential libssl-dev zlib1g-dev libbz2-dev libreadline-dev libsqlite3-dev curl
	sudo pip install virtualenvwrapper

	git clone https://github.com/yyuu/pyenv.git ~/.pyenv
	git clone https://github.com/yyuu/pyenv-virtualenvwrapper.git ~/.pyenv/plugins/pyenv-virtualenvwrapper

	echo 'export PYENV_ROOT="$HOME/.pyenv"' >> ~/.bashrc
	echo 'export PATH="$PYENV_ROOT/bin:$PATH"' >> ~/.bashrc

	import json, datetime

	class RoundTripEncoder(json.JSONEncoder):
	DATE_FORMAT = "%Y-%m-%d"
	TIME_FORMAT = "%H:%M:%S"
	def default(self, obj):
	if isinstance(obj, datetime.datetime):
	return {
	"_type": "datetime",
	"value": obj.strftime("%s %s" % (