Wesley C. Hinkle evokateur

How to use Ruby on Cygwin

It is strongly recommended to run on Linux or OS X. Maybe many problems will happen.

Prerequisite

Cygwin
apt-cyg
http_proxy is set if needed

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

	# Apple Silicon laptops with firmware > 13.0 have a native charge threshold that does not required any userspace daemon running.
	# This native limit works even when the laptop is sleeping or powered off therefore it is preferable to the userspace daemon.
	# Nonetheless, it only works with fixed thresholds (80% as upper limit and 70% as lower limit).
	# CHWA key is the one used to enable/disable the native limit. 01 = 80% limit, 00 = no limit
	##
	typeset -g smc_command="/usr/local/bin/smc"
	typeset -g smc_charge_limit_key="CHWA"
	typeset -g smc_charge_limit_status_on="01"
	typeset -g smc_charge_limit_status_off="00"

	# Ignore everything in the root except the "wp-content" directory.
	/*
	!.gitignore
	!wp-content/

	# Ignore everything in the "wp-content" directory, except the "mu-plugins", "plugins", and "themes" directories.
	wp-content/*
	!wp-content/mu-plugins/
	!wp-content/plugins/
	!wp-content/themes/

	*~
	.DS_Store
	.svn
	.cvs
	*.bak
	*.swp
	Thumbs.db

	# wordpress specific
	wp-config.php

	# -- mode: ruby --
	# vi: set ft=ruby :

	PASSWORD_PATH = ".password"
	PASSWORD_ID_PATH = ".password_id"

	# Make sure to have installed vagrant-triggers plugin
	# > vagrant plugin install vagrant-triggers

	# After the first `vagrant up` stop the VM and execute the following steps

	<?php
	$serverName = "sqlserver.example.com";
	$database = "myDbName";
	$uid = 'sqlserver_username';
	$pwd = 'password';

	try {
	$conn = new PDO(
	"sqlsrv:server=$serverName;Database=$database",
	$uid,