1 files changed, 48 insertions, 0 deletions
diff --git a/packages/scripts-cern/resources/bin/database-tunnels.sh b/packages/scripts-cern/resources/bin/database-tunnels.sh
new file mode 100755
index 0000000..1f74c84
--- /dev/null
+++ b/packages/scripts-cern/resources/bin/database-tunnels.sh
@@ -0,0 +1,48 @@
+#!/bin/bash
+REMOTE_UNC_PATH="//cerndfs.cern.ch/dfs/Applications/Oracle"
+AISADM_IP=aisadm.cern.ch
+AISADM_FINGERPRINT="`dirname \"$0\"`/../lib/aisadm-fingerprint"
+SSH_USER=$USER
+TNSNAMES="$HOME/.cache/tnsnames"
+LOCAL=false
+TEMP=`getopt -o phl: --long help,local,user: \
+     -n '$0' -- "$@"`
+if [ $? != 0 ] ; then echo "Failed to parse arguments..." >&2 ; exit 1 ; fi
+
+# Note the quotes around `$TEMP': they are essential!
+eval set -- "$TEMP"
+
+function print() { echo -e "\e]0;$1\a"; echo "$1"; }
+
+while true ; do
+    case "$1" in
+        -p|--local) LOCAL=true ; shift ;;
+        -l|--user) shift; SSH_USER=$1; shift ;;
+        -h|--help) echo "$0 [--help|--local] [-l <name>|--user <name>]"; exit 0;;
+        --) shift ; break ;;
+        *) echo "Internal error! ($*)" ; exit 1 ;;
+    esac
+done
+
+if ! $LOCAL; then
+    print "Mirror tnsnames.ore files to $TNSNAMES" &&
+        mkdir -p "$TNSNAMES/admin" "$TNSNAMES/admin_localhost" &&
+        smbclient -k "$REMOTE_UNC_PATH" -D ADMIN_localhost -TXc - 'ADMIN_localhost/OLD' | tar --strip-components=2 -x -C "$TNSNAMES/admin_localhost" &&
+        smbclient -k "$REMOTE_UNC_PATH" -D ADMIN -TXc - 'ADMIN/OLD'| tar --strip-components=2 -x -C "$TNSNAMES/admin" ||
+            echo "failed to mirror tnsnames to $TNSNAMES" >&2
+fi
+
+if $LOCAL; then
+    SSH_EXTRAOPTS="-oProxyCommand=ssh -l \"$SSH_USER\" lxplus.cern.ch nc $AISADM_IP 22"
+else
+    true
+fi
+
+print "Database Tunnel" &&
+    ssh -l "$SSH_USER" \
+        -L 10301:cman1.cern.ch:10300 -L 10302:cman2.cern.ch:10300 \
+        -o UserKnownHostsFile=$AISADM_FINGERPRINT \
+        ${SSH_EXTRAOPTS:+"$SSH_EXTRAOPTS"} \
+        $AISADM_IP \
+        "date; echo tunnel is running; cat"
+