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. _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
