topic Re: How to use the tssh component in Talend Studio

How to use the tssh component

Anonymous — Fri, 10 Nov 2017 17:17:30 GMT

I am trying to run an stand-alone job on an EC2 instance, which needs to connect to database through ssh tunneling.

Any guide on how to use the tssh component for this?

Re: How to use the tssh component

Anonymous — Mon, 13 Nov 2017 07:28:54 GMT

Hello,

Are your ssh host and DB server on the same machine?

Here is a document that Karaf pertains ssh:TalendHelpCenter:Connecting and disconnecting remotely

Hope it will help.

Best regards

Sabrina

Re: How to use the tssh component

Anonymous — Mon, 25 Mar 2019 21:03:11 GMT

You can refer to https://stackoverflow.com/questions/53941259/talend-tsshtunnel-usage/55346159#55346159 for a complete explanation I posted today.

A question for the Talend team : this is a pretty common use case; can we see in the short term a correction for the error below?

javax.crypto.ShortBufferException: Cannot store MAC in output buffer

This is triggered by a long URL (as is the case for RDS databases) in the 'L Tunnel String' field for the tSshTunnel component. A workaround is to find the database server URL in the ec2-xx-xx-xx-xx format, which involves the use of tracing tools and is not a good solution as the IP addresses are normally dynamic.