SSH port forward with tSystem

[Anonymous]

I'm using Talend 7.1 Enterprise edition with a combination of AWS EC2 as Remote engine and TMC.

My requirement was to do a port with tSystem component while running over Talend Cloud.

The command I used in tsystem is as follows:

"ssh -fNT -L "+context.parameter_stg_port+":"+context.parameter_stg_host_db+":3306 talend@"+context.parameter_private_host

Where all the parameters are having correct values and I had tested in the following ways:

1. Setting the Target Executor as My remote engine on EC2 and running the job -> The ports are getting forwarded.

2. Publishing the job to TMC and running it over remote engine paired with the same EC2  -> The ports are not getting forwarded.

Ideally, both the scenarios should give me the same outcome but somehow I'm not able to figure out why the 2nd point is not working out for me. Please suggest any solution which can help me with this issue

[Anonymous · Accepted solution]

This was a user access related issue. It was resolved by changing the user within the tSystem using the command:

"su <<username>> -c 'ssh -fNT -L "+context.parameter_stg_port+":"+context.parameter_stg_host_db+":3306 talend@"+context.parameter_private_host+"'"