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

[David M. <dav...@fi...>]

This looks like a bug.  I just tracked down the cause, but I'm not 100%
sure how to fix it yet :)

It'll be fixed in the next release though.

Dave
dav...@fi...

On Fri, 2008-11-07 at 11:57 -0500, Steve Paschall wrote:
> 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
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com


_____________________________________________________________
Veteran's Day Domain Sales: Hosting + Domain = US$5.95/year
Offer Ends: Nov 12, 2008.       http://www.doteasy.com