Connecting talend Data Studio(Windows) to MySQL(Linux)
Problem: Unable to establish a secure connection to server.
Scenario:
We have to fetch data in Windows based Mysql database(Talend Data Open Studio also hosted on Windows) from Mysql database hosted on Ubuntu and is under protected environment.
Ways tried:
General connection: Error was Client refused connection.
Hard binding in Ubuntu for Windows IP: Able to connect but not protected as hard binding was for 0.0.0.0
tSSH tunnel: Configured tSSH tunnel to open up connection to Ubuntu Server from Talend: Error was client refused connection.
Only, after above roadblock, once cleared, we can start writing jobs for data migration.
We checked for Telnet on the Source Server(MySql on Linux) from destination server(MySql on Windows using Talend) and found that connections were getting refused.
This Situation has also been resolved as per attached Screenshot, but still we are getting same error in connection(Connection Failure. You must change the Database settings.)
Also please check whether you are able to connect to DB using a MySQL Client from the same machine where Talend is running. If you are not able to do it, then the issue is something related to firewall and network security where Talend do not have any role to play.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
I have already gone through these and many other links, but none seems perfect solution for a Production Environment.
Yes, i can easily connect to MySQL Client installed on same machine as of Talend, which is seamless.
As mentioned, kindly note that i was able to connect once to Linux based MySql client, when Linux settings were down and pushed to 0.0.0.0
Other than that rest of methods are not a solution in my case(where i need to create a warehouse, by migrating data from 5 different Linux based MySql Instances).
