1

Script to establish SSH tunnel and then run another program that uses the tunnel

view story
linux-howto

http://askubuntu.com – I am running a GUI app (Gnucash) that connects to a remote Postgres database via a secure shell session. I can use the SSH -L command to tunnel a local port and then separately run Gnucash and this works fine. What I'd like to do is use a single shell script that sets up the tunnel and then calls Gnucash. Is that possible? If so, how do I do it? Currently, I run commands like the following in 2 separate terminal windows: ssh -L 5433:127.0.0.1:19097 username@myserver.com.au gnucash postgres://gnucash@localhost:5433/gnucash_db If I simply put both lines in a shell script, the first line dr (HowTos)

funckax's picture
Submitted by funckax on 08/29/2012

Stories similar to Script to establish SSH tunnel and then run another program that uses the tunnel

Gnucash is a great tool to keep the budget of the family, and from the version 2.4.0 supports connection to a database, SQLite, MySQL or PostgreSQL for data storage. Using a local database, however, tie to a specific computer for its use. Instead I want to be able to open a GnuCash session from any computer and connect to a single, remote, database.

GnuCash, a personal and small-business financial/accounting software, freely licensed under GNU GPL and available for GNU/Linux, BSD, Solaris, Mac OS X and Microsoft Windows platforms, is now at version 2.4.12.

Unlike the previous version, which included only a couple of fixes, GnuCash 2.4.12 is a lot bigger and comes with tons of changes.

Highlights of GnuCash 2.4.12:

• Renumbering subacc

To access a windows machine remotely I have to tunnel through a ubuntu server of mine. To setup the tunnel I have

ssh -l root -C -L 9999:windowsmachine:23389 myserver

Then I have to open another console and run

rdesktop -u user -password -f localhost:9999

How can I combine these in a single command or script?

I rely on the following script tunnel.sh written by others to keep a ssh tunnel alive:

#!/bin/bash export SSH_HOST=tim@server

if [ ! -f /tmp/.tunnel ] then echo "Creat SSH tunnel" ssh -f -D 9999 $SSH_HOST "if [ -f ~/.tunnel ]; then rm ~/.tunnel; fi; while [ !

I have a program running on remote server port 9999. As it don't support any kind of encryption and auth, I'm using the ssh tunnel to access to it.

This is the command I am using:

ssh -L 9999:localhost:9999 user@remotehost

In order to keep this tunnel alive. I write a ssh script to monitor and restart it if anything went wrong.

SSH tunnel doesn't work 36 weeks 16 hours ago

I am trying to use my server as a "proxy" with ssh. However, setting up tunneling with

ssh -D localhost:8000 user@myserver

does not work.

I tested this on various machines with ssh and putty - It connects just fine, but when I set my browser settings accordingly, I just get an error "Connection has been reset". I tried monitoring the traffic with wireshark, but I didn't even see some tunnel-t

I have the following configuration and want to establish a tunnel on a tunnel. I read already the following topic: How to put a tunnel in a tunnel?

My configuration:

Notebook --> Linux Server A --> Linux Server B

Notebook: Windows XP with putty Linux Server A and B: Ubuntu 10.10

I have a ssh connection with a tunnel from my notebook via putty to Server A. Now I want to establish a tunne

I want to have a ssh tunnel open every time I log in to my Ubuntu machine. .bashrc seems like the wrong place for this since I only need one tunnel for the whole session, not a tunnel per xterm. init.d seems wrong since I would like this one for one user.

I have a bash script that creates ssh tunnel to connect remote mysql server securely as shown below.

ssh -f -N -L $LOCAL_PORT:localhost:3306 $REMOTE_USER@$REMOTE_IP mysql -P $LOCAL_PORT -h 127.0.0.1 -u lapl_stg -p${REMOTE_DB_PASS} < ./t1.sql > ./out.txt

After opening the ssh tunnel in the bash script, upon exit of the bash script, I noticed that the ssh tunnel child process is still aliv