[yetanotherjimbo]

Ritesh wrote on Jul 25 2005, 09:46 AM:

As I visualise the situation:

You are connecting to different SSH hosts:

192.168.1.1 and 192.168.1.2

From there you are tunneling to MySQL servers running on the same machine as the SSH Host i.e. *localhost*. Am I right? Thus you are providing two different addresses in the SSH Host field of Tunnel tab?

[post=”6568″]<{POST_SNAPBACK}>[/post]

Yep.. That sounds right.

[yetanotherjimbo]

Hiya..

( sorry – I dissapeared! 😉 ) Cal is right – I think it's just a naming issue.

I am connecting to 2x boxes, 2x different machines etc, 2x SSH tunnels. The catch is that because the setup of the boxes are the same once your inside the tunnel what you do is identical… ie. both connections are made to “dbname@localhost” …

… the two “localhost's” are entirely different machines.

This problem ( afaik ) is only going to show up where you are able to make 2x identical 'looking' connections to two different databases. Only place this occurs in practice is when you use a hostname like localhost which always refers to the loopback to yourself and not to a real location…

.. I guess if the lists of DB's are getting thrown into a hash somewhere under the bonnet in SQLyog, key'ed by the connection string, then there is the potential to conflict where you can make two legitiamtely identically named different connections..

… hope I'm managing to explain myself – say if I'm still not making sense – very early Monday morning! 😉

J.

[Author]

Posts