Quick Sight fails to connect do MySQL datasource on OCI

Q&A
1

I’m trying to connect Quick Sight to a MySQL (version 8.4.2) datasource at OCI but I’m getting the following errors:

  1. With SSL disabled:

region:
sa-east-1
timestamp:
1737210854399
requestId:
9da0a8db-5471-4424-b302-00281ba60c2c
sourceErrorCode:
GENERIC_SQL_EXCEPTION
sourceErrorMessage:
Public Key Retrieval is not allowed

  1. With SSL enabled:

region:
sa-east-1
timestamp:
1737210876111
requestId:
36e54793-b390-4b56-80b3-7543d4ff8c26
sourceErrorCode:
SQL_CONNECTION_FAILURE
sourceErrorMessage:
Communications link failure The last packet successfully received from the server was 9 milliseconds ago. The last packet sent successfully to the server was 9 milliseconds ago.

Could you please help? Thanks

2

Hi @george.a.s

Welcome to the Quick Sight community!

Please refer to the below Quick Sight community post this might be helpful for you.

3

I have another MySQL data sources running on different MySQL version (5.6) and already connected do Quicksight.
This is not a firewall or network problem on my side. This specific data source that does not work on Quicksight works perfectly from Power BI.

4

Hi @george.a.s

Thank you for letting us know. I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf.

5

Hi @george.a.s,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @george.a.s,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!