Results 1 to 5 of 5

Thread: sp_who

  1. #1
    Join Date
    Oct 2003
    Posts
    41

    Question Unanswered: sp_who

    I have a CGI application which connects to my ASE 12.5 database using an application ID. When I am on the Intranet application, generating reports, I do not see this account under sp_who? How can I configure, to see this?
    TIA
    Rajesh
    ====================
    Rajesh

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Your web server gateway is most likely using some other account to log into ASE. Gateways normal use a common account for all client connections.

  3. #3
    Join Date
    Oct 2003
    Posts
    41
    Originally posted by willy_and_the_ci
    Your web server gateway is most likely using some other account to log into ASE. Gateways normal use a common account for all client connections.
    That is what I am referring to. The intranet application is using an application account to connect to ASE. But when the application is running, I do not see that account on the Sybase server when I run sp_who.

    I would like to know, how I can setup to see this account when I do sp_who.

    TIA
    ====================
    Rajesh

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    You can run the sp_client_addr stored proc available in 12.5.0.1 onwards.

    There is a catch though, the hostnames is what the client tells the server, so you can't really trust it.

    1> sp_client_addr
    2> go
    spid hostname ipaddr
    ------ ---------- ---------------
    20 brumbie 137.27.65.102
    21 WILLY-LAPTO 137.27.65.112
    Last edited by willy_and_the_ci; 11-04-03 at 05:17.

  5. #5
    Join Date
    Oct 2003
    Posts
    18
    Does the CGI application stay logged in after generating its report?
    Could it be that it just logs in, selects the data and then logs out again, so quickly that you miss it in sp_who?

    To my knowledge it's not possible for a login to hide itself from the sp_who list. At the very least there must be a spid and an entry in master..sysprocesses for it.

    /Hacker

Posting Permissions

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