Re: Get client ip address

[Kay Roepke]

zoyoo - Wrote:
-------------------------------------------------------
> Is it possible to get client ip address before
> read_handshake() in the lua script ? in
> read_handshake() there is an auth.client_addr
> however it might not work for my case:
>
> A scnario is when a query reaches mysql proxy, i
> need to decide which specific server it goes to
> base on the client addr, which means, I need to
> get the client_addr in connect_server() to decide
> which value I set for connection.backend_ndx

Hi!

You can use the proxy.connection.client.address table entry.
It is set for each connection and available once a client connects, thus
also in connect_server()

HTH,

Kay