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: | |
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 |
[10 Oct 2013 15:07]
dale anderson
[10 Oct 2013 15:29]
dale anderson
The Clip board did not include the last to lines. 1: Final actions. 1: Install error
[29 Oct 2013 21:58]
MySQL Verification Team
message error of install failed
Attachment: 1-failed.png (image/png, text), 63.03 KiB.
[29 Oct 2013 22:00]
MySQL Verification Team
Thank you for the bug report.
[4 Nov 2013 20:20]
Fernando Gonzalez.Sanchez
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.
[5 Nov 2013 14:10]
dale anderson
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.
[5 Nov 2013 16:59]
Fernando Gonzalez.Sanchez
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.
[5 Nov 2013 17:56]
dale anderson
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.
[5 Nov 2013 18:32]
Fernando Gonzalez.Sanchez
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.
[5 Nov 2013 19:23]
dale anderson
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).
[5 Nov 2013 21:02]
Fernando Gonzalez.Sanchez
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.
[6 Nov 2013 20:05]
dale anderson
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
[6 Nov 2013 20:15]
dale anderson
Log Screen
Attachment: logerror.jpg (image/jpeg, text), 296.00 KiB.
[6 Nov 2013 20:19]
dale anderson
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.
[7 Nov 2013 16:05]
dale anderson
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.
[7 Nov 2013 16:15]
dale anderson
Dependencies
Attachment: Dependency.jpg (image/jpeg, text), 629.34 KiB.
[7 Nov 2013 16:15]
dale anderson
HardWare
Attachment: Server Hardware.jpg (image/jpeg, text), 132.20 KiB.
[7 Nov 2013 16:21]
Fernando Gonzalez.Sanchez
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.
[13 Nov 2013 14:12]
dale anderson
Any luck with the Install on the Windows 2008 server? Starting to looking like we will have to use ODBC for this project.
[27 Nov 2013 20:36]
Gabriela Martinez Sanchez
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.
[27 Nov 2013 22:12]
Fernando Gonzalez.Sanchez
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.
[2 Dec 2013 18:42]
Fernando Gonzalez.Sanchez
Thanks for the bug report. Fix will appear in MySql For Visual Studio 1.1.2.
[2 Dec 2013 18:44]
Fernando Gonzalez.Sanchez
Posted by developer: Fix will appear in MySql For visual Studio 1.1.2.
[5 Dec 2013 18:06]
Daniel So
Added the following entry to the MySQL for Visual Studio 1.1.2 changelog: "Installation on Windows Server 2008 failed."