MySQL Bugs: #70590: Installation of MySql for Visual Studio Failed

Bug #70590	Installation of MySql for Visual Studio Failed
Submitted:	10 Oct 2013 15:07	Modified:	5 Dec 2013 18:07
Reporter:	dale anderson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: Installer	Severity:	S2 (Serious)
Version:	Server 2008 R2	OS:	Windows (Server 2008 R2)
Assigned to:	Fernando Gonzalez.Sanchez	CPU Architecture:	Any
Tags:	Install Failed

Description:
I have tried serveral times to install MySql for Visual Studio on my server.
Windows Server 2008 R2
(Not Virtual Env) I have Visual Studio Pro 2010 installed on the server with SP1. Have unistalled and tried to reinstall serveral times. Reboot system inbetween attempts etc... Not sure what else to try.
Looked for others with the same problems have not run acrossed any on the forums. Below is what is reported during the install.

Action 9:42:11: INSTALL.
1: MySQL for Visual Studio 1.0.2 2: {0D406BCC-D62A-46FB-9AB7-A7BF10FB8B31}
Action 9:42:11: FindRelatedProducts. Searching for related applications
Action 9:42:11: AppSearch. Searching for installed applications
Action 9:42:11: SetHLMPath.
Action 9:42:11: LaunchConditions. Evaluating launch conditions
Action 9:42:11: ValidateProductID.
Action 9:42:11: CostInitialize. Computing space requirements
Action 9:42:11: FileCost. Computing space requirements
Action 9:42:11: CostFinalize. Computing space requirements
Action 9:42:11: InstallValidate. Validating install
Min: 0 Max: 1395
Position: 25-900 (by 25)
Action 9:42:11: Setv2InstallUtil.
Action 9:42:11: Setv4InstallUtil.
Action 9:42:11: InstallInitialize.
Action 9:42:11: RemoveExistingProducts. Removing applications
Action 9:42:11: ProcessComponents. Updating component registration
Position: 900
Action 9:42:11: GenerateScript. Generating script operations for action:
Position: 901
Position: 902
Updating component registration
DoStep
Position: 903-942
Action 9:42:11: MsiUnpublishAssemblies. Unpublishing assembly information
Action 9:42:11: UnpublishFeatures. Unpublishing Product Features
Action 9:42:11: UninstallPerfCounterData.
Action 9:42:11: RemoveRegistryValues. Removing system registry values
Action 9:42:11: RemoveShortcuts. Removing shortcuts
Action 9:42:11: RemoveFiles. Removing files
Action 9:42:11: RemoveFolders. Removing folders
Action 9:42:11: CreateFolders. Creating folders
Folder: Creating folders
DoStep
Position: 943
Position: 944
Action 9:42:11: InstallFiles. Copying new files
File: Copying new files, Directory: , Size:
DoStep
Position: 945-1041
Action 9:42:11: ManagedDataInstallSetup.
Action 9:42:11: ManagedDataInstall. Registering data provider in machine.config
Position: 1042
Position: 1043
Action 9:42:11: ManagedWebInstallSetup.
Action 9:42:11: ManagedWebInstall. Registering web providers in machine.config
Position: 1044
Position: 1045
Action 9:42:11: RegisterHelp. Registering help collection
Position: 1046
Position: 1047
Action 9:42:11: CreateShortcuts. Creating shortcuts
Shortcut: Creating shortcuts
DoStep
Position: 1048
Position: 1053
Action 9:42:11: WriteRegistryValues. Writing system registry values
Key: Writing system registry values, Name: , Value:
DoStep
Position: 1054
Position: 1075
Action 9:42:11: InstallPerfCounterData.
Action 9:42:11: RollbackRegisterPerfCounterData.

DoStep
Position: 1076
Position: 1077
Action 9:42:11: RegisterPerfCounterData.

