[fpc-pascal] FBAdmin

[Ludo Brands]

On 03/24/2013 10:54 AM, Mark Morgan Lloyd wrote:
> I've added a call to FBAdmin to what I'm working on, to get the full
> description of the server (i.e. comparable to PostgreSQL's version()
> function). Thanks Ludo :-)
> 
> Is it possible to piggyback this onto an open Firebird connection, in
> case somebody interposes some sort of connection pooling layer?
> 

In trunk you'll find TSQLConnection.GetConnectionInfo that was added for
this purpose. Use one of the TConnInfoType enums to get server or client
info.


> 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.

Ludo