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

 

4 REPLIES
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