MySQL Bugs: #38415: Proxy should remove listen socket on shutdown

Bug #38415	Proxy should remove listen socket on shutdown
Submitted:	28 Jul 2008 20:52
Reporter:	Kay Roepke
Status:	Verified
Category:	Proxy: Core	Severity:	S2 (Serious)
Version:	0.7.0	OS:	Any
Assigned to:	Kay Roepke	Target Version:	0.7.0
Tags:	socket, shutdown, proxy

Description:
When the proxy is started with a UNIX socket as proxy-address, we leave the socket around
after shutdown. This prevents the proxy to start up the next time.

How to repeat:
Start proxy with --proxy-address=/tmp/proxy.sock.
Shutdown proxy.
Restart with the same arguments.

Suggested fix:
Remove the socket when doing clean shutdown.

I would like to ++ this one. Using 0.6.1 and experiencing the same issue.

Also of note, when the socket is created, it does not have +W permissions for group and
everyone. I have to chmod a+w on the socket before clients can connect to it.

When mysqld starts however, this is not necessary. Why is mysqld able to correctly create
the socket for all to use but mysql-proxy is not doing so?

This simply is a bug.
I've added https://blueprints.launchpad.net/mysql-proxy/+spec/remove-unix-socket just in
case someone from the community would like to help out with this problem.

Thank you for your comment!

Heidi Bergh-Hoff writes: 
This bug should be fixed together with PR-43