#1  
Old 17th April 2008, 21:33
warkry warkry is offline
Junior Member
 
Join Date: Apr 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default SSH tunnel hep

I am currently trying to set up an SSH tunnel from one server to another and am having difficulty, never done this before. Anyway there are two servers one is a production web server and the other is a test server. The idea is to get hourly updates of the mysql database to the test server from the production server via replication. The test server will then be used for local backups and a few other things.

First things first I am trying to get the ssh tunnel working so I can test out mysql replication. From the test server i run:

ssh -fNg -L 4000:127.0.0.1:3306 myuser@productionserver.com

and after asking for myuser's password it gives me:

bind: Address already in use


I really don't know what it's referring to. Any thoughts?
Reply With Quote
Sponsored Links
  #2  
Old 17th April 2008, 21:59
topdog topdog is offline
Senior Member
 
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 154 Times in 151 Posts
Default

Why dont you just use mysql replication over an SSL encrypted connection ?

You cannot bind to 3306 because the server on that machine is using the port already choose another port if you really have to do it this way
__________________
----
http://www.topdog.za.net - Got Linux problems ? - I can help.
http://www.baruwa.org - Try it.
Reply With Quote
  #3  
Old 21st April 2008, 18:13
warkry warkry is offline
Junior Member
 
Join Date: Apr 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Interesting, I was under the impression that I needed to use the mySql port on the production server in order to get replication to work over SSH. After the tunnel is setup you run replication as local host over whatever port is forwarded to 3306 on the host machine. In this case 4000.

All of the tutorials/guides I have found on the subject have set up the tunnel in this way. Can any one shed some light on this for me?

Last edited by warkry; 21st April 2008 at 18:51.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SSH Problem - Receive signal 15 Terminating joelee Technical 1 28th September 2007 19:47
adduser set passwd for ssh FastS General 1 26th March 2007 17:28
few question about pure-FTP and SSH and Postfix Zbych Server Operation 1 10th February 2007 21:41
SSH DIED - Virtual Users And Domains With Postfix, Courier And MySQL herbie HOWTO-Related Questions 2 12th December 2006 03:16
SSH port forwarding (SQLYog Tunnel) mastorna Server Operation 0 22nd June 2006 02:16


All times are GMT +2. The time now is 09:30.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.