tSSH component closes connection

Five Stars

tSSH component closes connection

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

Screen Shot 2018-01-09 at 1.45.08 PM.png

 

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

 

Screen Shot 2018-01-09 at 1.45.43 PM.png

 

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

 

Screen Shot 2018-01-09 at 1.45.27 PM.png

 

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

 

Thanks a lot,

Nasia

 

Eight Stars

Re: tSSH component closes connection

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%...

 

Hope it helps.

 

Regards

Lojdr

Five Stars

Re: tSSH component closes connection

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

Eight Stars

Re: tSSH component closes connection

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”...


 

3.PNGtMysqlInput2.PNGtSSHTunnel 

Regards

Lojdr

 

Highlighted
Five Stars

Re: tSSH component closes connection

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog