Bug #62223 MySQL proxy does not start
Submitted: 22 Aug 2011 6:39 Modified: 9 Jul 2012 19:40
Reporter: Mahesh Patil Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Proxy Severity:S1 (Critical)
Version:0.8.2 Alpha OS:Windows (Windows 7 64 bit)
Assigned to: CPU Architecture:Any

[22 Aug 2011 6:39] Mahesh Patil
Description:
Unable to start MySQL proxy with default settings:

mysql-proxy.exe --proxy-backend-addresses=myPC:3306 --proxy-address=myPC:4040

Shows this error in console:

The application has failed to start because its side-by-side configuration is incorrect. 
Please see the application event log or use the command-line sxstrace.exe tool for more detail.

Note: I have installed VC++ 2008 redistributable ... still problem persists.
Prior to this version MySQL proxy was working fine.

How to repeat:
Start a proxy with default settings, Unable to start and throws error mentioned in description section.

Suggested fix:
MySQL proxy should be functional
[22 Aug 2011 10:59] Mahesh Patil
MySQL proxy does not start
[22 Aug 2011 11:01] Valeriy Kravchuk
Please, send the output of:

ping myPC
netstat -a

commands from cmd.exe. 

I do not see any problem with running proxy this way on localhost under 32-bit Windows XP.
[22 Aug 2011 11:09] Mahesh Patil
1)Output of PING

C:\Windows\system32>ping MAHESH-PC

Pinging 192.168.1.86 with 32 bytes of data:
Reply from 192.168.1.86: bytes=32 time<1ms TTL=128
Reply from 192.168.1.86: bytes=32 time<1ms TTL=128
Reply from 192.168.1.86: bytes=32 time<1ms TTL=128
Reply from 192.168.1.86: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.1.86:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

2)Output of NETSTAT:

C:\Windows\system32>netstat -a

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    0.0.0.0:80             MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:135            MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:445            MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:3320           MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:3389           MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:5357           MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:5555           MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:49152          MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:49153          MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:49154          MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:49155          MAHESH-PC:0            LISTENING
  TCP    0.0.0.0:49166          MAHESH-PC:0            LISTENING
  TCP    127.0.0.1:40101        MAHESH-PC:0            LISTENING
  TCP    127.0.0.1:51663        www:51664              ESTABLISHED
  TCP    127.0.0.1:51664        www:51663              ESTABLISHED
  TCP    127.0.0.1:51665        www:51666              ESTABLISHED
  TCP    127.0.0.1:51666        www:51665              ESTABLISHED
  TCP    192.168.1.86:139       MAHESH-PC:0            LISTENING
  TCP    192.168.1.86:3320      192.168.1.16:52849     ESTABLISHED
  TCP    192.168.1.86:3320      192.168.1.16:52850     ESTABLISHED
[22 Aug 2011 11:15] Mahesh Patil
D:\mysql-proxy\mysql-proxy-082\mysql-proxy-0.8.2-winx64-x86\bin>mysql-proxy.exe
--proxy-backend-addresses=192.168.1.86:3320 --proxy-address=192.168.1.86:4040

The application has failed to start because its side-by-side configuration is in
correct. Please see the application event log or use the command-line sxstrace.e
xe tool for more detail.

I think problem might be with Windows 7(64 bit), works fine in RHEL 64 bit machine though.
[2 Nov 2011 22:57] Sveta Smirnova
Thank you for the report.

Verified as described.

It complains about missed "Microsoft.VC90.CRT,processorArchitecture="x86",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="9.0.30729.6161
[7 Nov 2011 11:31] Sveta Smirnova
This is actually not a bug.

Please read at http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-install-binary.html:

"The Microsoft Visual C++ runtime libraries are a requirement for running MySQL Proxy as of version 0.8.2. Users that do not have these libraries must download and install the Microsoft Visual C++ 2008 Service Pack 1 Redistributable Package MFC Security Update. Use the following link to obtain the package:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26368"
[9 Nov 2011 10:03] Mahesh Patil
MS Visual c++ 2008 dist..

Attachment: CP_pic.PNG (image/png, text), 37.00 KiB.

[9 Nov 2011 10:04] Mahesh Patil
I have installed this mentioned package as well still mentioned error persists.
Can you please help me out to work with v0.8.2
[9 Nov 2011 10:11] Mahesh Patil
I will mark it as open please see attached screen shot in above post
[9 Nov 2011 12:02] Peter Laursen
Some information about this error here: 

http://8help.osu.edu/4303.html
http://www.winvistaclub.com/f16.html
http://buffered.io/2008/05/17/resolving-side-by-side-configuration-issues/
[1 Dec 2011 18:57] Sveta Smirnova
Mahesh,

thank you for the feedback.

Please open Control Panel->Administration->Events Viwer, then navigate to System->Applications, find error which MySQL Proxy produced ans send its text to us.
[2 Dec 2011 6:34] Mahesh Patil
- System 

  - Provider 

   [ Name]  SideBySide 
 
  - EventID 33 

   [ Qualifiers]  49409 
 
   Level 2 
 
   Task 0 
 
   Keywords 0x80000000000000 
 
  - TimeCreated 

   [ SystemTime]  2011-12-02T06:29:41.000000000Z 
 
   EventRecordID 17044 
 
   Channel Application 
 
   Computer MAHESH-PC 
 
   Security 
 

- EventData 

Microsoft.VC90.CRT,processorArchitecture="amd64",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="9.0.30729.6161" 
D:\mysql-proxy\mysql-proxy-082\mysql-proxy-0.8.2-winx64-x86\bin\mysql-proxy.exe
[2 Dec 2011 19:40] Sveta Smirnova
Thank you for the feedback.

type="win32" - do you run 32-bit Windows on 64-bit machine? If yes, please try 32-bit version of MySQL Proxy.
[9 Dec 2011 12:23] Peter Laursen
I wonder if this is related:
http://bugs.mysql.com/bug.php?id=63684

(adding C++ redistributable had effect for Workbench on XP but not on Vista).
[9 Dec 2011 13:03] Mahesh Patil
I am using mysql-proxy-0.8.2-winx64-x86.zip
My OS is Windows 7 Ultimate 64 bit.
[12 Dec 2011 22:02] Sveta Smirnova
Thank you for the feedback.

In this case you seems to be needing x64 redistributable package. Please try and inform us about results.

(I just tested on my own 64-bit Win 7 machine and it perfectly works.)
[12 Dec 2011 22:03] Sveta Smirnova
Peter,

> adding C++ redistributable had effect for Workbench on XP but not on Vista)

This perfectly works on my Vista machine.
[13 Jan 2012 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[9 Jul 2012 5:34] Mahesh Patil
This has been solved after installing Microsoft Visual C++ 2008 Redistributable x64 9.0.30729.6161
[9 Jul 2012 19:40] Sveta Smirnova
Thank you for the feedback.

Closed as not MySQL bug since installation of required package fixed the problem.