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

 

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.