question

Roustm-4702 avatar image
0 Votes"
Roustm-4702 asked RoustamAkhmetov-2161 published

Microsoft Integration Runtime Configuration Manager returns "internal client error" when connecting to MySQL

Hi,

I've built few new VMs in AWS and installed Microsoft Integration Runtime Configuration Manager. On some of them it works fine, on others it returns:
"[Microsoft][MySQL] (42) Internal client error.
ERROR [HY000] [Microsoft][MySQL] (42) Internal client error."

The connection to the same MySQL server works fine on the same box if I use ODBC Data Source Administrator (64 bit).

Any ideas?

Thanks.

azure-data-factory
· 8
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Roustm-4702,

Welcome to the Microsoft Q&A platform.

In order to investigate further, I would request you to share the complete stack trace of the error message which you are experiencing along with the screenshot?

0 Votes 0 ·

Hello @Roustm-4702,

Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.

0 Votes 0 ·
Roustm-4702 avatar image Roustm-4702 PRADEEPCHEEKATLA-MSFT ·

Sorry, please find attached.69024-runtimelog-small.xml


0 Votes 0 ·
Show more comments
Roustm-4702 avatar image Roustm-4702 PRADEEPCHEEKATLA-MSFT ·

69886-sceenshot.png


And the screenshot

0 Votes 0 ·
sceenshot.png (71.0 KiB)
Show more comments
Roustm-4702 avatar image
0 Votes"
Roustm-4702 answered

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RoustamAkhmetov-2161 avatar image
0 Votes"
RoustamAkhmetov-2161 answered RoustamAkhmetov-2161 published

We found a workaround, by disabling a windows firewall you can make it work on this particular server. Other servers do not require firewall to be disabled to make it work. Wondering what port (or ports) should I allow to keep the firewall running and the connectivity working?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.