When trying to connect eazybi to the mysql it raise error "Public Ke

[Mohamed Eltaweel]

Hi,

Jira 8.13 with  mysql v8.0.21

When trying to connect eazybi to the mysql it raise error  "Public Key Retrieval is not allowed"

Thanks

[Thomas Deiler]

Dear @Mohamed Eltaweel ,

this will solve your problems.

So long

Thomas

[Thomas Deiler]

Dear @Mohamed Eltaweel ,

was my answer useful? Then I would be happy when you click on the "green accept answer" button.

So long
Thomas

[Zane eazyBI Support]

Hi @Mohamed Eltaweel 

First, make sure eazyBI has version 6.2 or later and the MySQL JDBC driver to your application server is in place (https://docs.eazybi.com/eazybijira/set-up-and-administer/set-up-and-administer-for-jira-server/installation-and-setup#Installationandsetup-Databaseconnection).

If the error persists, you may try the solution suggested by @Thomas Deiler. In eazyBI, add a property to the advanced database settings to allow public key access (https://docs.eazybi.com/eazybijira/set-up-and-administer/set-up-and-administer-for-jira-server/installation-and-setup#Installationandsetup-Databaseadvancedsettings

[properties]
allowPublicKeyRetrieval=true

If this does not solve the case, please contact eazyBI Support (https://eazybi.com/contact).

Best,
Zane / eazyBI Support