[Building Sakai] help interpretating event log
Roger Brown
roger.brown at uct.ac.za
Mon Sep 1 05:15:39 PDT 2014
Hi all
Hoping one of you gurus out there might be able to assist on the interpretation of the below log.
I'm investigating a couple of things
1) the claim by the student that they suffered a power cut during the test
2) why the site.visit.denied events (the student only has membership of a single site (that being siteid 704adb6b-f6a2-4e61-971a-62392c3ab173).
3) why was the student able to sam.assessment.take twice at times 11:00:38 and 11:36:12 (on the same session) when the timer should have expired 30 mins after the initial start
I can't reproduce activity that results in the timer not expiring the test.
Sorry about the loss of format in the queries.
Cheers
Roger
mysql> select * from SAKAI_EVENT_2014 where USER_ID='63e9d37c-a72c-4b96-b709-4fd41ed74949' and EVENT_DATE like '2014-08-28%';
+---------------------+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------+------------+-----------+--------------------------------------+--------------------------------------+
| EVENT_DATE | EVENT | REF | SESSION_ID | EVENT_CODE | EVENT_ID | USER_ID | CONTEXT |
+---------------------+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------+------------+-----------+--------------------------------------+--------------------------------------+
| 2014-08-28 10:54:40 | user.login | NULL | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119660548 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 10:54:42 | pres.begin | /presence/~63e9d37c-a72c-4b96-b709-4fd41ed74949-presence | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119660551 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 10:55:12 | pres.begin | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119661194 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 704adb6b-f6a2-4e61-971a-62392c3ab173 |
| 2014-08-28 10:55:42 | pres.end | /presence/~63e9d37c-a72c-4b96-b709-4fd41ed74949-presence | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119661891 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 704adb6b-f6a2-4e61-971a-62392c3ab173 |
| 2014-08-28 11:00:38 | sam.assessment.take | siteId=704adb6b-f6a2-4e61-971a-62392c3ab173, publishedAssessmentId=34067, agentId=63e9d37c-a72c-4b96-b709-4fd41ed74949, elapsed=0, remaining=1800 | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119667984 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 704adb6b-f6a2-4e61-971a-62392c3ab173 |
| 2014-08-28 11:13:01 | pres.end | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119683139 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 11:13:19 | pres.begin | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119683487 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 704adb6b-f6a2-4e61-971a-62392c3ab173 |
| 2014-08-28 11:26:33 | pres.end | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119700589 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 11:26:53 | user.login | NULL | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | m | 119701433 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 11:27:12 | site.visit.denied | e079a7bf-9604-457e-a255-26cb3927b2cf | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | a | 119702227 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 11:27:12 | pres.begin | /presence/!error-presence | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | m | 119702228 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | !error |
| 2014-08-28 11:27:50 | pres.begin | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119703406 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 704adb6b-f6a2-4e61-971a-62392c3ab173 |
| 2014-08-28 11:28:15 | pres.end | /presence/!error-presence | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | m | 119703977 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 11:33:22 | pres.begin | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | m | 119709845 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 704adb6b-f6a2-4e61-971a-62392c3ab173 |
| 2014-08-28 11:33:30 | site.visit.denied | e079a7bf-9604-457e-a255-26cb3927b2cf | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | a | 119710043 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 11:33:30 | pres.begin | /presence/!error-presence | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | m | 119710044 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | !error |
| 2014-08-28 11:34:31 | pres.end | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | m | 119711198 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 11:34:31 | pres.end | /presence/!error-presence | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | m | 119711199 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 11:36:12 | sam.assessment.take | siteId=704adb6b-f6a2-4e61-971a-62392c3ab173, publishedAssessmentId=34067, agentId=63e9d37c-a72c-4b96-b709-4fd41ed74949, elapsed=0, remaining=1800 | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119713286 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 704adb6b-f6a2-4e61-971a-62392c3ab173 |
| 2014-08-28 11:41:13 | pres.begin | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | m | 119719211 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 704adb6b-f6a2-4e61-971a-62392c3ab173 |
| 2014-08-28 11:42:32 | pres.end | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | m | 119720606 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 11:42:51 | pres.end | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119720909 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 11:47:26 | pres.begin | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119726337 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 704adb6b-f6a2-4e61-971a-62392c3ab173 |
| 2014-08-28 11:50:22 | pres.end | /presence/704adb6b-f6a2-4e61-971a-62392c3ab173-presence | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119729086 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 12:42:19 | user.logout | NULL | 69ddd5b8-ff54-4530-a896-3c2381b54d96 | m | 119783824 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
| 2014-08-28 12:48:18 | user.logout | NULL | 384e46f3-82e0-4c8c-b103-9715e9a3666a | m | 119789482 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | NULL |
+---------------------+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------+------------+-----------+--------------------------------------+--------------------------------------+
26 rows in set (0.00 sec)
mysql> select * from SAKAI_SESSION_2014 where SESSION_ID='69ddd5b8-ff54-4530-a896-3c2381b54d96';
+--------------------------------------+----------------------+--------------------------------------+-----------------+--------------------------------------------------------------------------------------------------------+---------------------+---------------------+------------------+
| SESSION_ID | SESSION_SERVER | SESSION_USER | SESSION_IP | SESSION_USER_AGENT | SESSION_START | SESSION_END | SESSION_HOSTNAME |
+--------------------------------------+----------------------+--------------------------------------+-----------------+--------------------------------------------------------------------------------------------------------+---------------------+---------------------+------------------+
| 69ddd5b8-ff54-4530-a896-3c2381b54d96 | vula5a-1408864423585 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 197.221.240.226 | Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36 | 2014-08-28 11:26:53 | 2014-08-28 12:42:19 | 197.221.240.226 |
+--------------------------------------+----------------------+--------------------------------------+-----------------+--------------------------------------------------------------------------------------------------------+---------------------+---------------------+------------------+
1 row in set (0.00 sec)
mysql> select * from SAKAI_SESSION_2014 where SESSION_ID='384e46f3-82e0-4c8c-b103-9715e9a3666a';
+--------------------------------------+----------------------+--------------------------------------+-----------------+-------------------------------------------------------------------+---------------------+---------------------+------------------+
| SESSION_ID | SESSION_SERVER | SESSION_USER | SESSION_IP | SESSION_USER_AGENT | SESSION_START | SESSION_END | SESSION_HOSTNAME |
+--------------------------------------+----------------------+--------------------------------------+-----------------+-------------------------------------------------------------------+---------------------+---------------------+------------------+
| 384e46f3-82e0-4c8c-b103-9715e9a3666a | vula8a-1408813233966 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 197.221.240.226 | Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0 | 2014-08-28 10:54:40 | 2014-08-28 12:48:18 | 197.221.240.226 |
+--------------------------------------+----------------------+--------------------------------------+-----------------+-------------------------------------------------------------------+---------------------+---------------------+------------------+
1 row in set (0.01 sec)
mysql> select * from SAM_ASSESSMENTGRADING_T where PUBLISHEDASSESSMENTID='34067' and AGENTID='63e9d37c-a72c-4b96-b709-4fd41ed74949';
+---------------------+-----------------------+--------------------------------------+---------------------+--------+----------+----------------+--------------------+------------+----------+----------+------------+--------+---------------------+-------------+-----------------+-----------------+---------------------+----------------------+
| ASSESSMENTGRADINGID | PUBLISHEDASSESSMENTID | AGENTID | SUBMITTEDDATE | ISLATE | FORGRADE | TOTALAUTOSCORE | TOTALOVERRIDESCORE | FINALSCORE | COMMENTS | GRADEDBY | GRADEDDATE | STATUS | ATTEMPTDATE | TIMEELAPSED | ISAUTOSUBMITTED | LASTVISITEDPART | LASTVISITEDQUESTION | HASAUTOSUBMISSIONRUN |
+---------------------+-----------------------+--------------------------------------+---------------------+--------+----------+----------------+--------------------+------------+----------+----------+------------+--------+---------------------+-------------+-----------------+-----------------+---------------------+----------------------+
| 1036946 | 34067 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 2014-08-28 11:31:08 | 0 | 1 | 3 | 0 | 3 | NULL | NULL | NULL | 1 | 2014-08-28 11:00:38 | 1800 | NULL | 0 | 0 | |
| 1037000 | 34067 | 63e9d37c-a72c-4b96-b709-4fd41ed74949 | 2014-08-28 12:06:47 | 0 | 1 | 0 | 0 | 0 | NULL | NULL | NULL | 1 | 2014-08-28 11:36:12 | 1800 | NULL | 0 | 0 | |
+---------------------+-----------------------+--------------------------------------+---------------------+--------+----------+----------------+--------------------+------------+----------+----------+------------+--------+---------------------+-------------+-----------------+-----------------+---------------------+----------------------+
2 rows in set (0.00 sec)
Roger Brown
Learning Technologies Operations Manager
Centre for Innovation in Learning and Teaching (formerly CET and HAEDSU)
7.58 PD Hahn Building Upper Campus
University of Cape Town
Email/IM/XMPP roger.brown at uct.ac.za
Skype rjg.brown
Tel:+27(21) 650 4425
________________________________
UNIVERSITY OF CAPE TOWN
This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140901/98d14519/attachment.html
More information about the sakai-dev
mailing list