Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Posts
    51

    Red face Unanswered: tie a session back to a machine or ip address

    Hey all...for better or worse (worse) we have a bunch of little apps that run as informix. Is there a way to tie the sessions (all running as informix) back to the machine/ip address that started them? That would allow me some ability to know who is doing what in what right now seems like a black box environment.
    -thanks in advance
    When in doubt just ask your self,
    -WWSBD?-
    (what would Sponge Bob do?)

  2. #2
    Join Date
    Jun 2003
    Location
    Hamburg, Germany
    Posts
    38
    onstat -g ses


    This will give you info about the pid, etc. You can use the 'ps' command in Unix to track back through calling processes if you need to.

  3. #3
    Join Date
    Sep 2002
    Posts
    51

    thanks

    Thanks!

    Originally posted by AdiHH
    onstat -g ses


    This will give you info about the pid, etc. You can use the 'ps' command in Unix to track back through calling processes if you need to.
    When in doubt just ask your self,
    -WWSBD?-
    (what would Sponge Bob do?)

  4. #4
    Join Date
    Sep 2003
    Posts
    10

    little more needed

    What I really want to do is tie the session info back to an IP address (or something!) if possible. This is a intel environment so tty's are few and far in between and I have all these users running apps that signon as informix and it makes them way to anonymous!

    And before anyone says it, changing the apps is a losing fight here due to the development staffs project load and priorities...I know theres a cadilac methodology/infrastructure/security standard that would solve all of these probs, but its out of my control so I am looking for a bandaid solution.

    Sorry to be a pain and I am no informix guru.
    -thanks

    Originally posted by AdiHH
    onstat -g ses


    This will give you info about the pid, etc. You can use the 'ps' command in Unix to track back through calling processes if you need to.
    Karma...it works regarless of your belief in it.

  5. #5
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    I've been around this topic before. Unfortunately, there's no way to derive an IP address from a session. According to the developers there's several "good" reasons why they don't. Even the "TTY", which is retained by Informix is unreliable because Informix only keeps eight characters and the folks who configure PC's have gone to some very descriptive (no them) names where the only thing that really matters has been truncated.
    Fred Prose

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •