X-Recipient: archive-cygwin AT delorie DOT com
X-Spam-Check-By: sourceware.org
Message-ID: <4912C7F1.3000701@btinternet.com>
Date: Thu, 06 Nov 2008 10:33:21 +0000
From: Edward Ludlow <eludlow AT btinternet DOT com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
To: cygwin AT cygwin DOT com
Subject: SSH dropping out
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

I have data on a remote mySQL server that to edit, I have to SSH port 
forward to.

On Windows boxes, I use Cygwin to achieve this, by running:

ssh -L 3306:mysqlserver:3306 -N user AT server DOT com

Obviously then prompted for a password.

This works fine, except that once connected, if there's no communication 
with the mysql server for a certain period of time (sometimes < 5 
minutes, other times > 20 mins) the connection drops.

Is there a way, from within the same batch script used to make the SSH 
connection, to send a packet of data, or something similar, every minute 
so that the connection will be kept alive?

This can be infuriating if writing a long query or entering data!

Many thanks,
Ed Ludlow

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/