Connect through MySQL via SSH-Tunnel

Hello
Do you know how we do that in C# (.NET). Here is the link to the library that we use:

https://mysqlconnector.net/

Regards

Hi David,

I think you‘re looking for this:
https://mysqlconnector.net/tutorials/connect-ssh/

BTW: It is an established (and more secure) method to connect via SSH.

Thank you!

Regards

Thank you,
I will add this to our todo list.

Regards

Perfect, thank you very much.

Hi,

is there a chance to know when the feature will be available ?
For security reasons there are probably some people waiting for it.

Regards

Hello,
I can't give you a timeframe yet but this is logged as improvement #5382. I hope to have it for RDM 2020.3 planned in September but maybe before.

Regards

Good news, thank you!

Regards

Hi David,

probably the function has not been implemented yet. I would like to ask you friendly if you still have it on your screen.

Thanks a lot!
Regards

Hello,

This feature has just been implemented and will be available in version 2020.3.12.0.

Regards

Hi,

thank you!, I am waiting for it with great anticipation.
Just now I have installed the current version 2020.3.12.0. I have tried to add a new session, but unfortunately I don't see any possibility to set it up.

Which is the right way ?
Add -> Add Session -> HeidiSQL / SSH Tunnel or something like that ?

Regards

Hello,

What we've implemented is for the MySQL datasource, the option to open an SSH tunnel before connecting, not for an entry type.



This acts similarly to the "VPN" settings for the datasource.

Maybe we misunderstood your original request, if so, what were you looking for exactly?

Regards,

Oh no, now I am really sad! I have been waiting for this function for a long time. Well, but it's not the end of the world either. The now programmed one is also very useful.

Anyway, I have explained further above, also with answers to David Hervieux questions, what is meant.

Currently I use "HeidiSQL" over RDM for connections via MySQL respectively to MySQL-DB.
Unfortunately I can't connect via MySQL through a SSH tunnel, e.g. via PLINK (see screenshot).

Background: Often it is not allowed to access a MySQL database directly, but only through a SSH tunnel. I.e. you connect to the host through SSH (usually port 22) and then through localhost to the MySQL database.

Just as I described above, including the C# (.NET) library used in the RDM:

https://mysqlconnector.net/tutorials/connect-ssh/
https://imgur.com/w8woe27
https://imgur.com/KQqg3xS

Regards

Hello,
I thought you were asking for the MySQL Data source but it not the case. You would like to use HeidiSQL with an SSH that RDM will open before? Have you tried to create an SSH tunnel in the VPN/Gateway/Tunnel section?

Could you tell me from what application the print screens come from?

Regards

Hello David,

the screenshots are from HeidiSQL.
These show in the end the program HeidiSQL, on the one hand the connection to the remote host via SSH and on the other hand the subsequent local (127.0.0.1/3306) connection to the MySQL database.

Let me describe it differently:
In HeidSQL a connection to a MySQL database is created. However, often nothing can be accessed directly to the database, so in HeidiSQL you select the option "MySQL (SSH tunnel)", i.e. HeidiSQL connects via SSH and then to the local MySQL database (127.0.0.1) and the corresponding credentials.

Please contact me if I didn't explain it clearly.

Maybe the option "VPN/SSH/Gateway" is the key, it sounds like it, but my tests were not successful.
For my understanding there should be the options from HeidiSQL "MySQL (SSH tunnel)" in the HeidiSQL session or an alternative via the embedded possibility of RDM "VPN/SSH/Gateway".

Regards

Hello,
I have verified the command line parameter for HeidiSQL and it does not seem to be possible to send the information pour SSH. Could you confirm that?

Regards

Hi,

it looks like this. There are CLI parameters, but those for SSH are only available for the GUI.
Apparently HeidiSQL uses an external tool for the SSH connection anyway, like in my screenshot/example on PLINK (plink.exe: a command-line interface to the PuTTY back ends).

Anyway, if I can build a SSH tunnel via RDM before the actual MySQL connection, I can do it with it. Unless I am on the wrong track.
Can you offer me a short remote session or help page regarding the SSH tunnel I needed before ?

Thanks you!
Regards

Hello Adriano,

Would it be possible for you to go under Help -> Submit a support ticket within RDM to open a support case with us? Through it we will be able to gather more information about your configuration and see what can be done.

Please just make sure to mention the URL of this forum topic in the description of your ticket.

Best regards,

Hello James,

done.

Thx & Regards

Hello Adriano,

Thank you for opening this case with us! Your ticket has been assigned to one of our agent.
We will update this forum thread once a solution has been found.

Best regards,

Hi,

with your help and especially Alexandre's, I now have the solution.
If you are interested, I will gladly describe it.

Roughly: You create a session "SSH Tunnel" and a HeidiSQL (or other, e.g. MSSQL) session and combine the whole.
The matter is now resolved, great RDM!

Best Regards

Hello,
I'm glad it's now working fine. I will check with Alex if we could do a blog about this integration.

Regards