Test connection for linked service error: connection timed out

Jason 101 Reputation points
2021-09-03T11:30:55.96+00:00

Hi All

I am new to Azure and am trying to set up a connection between my Wordpress MySQL DB which is stored in google cloud and my new Azure SQL Server which I just created.

Using Data Factory I am attempting to configure a linked service with the AutoResolveIntegrationRuntime IR but when I test the connection I get the following error:

ERROR [08001] [Microsoft][MySQL] (1004) The connection has timed out while connecting to server:

I then tried to create an On-Premise Integration Runtime on my local machine, in the IR manager I tested connection to the MySQL DB and it was successful however when I go back to the linked service and change the IR to my on-Prem one I get a new error:

ERROR [08S01] [Microsoft][MySQL] Got packets out of order

Thanks

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
713 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,534 questions
Accepted answer
  1. Jason 101 Reputation points
    2021-11-19T07:52:45.613+00:00

    I was able to solve my problem. I needed to change my port number in order to bypass the servers SSL encryption/ CA cert requirements. By using the default wordpress port of 3306 my test connection was successful.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 77,081 Reputation points Microsoft Employee
    2021-09-07T07:57:51.39+00:00

    Hello @Jason ,

    Welcome to the Microsoft Q&A platform.

    There is no issue from Azure Data Factory. As per the error message it looks like issue from the MySQL DB which is stored in google cloud.

    You may checkout the below post which addressing similar issue.

    • As per the MySQL Forums forum post: This could be the problem due to port is being blocked by you ISP, or by your firewall or any antivirus.
    • As per the SO post: The problem was that the IP Addresses used by ADF had to be added to the "Outbound IP" list from MySQL DB which is stored in google cloud.

    Hope this helps. Do let us know if you any further queries.

    ---------------------------------------------------------------------------

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.