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

Question

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

Zane eazyBI Support · Answer

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

Thomas Deiler_db00h3 · Answer

Dear @Mohamed Eltaweel ,

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

So long
Thomas

Thomas Deiler_db00h3 · Answer

Dear @Mohamed Eltaweel ,

this will solve your problems.

So long

Thomas