Hi, Thanks for your Inputs. 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). Any help is appreciable. Regards, Ashwani
... View more
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.) Your help and support will be appreciable.
... View more