topic Re: tSshTunnel remote database connection in Talend Studio

tSshTunnel remote database connection

ALa1614 — Sat, 16 Nov 2024 00:31:24 GMT

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 ?

Re: tSshTunnel remote database connection

prg — Fri, 26 Feb 2021 13:57:02 GMT

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

Re: tSshTunnel remote database connection

ALa1614 — Tue, 02 Mar 2021 09:33:17 GMT

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 ?

Re: tSshTunnel remote database connection

ALa1614 — Tue, 02 Mar 2021 11:23:52 GMT

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