MySQL Bugs: #65023: MySQL Proxy Does not start

Bug #65023	MySQL Proxy Does not start
Submitted:	18 Apr 2012 14:14	Modified:	19 Apr 2012 19:35
Reporter:	Ivan Barbosa	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Proxy	Severity:	S1 (Critical)
Version:	mysql-proxy-0.8.2	OS:	Windows (Windows Server 2008 R2)
Assigned to:		CPU Architecture:	Any

Description:
I'm installing the service as mentioned in the documentation.

(My configuration)Windows Server 2008 R2

sc create "Proxy" DisplayName= "MySQL Proxy" start= "auto" binPath= "C:\Program Files\MySQL\mysql-proxy-0.8.2\bin\mysql-proxy-svc.exe --proxy-backend-addresses= 10.1.1.17:3306 --proxy-read-only-backend-addresses= 10.1.1.22:3306 --proxy-read-only-backend-addresses= 10.1.1.19:3306"

After you install the service successfully.

net start proxy
the service is started
the service can not be started

If I commence by the program installation directory I get the following message:

C:\Program Files\MySQL\mysql-proxy-0.8.2\bin\mysql-proxy.exe --proxy-backend-addresses= 10.1.1.17:3306 --proxy-read-only-backend-addresses= 10.1.1.22:3306 --proxy-read-only-backend-addresses= 10.1.1.19:3306"

Assinatura do problema:
  Nome do Evento de Problema:	APPCRASH
  Nome do Aplicativo:	mysql-proxy.exe
  Versão do Aplicativo:	0.0.0.0
  Carimbo de Data/Hora do Aplicativo:	4e4bd812
  Nome do Módulo de Falhas:	KERNELBASE.dll
  Versão do Módulo de Falhas:	6.1.7601.17514
  Carimbo de Data/Hora do Módulo de Falhas:	4ce7c78c
  Código de Exceção:	c0000005
  Deslocamento de Exceção:	0000000000002110
  Versão do sistema operacional:	6.1.7601.2.1.0.18.10
  Identificação da Localidade:	1046
  Informações Adicionais 1:	30aa
  Informações Adicionais 2:	30aadb549e35ea1ea803838c7a0e87c9
  Informações Adicionais 3:	eb2c
  Informações Adicionais 4:	eb2c1db6af3bb4f5a557b93ab74227ed

Leia nossa declaração de privacidade online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0416

Se a declaração de privacidade online não estiver disponível, leia nossa declaração de privacidade offline:
  C:\Windows\system32\pt-BR\erofflps.txt

How to repeat:
I'm installing the service as mentioned in the documentation.

(My configuration)Windows Server 2008 R2

sc create "Proxy" DisplayName= "MySQL Proxy" start= "auto" binPath= "C:\Program Files\MySQL\mysql-proxy-0.8.2\bin\mysql-proxy-svc.exe --proxy-backend-addresses= 10.1.1.17:3306 --proxy-read-only-backend-addresses= 10.1.1.22:3306 --proxy-read-only-backend-addresses= 10.1.1.19:3306"

After you install the service successfully.

net start proxy
the service is started
the service can not be started

If I commence by the program installation directory I get the following message:

C:\Program Files\MySQL\mysql-proxy-0.8.2\bin\mysql-proxy.exe --proxy-backend-addresses= 10.1.1.17:3306 --proxy-read-only-backend-addresses= 10.1.1.22:3306 --proxy-read-only-backend-addresses= 10.1.1.19:3306"

Assinatura do problema:
  Nome do Evento de Problema:	APPCRASH
  Nome do Aplicativo:	mysql-proxy.exe
  Versão do Aplicativo:	0.0.0.0
  Carimbo de Data/Hora do Aplicativo:	4e4bd812
  Nome do Módulo de Falhas:	KERNELBASE.dll
  Versão do Módulo de Falhas:	6.1.7601.17514
  Carimbo de Data/Hora do Módulo de Falhas:	4ce7c78c
  Código de Exceção:	c0000005
  Deslocamento de Exceção:	0000000000002110
  Versão do sistema operacional:	6.1.7601.2.1.0.18.10
  Identificação da Localidade:	1046
  Informações Adicionais 1:	30aa
  Informações Adicionais 2:	30aadb549e35ea1ea803838c7a0e87c9
  Informações Adicionais 3:	eb2c
  Informações Adicionais 4:	eb2c1db6af3bb4f5a557b93ab74227ed

