I am trying to connect to a remote server using ssh tunnel connection where I have to use port forwarding from a local server to the remote server. I then need to be able to connect to a mysql database on the remote server.
Any ideas how I would set this up in Talend?
Any help would be appreciated.
Hello - Been trying to do the same, however, we have differences as follows: 1. Using Talend 6.2.1 on Windows 10 2. Linux Server (RHEL 7 MySQL Package) separate from DB server Goal is to setup DB connection from local PC (using Talend) to MySQL via SSH connection: Local PC -> SSH Connection (e.g. mdmuser/<password>) -> MySQL DB (e.g. talend_mdm_dev/<password>). It is necessary to connect to Linux server first before accessing DB server.
Hello - Been trying to do the same, however, we have differences as follows: 1. Using Talend 6.2.1 on Windows 10 2. Linux Server (RHEL 7 MySQL Package) separate from DB server Goal is to setup DB connection from local PC (using Talend) to MySQL via SSH connection: Local PC -> SSH Connection (e.g. mdmuser/<password>) -> MySQL DB (e.g. talend_mdm_dev/<password>). It is necessary to connect to Linux server first before accessing DB server.
Please describe the components you added in Talend Jobs.
I want to connect via tssh, but i dont know about the command or anything more.
hi Never use "localhost" for hostname (but 127.0.0.1) if ssh host and mysql server on the same machine
Hope it helps regards laurent
How is your components structure?
I have a structure : tSSH-----(main)---tFlowToIterate---(Iterate)---tMysqlInput-----(main)----tFileOutputExcel
And the result is nothing, just connected for a long time.
tSSH: Host (My servers IP Public), Port (22), User (myuser), auth method (public key),
Commands : "mysql -u root -p myDBName"
"myrootPass;"
tMysqlInput: Component Setting like localhost conection, with host 127.0.0.1
When i ran only the tSSH component with command "ls;", its running weel.
Hope somebody can help me to fix it.
