Re: Can I Determine Client IP Address?

Is this using ODBC? There I have no suggestions, but if you have the pty/pts/nty (deps on your 'nix) then you could always use the wtmp file or the results of 'last' brett Watson Paul wrote: > > What's wrong with a straightforward single ping? The > response should be a sub 100ms > > > -----Original Message----- > > From: Fred Prose [mailto:fprose@supreme.sp.state.az.us] > > Sent: Friday, November 17, 2000 2:00 PM > > To: informix-list@iiug.org > > Subject: Can I Determine Client IP Address? > > > > > > Is there a way to determine the IP Address of a client PC connected to > > Informix? I see where the Hostname (TTY) is available, but > > we don't run > > DNS, so there's no way to resolve it that way. > > > > What I'm looking to do is this: > > > > 1. Create a security/transaction log that records who and > > from where a > > client connected. > > > > 2. Provide a mechanism (through a CRON activity) that > > performs a PING and a > > TRACEROUTE on a connected client on a periodic basis and records the > > results. This is primarily in response to complaints that > > the server is > > "too slow". Any measurements we take indicate sub-second > > response "on the > > box" but, depending upon when and where connections occur, > > certain users are > > complaining. It would be nice to counter emotions with fact. > > It would be > > nice if our networking folks could do this for me.... > > > > Thanks. > > > > > > > > > > ********************************************************************** > The contents of this e-mail are confidential to the ordinary user(S) of the > mail address(es) to which it was sent and may be legally privileged. > If you are not the intended recipient, any disclosure, copying, distribution > or use of it, or any part of it, in any form whatsoever, and any actions > taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. > ********************************************************************** -- ----------------------------------------------------------------- Brett's ninth law of UNIX administration... Ye shall read the words: http://cm.bell-labs.com/who/ken/index.html http://cm.bell-labs.com/who/dmr/index.html ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- If you have any trouble sounding condescending, find a Unix user to show you how it's done. --Scott Adams -----------------------------------------------------------------