Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tSSH component closes connection

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

0683p000009LsBj.png

 

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

 

0683p000009LsEm.png

 

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

 

0683p000009LsG3.png

 

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

 

Thanks a lot,

Nasia

 

Labels (1)
4 Replies
lojdr
Creator II
Creator II

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

Anonymous
Not applicable
Author

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

lojdr
Creator II
Creator II

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


 

0683p000009LruZ.pngtMysqlInput0683p000009LsFu.pngtSSHTunnel 

Regards

Lojdr

 

Anonymous
Not applicable
Author

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