Skip to content

Instantly share code, notes, and snippets.

@utkuturunc
Created September 18, 2019 22:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save utkuturunc/6a648776ea829bb745e1702f32e6f400 to your computer and use it in GitHub Desktop.
Save utkuturunc/6a648776ea829bb745e1702f32e6f400 to your computer and use it in GitHub Desktop.
Tunnel for mssql
ssh -nNT -L local_port:db_host:db_port user@tunnel_ip -N
mssql-cli --username username@host --database db --password 'pass' --server 127.0.0.1,local_port
sudo ip rule add from $(ip route get 1 | grep -Po '(?<=src )(\S+)') table 128
sudo ip route add table 128 to $(ip route get 1 | grep -Po '(?<=src )(\S+)')/32 dev $(ip -4 route ls | grep default | grep -Po '(?<=dev )(\S+)')
sudo ip route add table 128 default via $(ip -4 route ls | grep default | grep -Po '(?<=via )(\S+)')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment