Forum Discussion
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
- lbendlinSuper User
You set that in the network settings of the gateway admin app for each gateway cluster member
- AnonymousNot 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.