Bug #59507 my sql net connector fails to install with msi package 6.3.6
Submitted: 14 Jan 2011 15:43 Modified: 28 Mar 2011 20:56
Reporter: james hardy Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.3.6 OS:Windows (7 64 bit, XP 64 bit)
Assigned to: Julio Casal CPU Architecture:Any
Tags: msi installer net connector fail rollback, regression

[14 Jan 2011 15:43] james hardy
Description:
Installing mysql dot net connector from the msi package on Microsoft Windows 7 home premium x64 fails. 
Installation proceeds to the stage where the msi installer is writing to machine.config and then auto rollback is initiated and package is not installed.
Installation choices ( typical custom etc ) do not change behavior.
Using windows compatibility wizard, which skips version check does not change behavior 
Previously released general package 6.1.5 installs with no issues

machine is gateway NV53 laptop
AMD Athlon x64 arch.
windows 7 home premium all latest sp and hotfixes installed 
2gb ram
free diskspace greater than 200gb
possibly relevant installed software 
visual studio express c\c++ 2010 edition
visual studio express c#  2010 edition
mysql 5.58 community for x64 
mysql workbench 5.2.31

How to repeat:
attempt to install on similar machine
[17 Jan 2011 10:13] Valeriy Kravchuk
I've got exactly the same problem on 64-bit Windows XP Pro.
[17 Jan 2011 16:28] Richard Craven
Same issue on a 32-bit Windows 7.
[17 Jan 2011 17:07] Michael Milliron
Same issue on Windows 7 32 bit here too.
[18 Jan 2011 7:12] Karsten Tröß
Same issue on a 32-bit WinXP Home
[18 Jan 2011 17:32] Michael Milliron
Tested a workaround mentioned in the Forums - once I installed .NET 4 the connector was able to be installed with no issues.
[19 Jan 2011 18:00] Richard Craven
I installed Net 4.0 also.  Now no trouble installing connector 6.3.6 (thanks, Michael!).

Richard
[20 Jan 2011 12:01] Santo Leto
Bug #59269 has been marked as a duplicate of this.
[22 Jan 2011 15:59] claudio beretta
Same issue on WinXP Pro
I already have .net 4 (installed during visual studio 2010 setup process) and still 6.3.6 is rolling back.
6.3.5 installs fine
[24 Jan 2011 14:12] Richard Craven
I also had .Net 4.0 installed when I first tried this.  I notice that there are at least two different .Net 4.0 installations, however.  The installation which resulted in success was a "full" installation, not a "Client Profile" installation.  I do not know whether that is critical to the workaround but it may be.
[7 Feb 2011 16:49] Valeriy Kravchuk
Bug #59990 was marked as a duplicate of this one.
[15 Feb 2011 7:37] Aditya Mandava
Hi ,

I am also unable to install the version 6.3.6 my sql connector/net .
[16 Feb 2011 8:50] danny companez
MSIEXEC log file on install

Attachment: cnet636.log (application/octet-stream, text), 79.41 KiB.

[16 Feb 2011 8:51] danny companez
I have the same problem on W/XP. I ran the following command to generate a log file"
msiexec /i mysql.connectornet.6.3.6.msi /l*  "c:\cnet636.log"
"Interesting" section of the log follows:

InstallFiles: File: TableEditor.build,  Directory: C:\Program Files\MySQL\MySQL Connector Net 6.3.6\Samples\Table Editor\vb\,  Size: 1314
Action 19:42:22: ManagedDataInstall. Registering data provider in machine.config
CAQuietExec:  Error 0x80070002: Command failed to execute.
CAQuietExec:  Error 0x80070002: CAQuietExec Failed
Action ended 19:42:23: InstallFinalize. Return value 3.
Action 19:42:23: Rollback. Rolling back action:
Rollback: Registering data provider in machine.config
[16 Feb 2011 9:03] danny companez
I re-installed my 6.2.4 connector.net and the same section of the install log looks like:
InstallFiles: File: TableEditor.build,  Directory: C:\Program Files\MySQL\MySQL Connector Net 6.2.4\Samples\Table Editor\vb\,  Size: 1314
Action 19:54:32: ManagedDataInstall. Registering data provider in machine.config
CAQuietExec:  Microsoft (R) .NET Framework Installation utility Version 2.0.50727.3053
CAQuietExec:  Copyright (c) Microsoft Corporation.  All rights reserved.
CAQuietExec:  
Action 19:54:38: ManagedWebInstall. Registering web providers in machine.config
CAQuietExec:  Microsoft (R) .NET Framework Installation utility Version 2.0.50727.3053
CAQuietExec:  Copyright (c) Microsoft Corporation.  All rights reserved.
CAQuietExec:  
Action 19:54:40: RegisterHelp. Registering help collection
Action 19:54:42: CreateShortcuts. Creating shortcuts
[16 Feb 2011 9:23] Sean Nevin
Log file from 32-bit install attempt

