Bug #110975 Power BI Desktop & MS Excel don't work with v8.0.33 of the Connector/Net Driver
Submitted: 10 May 2023 12:30 Modified: 2 Oct 2023 22:43
Reporter: Roger Halabi Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:8.0.33 OS:Windows
Assigned to: Omar Chavez CPU Architecture:x86

[10 May 2023 12:30] Roger Halabi
Description:
When using the v8.0.33 version of the MySQL ConnectorNet driver, both Power BI Desktop and MS Excel receive an error when trying to do a Get Data.

This connector requires one or more additional components to be installed before it can be used. 

This does not happen if I uninstall v8.0.33 and install v8.0.32.  I can't use v8.0.32 because it was flagged by our security team as having a vulnerability which is why I am trying to use v8.0.33, but it doesn't work.

How to repeat:
Install Power BI desktop for free from Microsoft or install MS Excel and do a Get Data and pick MySQL.  You will get the error

Suggested fix:
Revert back to v8.0.32, but we can't because v8.0.32 has a security vulnerability. Refer to advisory at: https://www.oracle.com/security-alerts/cpuapr2023.html#AppendixMSQL
[10 May 2023 12:51] MySQL Verification Team
Hi Mr. Halabi,

Thank you for your bug report.

Can you please specify whether you upgraded both our server and C.NET to 8.0.33.

Thanks in advance.
[10 May 2023 12:58] Roger Halabi
No just the ConnectorNet driver on my PC.  I am not a server owner.
[11 May 2023 4:18] Bogdan Degtyariov
Hi Roger,

Thank you for your bug report.
I was able to repeat the problem with Connector/NET 8.0.33.
Sorry for the inconvenience.

This bug is being forwarded to Connector/NET developers.
[11 May 2023 4:26] Bogdan Degtyariov
Screenshot with PowerBI error and installed MySQL Connector/NET 8.0.33

Attachment: power_bi_bug_c_net.png (image/png, text), 199.87 KiB.

[11 May 2023 11:52] Roger Halabi
Thx for the update as it's very easy to replicate with PBI desktop and MS Excel. Again both work fine if I roll back to the v8.0.32 driver, but v8.0.32 has been flagged as a security vulnerability.
[11 May 2023 15:21] Alex Scott
Will this be because Portable.BouncyCastle dependency is no longer included within the installer?

To quote:

Connector/NET no longer provides within the install and no-install bundles any third-party libraries that the connector does not build internally. Application developers must now ensure the availability of following libraries at run time.

For applications using OCI Authentication and SSL Certificates validation:

