Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

MySQL: Retrieval of the RSA public key

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)

 

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

2 Replies

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.