Session Statistics Tracking Logins
I've created a process to parse the session.log and store the results into our instance of the Luminis Database. I then created a web proxy channel to report various statistics via the channel. Right now we have three reports.
1. The number of sessions per hour and the number of unique users per hour, and the percentage of sessions being unique. The stats are shown for each day.
2. The number of timeouts and the length of each session in number of minutes (example 3,428 timeouts 30 minutes)
3. The number of sessions and the length of each session in minutes (example same as #2, but it just ignores if the session timed out or was a logout).
Is anyone interested in this. I am working on making this a production worthy release for our university, but am also interested in making this distributable. I'm looking for someone who would like to work with me getting this installed in their portal so we can create the proper deliverable files and documentation. We are running an Oracle database, and the reporting is very much dependent on Oracle. However, It is not difficult to create these reports and I hope it can cross database platforms.
Session statistics
I have developed about the same as a Java application. It reads the sessions log and stores the info in an Oracle table. It also creates a text file with the results.
The collection period, and time slots interval can be determined for each run.
In addition to unique sessions, I also calculate concurrent sessions and new users.
Eventually I would like to use this for a custom channel with some plotting features.
Session Statistics
Yes, that is similar to what I have done. The collection is a separate Java application. The presentation of the reports is currently a web proxy channel. I'm looking at turning it into a Custom Channel.
I'm curious how you store the data. Do you store Completed sessions or each event? I use the session.log as my input file, but I acutally save off the timestamp of the first and last event that is currently in the file. It prevents the process from recording the stats from the same log file twice, and allows for a growing log file to be recorded before it is backed up.
Session Stats
I save to the database every event. If it is a login it creates a new record with blank values for logout/timeout columns. If it is a logout/timeout it updates the timestamp of the respective columns. Every time the application is run it checks the last entry time stamp so that entries in the database are incremental i.e. only new events are processed.
Prior to summit I had beg
Prior to summit I had began on a similar script. Except it did not use an oracle table. However I ran into an odd problem that am curious if either of you have encountered.
In going through the session.log file I have come across a user that is logged in, then you see another login event before they are logged out (not all that odd) immediately followed by a logout at the exact same time as the login, later you see another logout for that user.
I have not been able to determine how this sequence of events happen, have you encountered this issue?
Either way I would be happy to work with you in installing it in our portal to help you make it distributable.
Multiple Consecutive Logins
Yes, I have seen this. It caused quite a change in my program. I ran through some tests to reproduce this. We only allow a user to login once under an account. If they are logged in, then open another browser and try to login again, it would timeout their other session and log them out and create a new login session. The log would actually show something like:
8:00 username Login
8:22 username Login
8:22 username Timeout
8:22 username Logout
Allow a user to login multiple times?
Is there an option to prevent a user from logging in multiple times? I thought Luminis was such that it only allowed one login per user, although I have just realised that I was able to log into Luminis with my user id in one browser, and then launch a different browser and log in again.Both browsers remained active. Until I logged out of them.
Controlling multiple logins to Luminis portal
There is a setting (security.login.allow.multiple.sessions) which allows you to specify which role(s) is/are allowed to login multiple times. The default setting is to allow all users which have been assigned to pdsRole=admin to login multiple times. For more information check-out the installation documentation for Luminis III.2:
SCT Luminis Installation Guide, Version B, 6/24/04, PDF-page: 249 (Enabling Concurrent Login for Non-Admin Users)
code
I'm interested in this code. Could you release it somewhere?
Thanks,
-Madison
code
I'm working on fixing a bug I found in the log parsing side of things. Once I've addressed this, I can look at posting the code.