Portable.BouncyCastle (see https://www.nuget.org/packages/Portable.BouncyCastle)

For applications using X DevAPI:

K4os.Compression.LZ4.Streams (see https://www.nuget.org/packages/K4os.Compression.LZ4.Streams)

Google.Protobuf (see https://www.nuget.org/packages/Google.Protobuf)

(WL #15682)
[11 May 2023 16:08] Roger Halabi
If you are asking me the end user/customer I cannot answer this question since I have no idea. I just need MySQL vendor to provide a newer version of the driver that works that doesn't have the security vulnerability.
[11 May 2023 18:18] Alex Scott
Roger,

Sorry, no, I was asking Bogdan.  :)

Alex
[16 May 2023 12:01] Roger Halabi
Any update on a fix/resolution on this?  It really hinders our work and we need a vulnerability fix that works.
[19 May 2023 17:13] Roger Halabi
Any update on a fix/resolution on this?  It really hinders our work and we need a vulnerability fix that works.
[11 Jul 2023 12:12] Roger Halabi
Any update on a fix/resolution on this?  It really hinders our work and we need a vulnerability fix that works.
[12 Jul 2023 12:04] Stuart Cuthbertson
It is possible that this is related to a prior bug, 107316 (https://bugs.mysql.com/bug.php?id=107316), which had the same effect on usability with Power BI in versions 8.0.29 and 8.0.30. 

That prior bug was fixed in 8.0.31, and I have confirmed in practice that .31 works normally.

Is it possible that the fix added for 107316 has been accidentally reverted in 8.0.33?
[12 Jul 2023 12:25] Stuart Cuthbertson
Additional observation: 

On Windows, versions .32 and .31 both have an installed size of roughly 100MB, according to Windows' "Apps & features" list (aka "installed software", "add/remove programs"). Versions .28 and .29 are around 80MB - smaller but same order of magnitude.

Whereas v8.0.33.1 claims to have an installed size of just 3.34MB. That seems impossibly small to me.
[13 Jul 2023 0:02] Omar Chavez
Hi everyone, Connector/Net v8.0.33.1 is available at (https://dev.mysql.com/downloads/connector/net/)

about the size observation, as stated in the release notes (https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-33.html) we remove all third party libraries that the Connector does not build internally, this meant a massive size reduction when we took out those libraries and all of their dependencies.
[13 Jul 2023 5:38] Adalbert Songott
Could you please provide a fixed version for this bug. It is totally unacceptable to have this bug open for such a long time.

Thanks.
[13 Jul 2023 8:25] Stuart Cuthbertson
Hi Omar, thanks for addressing my point about the reduction in size - good to know that is not relevant here. 

Just to make sure we're absolutely clear: v8.0.33.1 does not work for Power BI purposes, same as v8.0.33.
[13 Jul 2023 12:16] Roger Halabi
I can confirm that v8.0.33.1 DOES NOT work with Power BI.  Same error: "This connector requires one ore more additional components to be installed before it can be used."
[20 Jul 2023 19:01] Roger Halabi
I can confirm that the new v8.1.0 driver now available for download DOES NOT work with Power BI desktop nor Power BI Gateway software.  Same error: "This connector requires one ore more additional components to be installed before it can be used."
[27 Jul 2023 16:11] Omar Chavez
Hello Everyone,
we are working to solve this.

In the meantime, is there a log or some way I can get more information on the error? I am not familiar with Power BI, anything can help.
[27 Jul 2023 17:08] Roger Halabi
Omar, there is no log that I know of, but you can replicate by downloading Power BI desktop from Microsoft for free, installing the v8.0.33 or higher ODBC Net driver and trying to make a connection to a MySQL server. You will get the same error.
[27 Jul 2023 17:59] Luca Bartolini
hi, if this can help, this is the error I receive from powerbi:

We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'

same error with 8.1 or with 8.0.33
[31 Jul 2023 16:01] Philip Zubaly
As with 8.0.29 (#107316) I have found that after upgrade or installation of .NET Connector 8.0.33.1 the required MySqlClient data provider has been cleared from the <system.data><DbProviderFactories> section of the machine.config

This is in the Framework64 version of the machine.config where the DbProviderFactories is empty. The Framework version of the machine.config has the MySQL Data Provider (MySqlClient) in the DbProviderFactories section as it should.

With 8.0.32 the MySQL Data Provider is included in both of the machine.config files
[31 Jul 2023 16:01] Philip Zubaly
As with 8.0.29 (#107316) I have found that after upgrade or installation of .NET Connector 8.0.33.1 the required MySqlClient data provider has been cleared from the <system.data><DbProviderFactories> section of the machine.config

This is in the Framework64 version of the machine.config where the DbProviderFactories is empty. The Framework version of the machine.config has the MySQL Data Provider (MySqlClient) in the DbProviderFactories section as it should.

With 8.0.32 the MySQL Data Provider is included in both of the machine.config files
[25 Aug 2023 12:15] Roger Halabi
Any update, is there EVER going to be a fix for this?
[11 Sep 2023 21:37] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Connector/NET 8.2.0 release, and here's the proposed changelog entry from the documentation team:

Applications like Microsoft Excel and Microsoft Power BI Desktop emitted
an error when used with Connector/NET 8.0.33 and later. This fix
identifies and restores the missing component.

Thank you for the bug report.
[12 Sep 2023 12:05] Roger Halabi
Thank you very much for the update. Any ETA when the new v8.2.0 will be released?
[19 Sep 2023 15:49] Roger Halabi
Any ETA when the new v8.2.0 will be released?
[2 Oct 2023 22:43] Roger Halabi
Any ETA when the new v8.2.0 will be released?
[3 Oct 2023 8:35] Stuart Cuthbertson
@Roger: FYI this case has been closed so it's likely that none of the Oracle/MySQL staff involved are getting notified about your comments any more. 

Since MySQL is a free product it's quite possible there is no concrete release plan. I would just keep an eye on the downloads page every month or so and get the new release when you see it. 

To be clear I'm just another affected end-user, not affiliated with Oracle or MySQL at all.