[Sqlrelay-discussion] UNIX sockets only -- no TCP

[Steve P. <ste...@gm...>]

I can't find mention of this in the documentation, but the first
example in the Routing and Filtering how-to indicates that using an
empty value for the port in an instance config will prevent
sqlr-listen from binding to a port -- it'll only use a local socket. I
can't make it work. It binds to port 9000 no matter what I've tried.
It isn't a _huge_ deal, but I'd really like it to work if possible.

I have a typical master-slave setup I'd like to route queries between.
I'm leaving out the other rot to protect the innocent and keep this
brief:

<instance id="dev_master" port="" socket="/tmp/dev_master.socket"
dbase="mysql">...</instance>

<instance id="dev_slave" port="" socket="/tmp/dev_slave.socket"
dbase="mysql">...</instance>

Either instance starts up fine on its own, but starting the other
instance gives me a "Could not listen on: 0.0.0.0/9000 \ Error was:
Address already in use".

I've tried setting port to a space char, setting addresses to
127.0.0.1, empty, and a space char, and all combinations thereof.
Setting non-conflicting ports for each instance is the only thing
that's worked for me.

I can make it bind only to the localhost, but that isn't optimal. Any
suggestions from the gurus?

(CentOS 5, x86/32)

--
Steve Paschall