DoStep
Position: 1078
Position: 1079
Action 9:42:11: RegisterUser. Registering user
Action 9:42:11: RegisterProduct. Registering product
Registering product
DoStep
Position: 1080
Position: 1084
Action 9:42:11: MsiPublishAssemblies. Publishing assembly information
Application Context:Publishing assembly information, Assembly Name:
DoStep
Position: 1085
Position: 1087
Action 9:42:11: PublishFeatures. Publishing Product Features
Feature: Publishing Product Features
DoStep
Position: 1088
Position: 1096
Action 9:42:11: PublishProduct. Publishing product information

DoStep
Position: 1097
Position: 1104
Action 9:42:11: InstallFinalize.
Min: 0 Max: 16050536
Position: 16050536
Action 9:42:11: ProcessComponents. Updating component registration
Step: 24000
Position: 0
Step: 24000
Position: 0
Action 9:42:11: CreateFolders. Creating folders
Folder: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\MySQL\MySQL for Visual Studio 1.0.2\
DoStep
Action 9:42:11: InstallFiles. Copying new files
File: license-antlr.html, Directory: C:\Program Files (x86)\MySQL\MySQL for Visual Studio 1.0.2\Documentation\Licenses for Third-Party Components\, Size: 16836
Action 9:42:12: ManagedDataInstall. Registering data provider in machine.config
Action 9:42:12: ManagedWebInstall. Registering web providers in machine.config
Action 9:42:12: Rollback. Rolling back action:
Min: 0 Max: 95
Registering web providers in machine.config
DoStep
Registering data provider in machine.config
DoStep
Copying new files
DoStep
Creating folders
DoStep
Updating component registration
DoStep
1: MySQL for Visual Studio 1.0.2 2: {0D406BCC-D62A-46FB-9AB7-A7BF10FB8B31} 3: 3

How to repeat:
Just try to reinstall

The Clip board did not include the last to lines.

1: Final actions.
1: Install error

message error of install failed

Attachment: 1-failed.png (image/png, text), 63.03 KiB.

Thank you for the bug report.

Hi Dale,

Thanks for your bug report.

I reproduced this bug but not exactly as you mentioned, the steps I follow:
1) Using Windows Installer for MySql, picked "MySql for Visual Studio 1.0.2" and "Connector/NET 6.7.4" and installed them (it is important to install them both).
2) Later Rerun the installer and choose Modify/Repair.
3) After this M4VS is broken (this is a known bug http://clustra.no.oracle.com/orabugs/bug.php?id=16238242). And the fix was release in Connector/Net 6.6.6 (will appear in M4VS 1.0.3 too and others).
4) Then tried the workaround, uninstall (Remove) both Connector/NET 6.7.4 & M4VS 1.0.2.
5) Then reinstalled again, this time worked fine.

So, to clarify, your prb happens after reinstall over an existing install or over a clean install (no previous product or removed previously)?

Also can you confirm this fails in Connector/NET 6.6.6? (which has a fix for it)
See
http://dev.mysql.com/downloads/connector/net/6.6.html#downloads

Regards.

Been trying to do a complete uninstall of the MySQL Applications and Connectors
Can't get MySQL Connector 6.7.4 to uninstall. Starts then just rolls back.
No one other that me as administrator on the System. Rebooted the System tried again and still will not delete. No errors Just don't delete.

Can you try uninstall Cnet 6.7.4 with this command
msiexec /x mysql-connector-net-6.7.4.msi /L*v UninstallLog.txt

And then send me the uninstall log? (either upload it or paste it).
Most likely is an error in a custom action.

Thanks.

Should have waited for your response. Instead I  removed the Sql Connector by removing MySQL registry keys and deleting the files from c:\program(x86)\mysql

Try to reinstall after rebooting No can not install the SQl Connect .net Any Version or SQl for Visual Studios.

Here is the log from the install -- (Just the end of the log If you need more just let me know)

