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
• Status: Verified
• Category: MySQL Proxy: Core
• Severity: S3 (Non-critical)
• Version: 0.8.1, 0.9.0
• OS: Any
• CPU Architecture: Any
• Tags: ipv6

[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)