Hi,

> I have the following problem:
> I want to store the ip-address a client uses to connect to a database.
> It is, of course, easy to get an ip-address at the client software and store it
> to a table. The problem is here, that it has become quite common that machines
> have multiple IP-addresses for various reasons.
> One reason could be that it has two network adapters, another reason is that
> a virtual network adapter is installed, such as a virtual VMWare bridge.
>
> I don't know a sufficiently accurate way to calculate which IP-address is being
> used to connect to the firebird-server (I would to read the routes and
> the subnet
> masks of the network adapters for this), so I wonder if there's some way at the
> firebird server to access the client connection's remote ip-address.

If you are using Firebird 2.0, then use the RDB$GET_CONTEXT system
function with the SYSTEM namespace. Works like a treat, even in PSQL. ;-)



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com