tSshTunnel remote database connection

[ALa1614]

i am trying to connect to my postgresql database on a remote linux server, so i used tSshTunnel to create a tunnel, but it keeps telling me, "com.jcraft.jsch.JSchException: Algorithm negotiation fail"

i have to run a VPN before connecting to the server, so i ran it before executing the job!

did i made the right components, steps and configuration ?

[prg · Accepted solution]

Hello @Ali Laghr​ ,

There is a lot of different ways that you can go about it, and one is that you can have putty on your system, create the ssh tunnel, and then run your Talend job. This is the easiest and most straightforward way without adding more complexities.

There is also a tSSHTunnel component in Talend Exchange (community created one) if you want to use your can try, but please note that there is no official support for this from Talend:

https://stackoverflow.com/questions/53941259/talend-tsshtunnel-usage

And in case you would not like to go ahead with ssh tunnel set up outside of Talend, you could try to put the commands mentioned in this article in a tSystem component to be run so that it can create the ssh tunnel:

https://www.ssh.com/ssh/tunneling/example

https://help.talend.com/reader/yRzAot6lAq5RiEKxJZhz~A/LejS3anSJ9D_t1C9Z68OaA

Please let us know if it helps.

Regards,

Vaishnavi

[ALa1614]

Hello @Vaishnavi Khandelwal​ 

I am running Putty listening on port 9090, now i can create a connexion to my remote database from talend, the problem now is that when i run the job, the data is not loading to the database!! where the problem might be ?

[ALa1614]

it works and there are the steps that i made :

1- i opened a tunnel with putty

2- authorising remote connexion in the postgrsql configuration file "/etc/postgresql/11/main/postgresql.conf" adding the line "listen_addresses = '*' " and in "/etc/postgresql/11/main/pg_hba.conf " file i added the line "host all all 0.0.0.0/0 md5"

2- i created a connexion to the remote database via talend

3- i executed the job and it works