X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A78869DC814 for ; Fri, 24 Feb 2006 19:22:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16051-07 for ; Fri, 24 Feb 2006 19:22:03 -0400 (AST) X-Greylist: delayed 00:05:19.389132 by SQLgrey- Received: from vsmtp1.tin.it (vsmtp1.tin.it [212.216.176.141]) by postgresql.org (Postfix) with ESMTP id 5E8D79DCA94 for ; Fri, 24 Feb 2006 19:21:59 -0400 (AST) Received: from [82.50.75.154] (82.50.75.154) by vsmtp1.tin.it (7.2.060.1) (authenticated as apbertolini@virgilio.it) id 43EA4CB100C2E881 for pgsql-sql@postgresql.org; Sat, 25 Feb 2006 00:17:19 +0100 Message-ID: <43FF93CF.5070808@computer.org> Date: Sat, 25 Feb 2006 00:16:31 +0100 From: Alexis Paul Bertolini User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Obtaining client IP address Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200602/306 X-Sequence-Number: 24316 Hi, I need to have a db table containing all connected clients (of a distributed application) and among other info, their IP. If both the client and the server are on the same LAN, no problem, the client can supply it's own info. But if they are connected via some sort of bridge/router/NAT? For instance, a client on a LAN connects to a server over the Internet? The client has no idea what public IP it has. The server ought to know... however I haven't found how I could get this info into my query. What I need is some sort of procedure whereby the client enrolls onto the system and supplies the info... I hope I made my self clear. If not I can try and be more specific! Alex.