blob: 1f74c848f9edf0e66ce741c2c908a5b86f0713c9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
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"
|
