MySQL Bugs: #75770: MySQL Workbench + ODBC Connector Has Additional Dependencies

Bug #75770	MySQL Workbench + ODBC Connector Has Additional Dependencies
Submitted:	4 Feb 2015 17:57	Modified:	5 Mar 2015 1:17
Reporter:	Matthew Roberts	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	6.2.4	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	.net, file not found, installer

Description:
Installing MySQL Workbench on a brand new Windows OS (or machine that has not had certain Microsoft frameworks installed) causes Workbench to fail on start, Though Workbench claims to have installed successfully, the event log reports the Workbench application crashed due to a file not being found (no details which).

Additionally there is also an error attempting to install ODBC due to another dependency missing.

A Spanish comment on a page (Google translation below) on the Internet but for a different problem lists:

"if anyone is interested, I was failing me and there was no solution, what I did was repair the .net framework 4 or 4.5.1 depending on the version you have, and by that I worked, reinstall thousand times the workbench but at least my version 6.1.7 did not generate anything inside roamin me, even renaming the folder as shown above, but to repair the net framework I worked = D, I hope someone will serve you, greetings."

http://www.mandsconsulting.com/resolving-mysql-workbench-has-stopped-working-error-message...

So I realised this machine did not have a .NET Framework newer than 4.5, after installing .NET Framework 4.5.2, removing and reinstalling Workbench and rebooting it then worked (I can perform more testing if finding out which exact bit of this workaround is important).

The ODBC Connector installation also error-ed during setup with an error that looked related to a C++ re-distrubtable, so I installed Visual C++ *2010* as that used to be a requirement for older versions of MySQL Installer and that error did not appear when I then installed it again.

Apologies for being vague with the exact error messages. This was seen on another network which does not have Internet connectivity.

How to repeat:
1. Install Windows (we've tried Windows 7 and Windows 8 but DO NOT INSTALL Windows Updates (as this will likely fix the .NET problem).
2. Install the Visual C++ *2013* re-distributables that the MySQL Installer on Windows asks for.
3. Install *everything* MySQL (MySQL "Full" install).
4. Dismiss error with ODBC connector. ODBC connector installation will fail.
5. Attempt to start MySQL Workbench. Nothing will happen and the Windows Event Log will show that it crashed.

Suggested fix:
MySQL Installer on Windows and MySQL Workbench Installer should check for *all* the pre-requisites that it requires.

Discussed here
http://bugs.mysql.com/bug.php?id=74227
http://bugs.mysql.com/bug.php?id=74109
(and likely more)

.. already

Hi Peter,

Thanks for your reply. I think mine is different, those bug reports are talking about VS C++ 2013 and .NET 4.. I already had that installed.

My issue was that I didn't have .NET 4.5.2 and VS C++ 2010 *AS* *WELL* as the above and the setup doesn't know that that is a problem (but for with Workbench and ODBC it is).

Apologies my original ticket wasn't terribly clear, I was rushing to leave work :-).

Regards,
Matthew

I think they are all similar in the respect that WB (and other Windows software from Oracle/MySQL as well) is very bad at communicating to user what prerequisite requirements it has as regards shared libraries and runtimes from Microsoft, that must be installed in advance.

Agreed :-).

It's not just workbench but the ODBC connector also.

Of course you have the Full Windows Installer *and* the separate Workbench / ODBC only installers, so it's 3 different installers which will need fixing.

Thank you for the bug report.

For MySQL Workbench there are several places where it is made very clear what prerequisites are needed (e.g. the installer and here: http://dev.mysql.com/downloads/workbench/). Here is one more:

1) Microsoft .NET 4.0 client profile
2) Microsoft Visual C++ runtim 2013.

Mike,

Thanks and I agree over:

1) Microsoft .NET 4.0 client profile.
2) Microsoft Visual C++ runtime 2013.

they are perfectly clear (and were installed on the machine!)

.... but that is *NOT* the dependencies I am talking about.. you appear to also need something like .NET 4.5.1 and V C++ 2010. This is *not* documented.

That's what I tried to say, what you listed in addition is *not* required by MySQL Workbench. All what is needed are the 2 deps I listed above, really.