obtaining userid from login(was _connect)

[Mike Clark]

Hi

As I have had no response I will try again.


I am trying to tie up the userid logins with the _connect table but am having difficulty – because the userid does not seem to appear in the _connect table.

Windows 2003, Progress 9.1E Enterprise


The following is a part of the db.log

Mon Jun 05 07:24:28 2006
09:21:14 SRV 7: Login usernum 56, userid jsmith, on DD7VBY1J. (742)
09:24:14 SRV 8: Login usernum 55, userid fredjones, on DHP1X42J. (742)
09:26:40 SRV 8: Login usernum 54, userid Dpmanager, on DPlonczyk. (742)

and this is part of a print out from the _connect table
Login time: Mon Jun 05 09:31:27 2006 Pid: 2060 Srv: 8
Wait1: 0 Wait: -- Trans id: 0 SemNum: 0
Semid: 0 Disconnect: 0 Resyncing: 0
Interrupt: 0 2phase: 0 Batch User: No Misc: ?
User-Id: 54 Type: REMC Name: Device: DPlonczyk
Login time: Mon Jun 05 09:26:40 2006 Pid: 2188 Srv: 8
Wait1: 0 Wait: -- Trans id: 0 SemNum: 0
Semid: 0 Disconnect: 0 Resyncing: 0
Interrupt: 0 2phase: 0 Batch User: No Misc: ?
User-Id: 55 Type: REMC Name: Device: DHP1X42J
Login time: Mon Jun 05 09:24:14 2006 Pid: 3344 Srv: 8
Wait1: 0 Wait: -- Trans id: 0 SemNum: 0
Semid: 0 Disconnect: 0 Resyncing: 0
Interrupt: 0 2phase: 0 Batch User: No Misc: ?
User-Id: 56 Type: REMC Name: Device: DD7VBY1J
Login time: Mon Jun 05 09:21:14 2006 Pid: 3624 Srv: 7
Wait1: 0 Wait: -- Trans id: 0 SemNum: 0
Semid: 0 Disconnect: 0 Resyncing: 0
Interrupt: 0 2phase: 0 Batch User: No Misc: ?

Any ideas as to where to find the userid and the related device would be most helpful

Mike

 

[KnutHandsome]

Are the user ids shown in the log db or os ids?
Might the users be logging in with blank db user ids?

See this KB entry:

P14172
Title: "Promon Proshut shows blank user id information"
http://tinyurl.com/fxbal

See also SETUSERID function

There's also a few related Peg threads.

 

[TomBascom]

_connect._connect-name is the current "userid" corresponding to the _connect record whose _connect._connect-id is equal to the "Login usrnum" shown in the .lg file.

Which may not be the original userid shown in the .lg file (a login that uses the setuserid() 4GL function may have changed it...)

There may also be multiple login/logout messages that reuse the usrnum in the .lg file. Only the most recent login and only those since the last db start should be used.