Attachment: connector-6.3.6 install.log (text/plain), 78.94 KiB.

[19 Feb 2011 16:22] Manuel Prieto
"installation wizard ended prematurely"

Attachment: log.txt (text/plain), 474.97 KiB.

[19 Feb 2011 16:23] Manuel Prieto
I dont know whats goingo on.. I have net Framework 4 (client and full) I dont know what to do.. 

Thanks for your support.
[19 Feb 2011 16:24] Manuel Prieto
I dont know whats goingo on.. I have net Framework 4 (client and full) I dont know what to do.. 

Thanks for your support.
[23 Feb 2011 18:03] Matthew Enloe
I am having the same issue as the above.  I am running windows 7 64bit and have .NET 4.0 installed.
[25 Feb 2011 4:24] Valeriy Kravchuk
Bug #60241 was marked as a duplicate of this one.
[28 Feb 2011 19:27] Robert Gebis
Related to bug #60241. Here is my list

Frameworks on Win7 x64. 

C:\Windows\Microsoft.NET\Framework
   v1.0.3705, 
   v1.1.4322,
   v2.0.50727,
   v3.0, v3.5, 
   v4.0.30319

C:\Windows\Microsoft.NET\Framework64
   v2.0.50727, 
   v3.0, 
   v3.5, 
   v4.0.30319
[9 Mar 2011 18:54] Richard Craven
My previous workaround for this serious bug was on a Windows 7 machine which had very little installed on it.  Just recently I have had a failure on my VS2010 XP development machine.  I could neither repair, uninstall, remove or even remove with the settings/control panel tool.  All failed.
Finally, I succeeded in deleting all net connector 6.3.6 files and removing dotnet 4.0 files.  Then I searched the registry and deleted ALL references to 6.3.6.  Finally, I reinstalled dotnet Full 4.0 and then succeeded in installing using the msi installer in mysql-connector-net-6.3.6.zip.  Quite a lot of work.  I'm sure some steps were not necessary however I have retraced my steps so many times trying to get this to work that I did not want to overlook anything.  I hope my experience can help somebody.

Richard
[11 Mar 2011 16:34] Nate Horsfall
Initial attempt of 6.3.6 installation failed. Installing .NET 4.0, then retrying installation of 6.3.6 was successful. Windows 7 Pro x64.
[18 Mar 2011 8:31] Tonci Grgin
Sean & Danny; your problem is the same, 
Action 19:42:22: ManagedDataInstall. Registering data provider in machine.config
fails.

This could be due to clutter in machine.config, missing .NET FW 4.x (I see Sean has 2.0), a bug or any other number of reasons.

Try registering manually and see if it works.
[24 Mar 2011 9:13] danny companez
Hi Tonci,

Yes, I don't have .NET 4 - I have .NET 2 same as Sean.

After your comment I went back to the MySQL website and tried to find the compatability requirements for Connector/Net 6.3.6. I couldn't find any mention of any .NET level that was a pre-requisite for the succesful install of 6.3.6, so I assume that it will install under .NET 2 or .NET 4. Are you aware of any restriction on which version it will install under?

You did mention something that could be useful "Try registering manually and see if it works". Can you give me some instructions about how I can do that? 

Thanks
[28 Mar 2011 20:56] Julio Casal
This is the same basic problem as seen in 59301.
[22 Apr 2011 7:03] Ha Bui
I have same issue in Windows 7.

Solution:

Install .Net framework 4 before installing my sql net connector 6.3.6
[19 Jun 2011 11:18] Tommy Pham
Same problem... 

Visual Studio 2010 SP1 runs fine and already have the full .NET 4 installed.  Also, 6.3.5 (several times) installs/uninstalls/re-installs OK w/o any issues while 6.3.6 was supposed to fix a bug that 6.3.5 fails to install?  BTW... DISABLEROLLBACK=1 or DISABLEROLLBACK=TRUE still rollbacks... :shrug:  

Both on Win08 x86 SP2 (with all current updates) and Win08r2 (with all current updates)  I can attach long debug logs on both system if needed.

Thanks.
[13 Sep 2012 18:30] Acar Atmaca
I try to add mysql on visual but ı cannot setup mysql connector it says

Setup wizard allows you to change the way Mysql connector 6.5.4 featues are installed on yor connector bla bla ı press NEXT

3 OPTION change repair remove

ı press change button and select visual studio 2008 and press next

AND MYSQL CONNECTOR NET 6.5.4 SETUP WİZARD ENDED PREMATURELY..

ı use win7 and have .net framework 4.5
and 4.5 is repaired... 

tnx 4 your support ı hope help fast because ı have project
[6 Apr 2016 11:50] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=80967 marked as duplicate of this one.