[SR-Users] catching lost websocket ua

[Juha Heinanen]

Daniel-Constantin Mierla writes:

> The index can be useful if there is an operation in the config file,
> because I think the module doesn't do any match internally only on this
> column.

It is possible to save connection_id to hash table based on source
ip/port and then on connection close add sql_query() call to config that
removes the location table entry.

> Also, it may be needed to be done in relation with server_id, if the
> same location table is shared between different server instances that
> use server_id identifiers.

So the index would be:

CONSTRAINT connection_idx UNIQUE (`server_id`, `connection_id`)

-- Juha