Trying to move data from MySQL to the schema on Snowflake via MDL but getting a bellow error message
#30 [Get Source Metadata] - Parameter Validation Failure:
Table - Failed to get tables. Communications link failure
The last packet successfully received from the server was 40 milliseconds ago. The last packet sent successfully to the server was 27 milliseconds ago.
Note:
* The DB is available - Can connect it via other tools with no issue
Hi there @ankit.h.joshi and thanks for your patience.
This could be related to the TLS version used by the MySQL instance. I do have a potential workaround you could use, however please note that these need to be considered from a security point of view as part of the advanced property will disable the SSL entirely and is not available for MySQL versions less than 8.0.8. For the workaround, try adding the advanced property of UseSSL=false (which will disable SSL entirely) or enabledTLSProtocols=TLSv1.2 (or above, only available for MySQL versions after 8.0.8)
Let me know if that helps at all.
Many thanks,
Claire
@ClaireSeniorCommunityManager : I dont see the option on MDL - this one is available in METL. I am trying to load the data in mysql via MDL into Snowflake. The pipeline is able to connect successfully and read the schema and tables within but when trying to sync I get the error message as mentioned in initial post
Thanks @ClaireSeniorCommunityManager : I was able to progress with Advance option setting as mentioned in the screenshot
We are using RDS Query to fetch data from mysql , I don't see any advance option where I can enable or disable TLS?
Hi @umer.khan , For me the issue was connectivity which got resolved by using useSSL = FALSE in MDL as well as in METL query components - the screenshot from @ClaireSeniorCommunityManager helped me to resolve it. If you could further elaborate on your issue or a screenshot that might help to look into it further ?
Thanks @ankit.h.joshi for quick response.
my issue is we have RDS Query component to fetch data from AWS Replica (msyq)
The only option I think is JDBC Option, I tried that but I guess it is not being used.
Hi @ankit.h.joshi
I'm so sorry for any confusion, you should be able to access it from the Advanced settings options on the Connect to MySQL page. It should look like the image here. Let me know if that helps at all!
