Bug #60392 MySQL Proxy doesn't listen op IPv6
Submitted: 8 Mar 2011 16:29 Modified: 16 Jul 2011 13:08
Reporter: Daniël van Eeden Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Proxy: Core Severity:S3 (Non-critical)
Version:0.8.1, 0.9.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: ipv6
Triage: Needs Triage: D3 (Medium)

[8 Mar 2011 16:29] Daniël van Eeden
Description:
The default setting for mysql proxy is to listen on all IP's.

"The listening host name (or IP address) and port of the proxy server. The default is :4040 (all IPs on port 4040)."
http://dev.mysql.com/doc/refman/5.5/en/mysql-proxy-configuration.html

It's not completely true: It will only listen on all IPv4 IPs.

How to repeat:
# mysql-proxy -proxy-address=:1234
# lsof -i :1234

Suggested fix:
Option 1 (Easy): Fix the documentation

Option 2 (The best): Bind on a IPv6 TCP Socket.
[16 Jul 2011 13:08] Valeriy Kravchuk
Thank you for the bug report. Verified just as described with version 0.9.0 (current lp:mysql-proxy) on Mac OS X:

macbook-pro:mysql-test openxs$ ps aux | grep proxy
openxs   93061   0.0  0,0   599820    460 s001  S+    4:06     0:00.00 grep proxy
openxs   93059   0.0  0,0    79632   2008 s000  S+    4:05     0:00.13 bin/mysql-proxy --admin-username=root --admin-password=root --admin-lua-script=/Users/openxs/dbs/proxy/lib/mysql-proxy/lua/admin.lua --proxy-address=:9999
root     50011   0.0  0,1   604144   4908   ??  S    чт10    0:00.33 /usr/sbin/named -c /etc/com.apple.named.conf.proxy -f
macbook-pro:mysql-test openxs$ lsof -i :9999
COMMAND     PID   USER   FD   TYPE    DEVICE SIZE/OFF NODE NAME
mysql-pro 93059 openxs   10u  IPv4 0xfc2b66c      0t0  TCP *:distinct (LISTEN)