[fpc-pascal] Re: FBAdmin

[Reinier Olislagers]

On 24-3-2013 12:11, Ludo Brands wrote:
> On 03/24/2013 10:54 AM, Mark Morgan Lloyd wrote:
>> Is there any way of determining what port the client is using for an
>> open connection (i.e. not the 3050 at the server end)? Postgres
>> implements this with inet_client_port(), and I'm considering a situation
>> where the port numbers could be used as a low-security authenticator for
>> backchannel commands (e.g. so that a server could tell a client to choke
>> work it's relaying for one particular user who's hogging bandwidth).
>>
> 
> inet_client_port is an SQL function used for example to log the client
> connection. It is only valid for the current connection. I'm not aware
> of anything similar in Firebird. Interbase 7+ has the TMP$ATTACHMENTS
> table that has info on all connections but afaik Firebird doesn't have
> this yet.
> 

For Firebird, look at the MON$ATTACHMENT table, e.g.
select * from MON$ATTACHMENTS where MON$ATTACHMENT_ID = CURRENT_CONNECTION

(or of course, all connections). At least client IP address is shown.