InstallFiles: File: App.ico,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\cs\,  Size: 1078
InstallFiles: File: AssemblyInfo.cs,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\cs\,  Size: 3531
InstallFiles: File: Form1.cs,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\cs\,  Size: 11098
InstallFiles: File: Form1.resx,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\cs\,  Size: 13724
InstallFiles: File: TableEditor.csproj,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\cs\,  Size: 4280
InstallFiles: File: TableEditor.build,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\cs\,  Size: 1099
InstallFiles: File: AssemblyInfo.vb,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\vb\,  Size: 1957
InstallFiles: File: Form1.vb,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\vb\,  Size: 11404
InstallFiles: File: Form1.resx,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\vb\,  Size: 13751
InstallFiles: File: TableEditor.vbproj,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\vb\,  Size: 4507
InstallFiles: File: TableEditor.build,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Samples\Table Editor\vb\,  Size: 1314
InstallFiles: File: license-zlib.html,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Documentation\Licenses for Third-Party Components\,  Size: 17171
InstallFiles: File: license-zlib-net.html,  Directory: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.7.4\Documentation\Licenses for Third-Party Components\,  Size: 17171
Action 11:38:24: ManagedDataInstall. Registering data provider in machine.config
CAQuietExec:  Microsoft (R) .NET Framework Installation utility Version 4.0.30319.17929
CAQuietExec:  Copyright (C) Microsoft Corporation.  All rights reserved.
CAQuietExec:  
Action 11:38:24: ManagedWebInstall. Registering web providers in machine.config
CAQuietExec:  Microsoft (R) .NET Framework Installation utility Version 4.0.30319.17929
CAQuietExec:  Copyright (C) Microsoft Corporation.  All rights reserved.
CAQuietExec:  
CAQuietExec:  The installation failed, and the rollback has been performed.
CAQuietExec:  Error 0xffffffff: Command line returned an error.
CAQuietExec:  Error 0xffffffff: CAQuietExec Failed
CustomAction ManagedWebInstall returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 11:38:24: InstallFinalize. Return value 3.
Action 11:38:24: Rollback. Rolling back action:
Rollback: Registering web providers in machine.config
Rollback: Registering data provider in machine.config
Rollback: Copying new files
Rollback: Creating folders
Rollback: Updating component registration
Action ended 11:38:24: INSTALL. Return value 3.
Action ended 11:38:24: ExecuteAction. Return value 3.
Action 11:38:24: FatalError. 
Action start 11:38:24: FatalError.
Action 11:38:24: FatalError. Dialog created
Action ended 11:38:26: FatalError. Return value 2.
Action ended 11:38:26: INSTALL. Return value 3.
=== Logging stopped: 11/5/2013  11:38:26 ===
MSI (c) (C0:14) [11:38:26:185]: Product: MySQL Connector Net 6.7.4 -- Installation failed.

MSI (c) (C0:14) [11:38:26:185]: Windows Installer installed the product. Product Name: MySQL Connector Net 6.7.4. Product Version: 6.7.4. Product Language: 1033. Manufacturer: Oracle. Installation success or error status: 1603.

Well that's an extra complication. I think we can fix it.

According to Wix source code for Cnet installer the ManagedWebInstall action (which fails) does an installutil of mysql.web, so..

You can manually run it from a Visual Studio command prompt with 
installutil mysql.web.dll

