[Dbbalancer-users] Working! :-)

[Andrew M. <an...@ca...>]

OK,

I now have it working.  A few more things I had to change to get it
trucking along nicely:

1) I had to set 'umask 0' - otherwise the socket was being owned by the
user running dbbalancerd, and was not writeable by the webserver user.

2) I had to make the change suggested by Tom Lane to send back an 'N' if
the client requested an SSL connection, and loop back to wait for a
non-SSL connection request.

You can probably fix (1) quite trivially in the code.  I note that
Postgresql creates the socket as mode 777.

You probably don't want to see how crudely I worked around (2) - I'm
sure that you can do a better job if I just hint that it did:

 send(fe_socket,"N",1,SEND_FLAGS);

near line 63 of DBPostgresFrontend.cc

Regards,
					Andrew.

-- 
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/        PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201    MOB: +64(21)635-694    OFFICE: +64(4)499-2267