Talend community forum / mysql and SSH port tunneling forwarding

shaferj · 2008-03-09 22:51:10

Hello, I have been evaluating talend as means to perform various ETL tasks and have been very impressed with the capabilities of the tool. One common need that I have will be accessing remote MySQL Databases via port forwarding / tunneling.

Does anyone have recommendations / experience on the best way to setup this capability within talend?

Regards,
- John

plegall · 2008-03-09 23:00:55

I have a permanent SSH tunnel which maps local port 12345 to remote port 3306:

Code:

$ ssh -L12345:localhost:3306 remote_user@remote_host

In TOS, in a Perl project, I set the remote host to '127.0.0.1' (and not localhost, it doesn't work) and port to 12345. I do it everyday and it works fine.

shaferj · 2008-03-09 23:16:59

Thank you very much for the reply.

I have been experimenting with a permanent ssh tunnel, however the issue that I have seem to run into is connection reliability. This is mostly due to corporate access policies that are outside of my control. Because of this our connection tends to get severed periodically throughout the day.

I am trying to come up with a way that I could open and close the tunnel when making requests to the database giving me the ability to trap and restart jobs as connectivity issues arise. A way to have a dependency on a tunnel initiated from within Talend would be the ideal, but I'll take any suggestions.

Thanks again.

- John

plegall · 2008-03-10 00:29:20

Can you confirm you're working on an Unix? so that I can investigate the right way.

shaferj · 2008-03-10 00:45:29

Currently I am working on Windows, but only for the purpose of experimentation. I am very satisfied with the Talend Open Studio and its capabilities and will be moving to a Linux Box for complete testing and deployment within a week or so. Linux will be the platform the of choice that this application will be running on.

I really appreciate your taking the time to investigate this.

- John

akempkens · 2010-04-06 11:38:48

Hi,

Do you see a possibility to establish such a tunnel on the fly, e.g. using the Talend ssh component?

Alex

donald scott · 2011-08-19 22:18:40

i am also trying to connect to a mysql server in an environment that uses ssh tunnels. I have a putty terminal open, but i am also tunneling to the svn. seems like there is some confusion, and in the past they have just copied full copies of DB to their machines to get around the issue. i would rather get this working correctly so that going forward development is more efficient.

any suggestions would be very helpful.

Announcement

Unanswered posts

#1 2008-03-09 22:51:10

mysql and SSH port tunneling forwarding

#2 2008-03-09 23:00:55

Re: mysql and SSH port tunneling forwarding

Code:

#3 2008-03-09 23:16:59

Re: mysql and SSH port tunneling forwarding

#4 2008-03-10 00:29:20

Re: mysql and SSH port tunneling forwarding

#5 2008-03-10 00:45:29

Re: mysql and SSH port tunneling forwarding

#6 2010-04-06 11:38:48

Re: mysql and SSH port tunneling forwarding

#7 2011-08-19 22:18:40

Re: mysql and SSH port tunneling forwarding

Board footer