topic tSSH component closes connection in Talend Studio

tSSH component closes connection

Anonymous — Tue, 09 Jan 2018 12:52:41 GMT

I am trying to create a job that opens an SSH tunnel & then connects to MySQL.

The configuration of the tSSH are shown in the picture, as well as, the job format.

The issue is that I cannot connect to MySQL at the end, because the tSSH is exiting.

How do you work with this component? I couldn't find a proper guide for it.

Thanks a lot,

Nasia

Re: tSSH component closes connection

lojdr — Tue, 09 Jan 2018 13:20:34 GMT

Hello,

This is not correct usage. The tSSH component will print "Talend" and close the connection. This is expected behaviour.

Please check this component:

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F678&pi=marketplace%252F1%252Fproducts%252F678%252Fitems%252F987

Hope it helps.

Regards

Lojdr

Re: tSSH component closes connection

Anonymous — Tue, 09 Jan 2018 13:45:42 GMT

Can you put an example of the tSSHtunnel, because it seems to not work

Re: tSSH component closes connection

lojdr — Tue, 09 Jan 2018 19:34:54 GMT

Hello,

See the screenshots below.

Also in a review of the component is written:

...ALL field values in quotes (including password if blank, and port number), and do not include “-L” in the port forwarding - for example you can use “12345:127.0.0.1:3306”...

tMysqlInputtSSHTunnel

Regards

Lojdr

Re: tSSH component closes connection

Anonymous — Wed, 10 Jan 2018 12:28:22 GMT

For me it still didn't work.. I will have to find another solution for these. Thanks though