Then you'll be able to see the exact error.
Where do you get mysql.web.dll? 
1. Download the zip file (from http://dev.mysql.com/downloads/connector/net/#downloads, pick ".NET & Mono" and get mysql-connector-net-6.7.4-noinstall.zip, 
2. unzip the file, 
3. then get <unzip-location>\v2\mysql.web.dll

Then post the error here.

NOTE: Going a bit forward, the error is most likely because you did not removed the assemblies from the GAC, in that case you'll need to run these commands (again from VS prompt)

gacutil /u mysql.data
gacutil /u mysql.web
installutil /u <unzip-location>\v2\mysql.data.dll
installutil /u <unzip-location>\v2\mysql.web.dll
gacutil /u mysql.data.entity

(yes, use v2 for .NET, even if you installed against VS2010, installutil just runs the Installer class for each assembly).

Thanks.

on the installutil MySQL-connector-net-6.7.4-noinstall
D:\Program Files (x86)\Microsoft Visual Studio 11.0>installutil d:\downloads\mys
ql-connector-net-6.7.4-noinstall\v2\mysql.web.dll
Microsoft (R) .NET Framework Installation utility Version 4.0.30319.17929
Copyright (C) Microsoft Corporation.  All rights reserved.

Exception occurred while initializing the installation:
System.IO.FileLoadException: Could not load file or assembly 'file:///d:\downloa
ds\mysql-connector-net-6.7.4-noinstall\v2\mysql.web.dll' or one of its dependenc
ies. Operation is not supported. (Exception from HRESULT: 0x80131515).

That's strange, are you running from an administrative Visual Studio prompt?

The other thing to try is (from VS prompt) run fuslogvw, (Fusion Log Viewer), then configure to catch loading errors (Settings -> 'Log bind failures to disk' & and set Custom log path to an empty folder). 

Then run again the installutil, that should tell what exactly was not able to load and where is looking for it.

Ok -- same error 
D:\Program Files (x86)\Microsoft Visual Studio 11.0>fuslogvw

D:\Program Files (x86)\Microsoft Visual Studio 11.0>installutil /u d:\downloads\
mysql-connector-net-6.7.4-noinstall\v2\mysql.data.dll
Microsoft (R) .NET Framework Installation utility Version 4.0.30319.17929
Copyright (C) Microsoft Corporation.  All rights reserved.

Exception occurred while initializing the installation:
System.IO.FileLoadException: Could not load file or assembly 'file:///d:\downloa
ds\mysql-connector-net-6.7.4-noinstall\v2\mysql.data.dll' or one of its dependen
cies. Operation is not supported. (Exception from HRESULT: 0x80131515).

D:\Program Files (x86)\Microsoft Visual Studio 11.0>

Must have done something wrong nothing was written to the new folder I created.
and set in the settings under fuslogvw

Log Screen

Attachment: logerror.jpg (image/jpeg, text), 296.00 KiB.

Tried the fuslogvw again attached is the Log Viewer.
Also in the Empty Folder I created is 2 new folders Default and NativeImage 
both of the folder contain a InstallUtil.exe file in them.

This is all new to me so thanks for putting up with me through these steps.

Hope U have not gave up on me.

I have not quite yet. I been reading and searching for answers.

I ran a Dependency check on the MySQL.data.dll that was failing saying it was missing dependencies. 

I am attaching both the results of that and my server hardware that I am trying to install onto.

One more thing that might make a difference I am installing through RDP as Administrator.

Dependencies

Attachment: Dependency.jpg (image/jpeg, text), 629.34 KiB.

HardWare

Attachment: Server Hardware.jpg (image/jpeg, text), 132.20 KiB.

Hi Dale,

I am still looking at this.

If you enabled fusion log viewer to only log bind failures, then the screenshot basically says it could not found none of several very core dependencies in .NET.

Connector/NET does not work with .NET 4 Client Profile, but you must have full profile since you installed VS2010 in the same machine.

Also the fact you have 64 bit OS, does not affect, Cnet it works in both x86/x64 (it's compiled with "Any CPU").

I am installing a Windows 2008 to test myself... Will get back soon.

Thanks.

Any luck with the Install on the Windows 2008 server?

Starting to looking like we will have to use ODBC for this project.

Hi Dale,

We are still trying to reproduce the bug, but we haven't get to the same steps that you mentioned. Recently we release a beta version of MySQL for Visual Studio that work better than the 1.0.2 version.
I would recommend you to install it, it should work out of the box to make connections within Visual Studio and MySQL databases. 

You can download it here:
https://cdn.mysql.com/Downloads/MySQLInstaller/mysql-visualstudio-plugin-1.1.1.msi

Please let us know if this worked for you.

Hi,

Sorry for the late notice. Confirming this fails in Windows 2008.
However seems specific of Windows Installer, running the installer standalone allows reinstall/repair to work correctly.

Thanks.

Thanks for the bug report. Fix will appear in MySql For Visual Studio 1.1.2.

Posted by developer:
 

Fix will appear in MySql For visual Studio 1.1.2.

Added the following entry to the MySQL for Visual Studio 1.1.2 changelog:

"Installation on Windows Server 2008 failed."