Leia nossa declaração de privacidade online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0416

Se a declaração de privacidade online não estiver disponível, leia nossa declaração de privacidade offline:
  C:\Windows\system32\pt-BR\erofflps.txt

Thank you for the report.

Please specify which exact MySQL Proxy package do you use (file name you downloaded) and if your Windows 32-bit or 64-bit

mysql-proxy-0.8.2-winx64-x86

Thank you for the feedback.

Verified as described on 64-bit Windows 7

All configurations have been tested on Windows Server 2008 R2 64-bit, does not support this?

Or am I doing something wrong?

Please double check that the required Microsoft Visual C++ runtime libraries are installed when trying to start the MySQL Proxy (see http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-install-binary.html for details).

I can repeat it on Win64.  Look exactly how I ran it.  The bug is in how command line options are parsed.

F:\>f:\sbester\mysql-proxy-0.8.2-winx64-x86\bin\mysql-proxy.exe --proxy-backend-addresses= 10.1.1.17:3306 --proxy-read-only-backend-addresses= 10.1.1.22:3306 --proxy-read-only-backend-addresses= 10.1.1.19:3306"

We lack symbols for these dll's but here is the stack trace i get:

<missing glib-2.0.dll symbols>
mysql-chassis.dll!chassis_frontend_init_plugins Line 395
mysql-proxy.exe!main_cmdline Line 474
mysql-proxy.exe!__tmainCRTStartup()  Line 586

this crashes:

F:\>f:\sbester\mysql-proxy-0.8.2-winx64-x86\bin\mysql-proxy.exe --proxy-backend-addresses=1.1.1.1

STACK_TEXT:  
 : KERNELBASE!MultiByteToWideChar+0x37a
 : kernel32!MultiByteToWideCharStub+0x1b
 : glib_2_0!kernel_mbtowc+0x4c [g:\bs\merlin-common-vs2008-64bit\src\glib-2.16.6\glib\win_iconv.c @ 1366]
 : glib_2_0!win_iconv+0x88 [g:\bs\merlin-common-vs2008-64bit\src\glib-2.16.6\glib\win_iconv.c @ 828]
 : glib_2_0!iconv+0x1d [g:\bs\merlin-common-vs2008-64bit\src\glib-2.16.6\glib\win_iconv.c @ 768]
 : glib_2_0!g_iconv+0x13 [g:\bs\merlin-common-vs2008-64bit\src\glib-2.16.6\glib\gconvert.c @ 178]
 : glib_2_0!g_convert_with_iconv+0xd3 [g:\bs\merlin-common-vs2008-64bit\src\glib-2.16.6\glib\gconvert.c @ 610]
 : glib_2_0!g_convert+0xa5 [g:\bs\merlin-common-vs2008-64bit\src\glib-2.16.6\glib\gconvert.c @ 755]
 : glib_2_0!g_locale_to_utf8+0x6c [g:\bs\merlin-common-vs2008-64bit\src\glib-2.16.6\glib\gconvert.c @ 1079]
 : glib_2_0!parse_arg+0x130 [g:\bs\merlin-common-vs2008-64bit\src\glib-2.16.6\glib\goption.c @ 1025]
 : glib_2_0!parse_long_option+0x225 [g:\bs\merlin-common-vs2008-64bit\src\glib-2.16.6\glib\goption.c @ 1383]
 : glib_2_0!g_option_context_parse+0x2d2 [g:\bs\merlin-common-vs2008-64bit\src\glib-2.16.6\glib\goption.c @ 1654]
 : mysql_chassis!chassis_frontend_init_plugins+0xd7 [g:\bs\mysql-proxy-vs2008-64bit\src\mysql-proxy-0.8.2\src\chassis-frontend.c @ 395]
 : mysql_proxy!main_cmdline+0x52c [g:\bs\mysql-proxy-vs2008-64bit\src\mysql-proxy-0.8.2\src\mysql-proxy-cli.c @ 474]
 : mysql_proxy!__tmainCRTStartup+0x11a [f:\dd\vctools\crt_bld\self_64_amd64\crt\src\crtexe.c @ 586]
 : kernel32!BaseThreadInitThunk+0xd
 : ntdll!RtlUserThreadStart+0x1d

.

Attachment: bug65023_more_info.txt (text/plain), 23.07 KiB.