Pastebin: SSH forwardingを介してMySQL DBに接続する方法

Format

Shell

Post date

2016-01-14 13:15

Publication Period

Unlimited

 # Set the path of sshpass command to SSHPASS if you have it on your system.
 SSHPASS=
 
 # Create SSH forwarding setting (to connect to MySQL DB through a SSH tunnel)
 function create_ssh_tunnel {
         local HOST=$1
         local LPORT=$2
         local RPORT=$3
         echo "SSH host is " ${HOST}
         echo "SSH tunnel: local port  = " ${LPORT}
         echo "SSH tunnel: remote port = " ${RPORT}
 
         local PROC_SSH=`ps -a | awk -e '/ssh/{print $1;}'`
         if [ -n "${PROC_SSH}" ]; then
                 echo "Kill remained tunnel ..."
                 kill ${PROC_SSH}
         fi
         echo "Creating SSH tunnel to ${HOST} ..."
         ${SSHPASS} ssh -f -C -N -L ${LPORT}:localhost:${RPORT} -l ${REMOTE_USER} ${HOST}
 }
 
 # Delete SSH tunnel
 function delete_ssh_tunnel {
         local PROC_SSH=`ps -a | awk -e '/ssh/{print $1;}'`
         if [ -n "${PROC_SSH}" ]; then
                 kill ${PROC_SSH}
                 if [ $? -ne 0 ]; then
                         echo "Error! - cannot kill SSH tunnel process"
                         exit
                 fi
         else
                 echo "SSH tunnel is not exist."
         fi
 }
 
 # Create SSH tunnel for DB access  SSH forwarding設定 (tunnel作成)
 create_ssh_tunnel ${HOST} ${LPORT} ${RPORT}
 
 # SQL command is written in $(SQLFILE)
 SQLFILE=my.sql
 
 # Connect to MySQL database server 
 cat ${SQLFILE} | mysql -P ${LPORT} -u ${DB_USER} -h 127.0.0.1 $(DBNAME)
 
 # Delete SSH tunnel  SSH tunnel削除
 delete_ssh_tunnel