Ben Smith benjamin-smith

## db-open
#!/bin/bash
set -e

show_help() {
cat << EOF
Usage: ${0##*/} [-u USER] [-p PASS] [-P PORT] [-H HOST] [DATABASE]
       ${0##*/} -h

Open a standard connection in Sequel PRO.

## opening-and-closing-an-ssh-tunnel-in-a-shell-script-the-smart-way.md

      
              1 file
            
          
              48 forks
            
          
              25 comments
            
          
              453 stars
            
          
                scy
                / opening-and-closing-an-ssh-tunnel-in-a-shell-script-the-smart-way.md
            
            
              Last active
              March 15, 2024 11:26
            
              
                Opening and closing an SSH tunnel in a shell script the smart way
              
          
    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

  
## README.mdown

      
              3 files
            
          
              15 forks
            
          
              3 comments
            
          
              65 stars
            
          
                dvessel
                / README.mdown
            
            
              Last active
              May 15, 2020 13:18
            
              
                Sass+Compass, Guard, LiveReload
              
          
    This will enable Sass+Compass with LiveReload through Guard. (Guard screen cast)
You will also need a browser component to communicate with LiveReload.  (browser extension, livereload.js)
If you prefer going through a GUI, that option is available. The following instructions is specific to Mac OS X and it works through the command line.
Note that this is not specific to Rails projects. This can work for any standalone front-end project.
Instructions


## gist:1348779
<!DOCTYPE html>
<html class="no-js">
<head>
  <!-- stuff -->

  <!-- FOUC fix -->
  <style type="text/css">
    .no-js {display: none;}
  </style>
</head>
	#!/bin/bash
	set -e

	show_help() {
	cat << EOF
	Usage: ${0##*/} [-u USER] [-p PASS] [-P PORT] [-H HOST] [DATABASE]
	${0##*/} -h

	Open a standard connection in Sequel PRO.
	<!DOCTYPE html>
	<html class="no-js">
	<head>
	<!-- stuff -->

	<!-- FOUC fix -->
	<style type="text/css">
	.no-js {display: none;}
	</style>
	</head>