Quick Sight fails to connect do MySQL datasource on OCI

[george.a.s]

I’m trying to connect QuickSight 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

2. 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

[Xclipse]

Hi @george.a.s

Welcome to the QuickSight community!

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

Connecting Mysql to Quicksight

Hello! I need to connect MySQL to QuickSight as a new data source. I keep getting errors and have a feeling it is an IP issue as I have not added an AWS IP to my security on the database side. How do I find the IP for US east region 1 (or the correct IP). If this is not the case, what else could be the issue? I have SSL enabled so should not be an issue. Thanks!