zaenk

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

	# Add this snippet to the top of your playbook.
	# It will install python2 if missing (but checks first so no expensive repeated apt updates)
	# [email protected]

	- hosts: all
	gather_facts: False

	tasks:
	- name: install python 2
	raw: test -e /usr/bin/python \|\| (apt -y update && apt install -y python-minimal)

	{
	"private": true,
	// ...
	"#dependencies": "dependencies are the one shipped to the client",
	"dependencies": {
	"babel-polyfill": "^6.7.4",
	"react": "^15.0.0",
	// ...
	"whatwg-fetch": "^0.11.1"
	},

	pipeline {
	// run on jenkins nodes tha has java 8 label
	agent { label 'java8' }
	// global env variables
	environment {
	EMAIL_RECIPIENTS = '[email protected]'
	}
	stages {

	stage('Build with unit testing') {