MySQL: Retrieval of the RSA public key

[Anonymous]

I use a On-premises data gateway for a SQL connection we have. It use to work fine but as of late the refreshes have stopped working and are giving authentication issues. 

Failed to update data source credentials: MySQL: Retrieval of the RSA public key is not enabled for insecure connections.

After doing some research i found a article a bit old saying perphaps its due to ssl not enabled. But I'm not really finding where you manage this in the Gateway or on Power BI?

Running:

MySQL Connector NEt 8.0.29

On Premises Data Gateway (Personal Mode) - 3000.134.9 (July 2022)

[lbendlin · Accepted solution]

You set that in the network settings of the gateway admin app for each gateway cluster member

[Anonymous]

Good to know in the future. I actually had a few different issues that I think all got resolved sense then. I switched to Standard gateway and that fixed alot of my problems. I also downgraded the SQL connector net back down to 8.0.28 the .29 version caused alot of problems.