Feature #5199

Add IP and user agent in track_e_attempt

Added by Yannick Warnier almost 10 years ago. Updated 8 months ago.

Rejected - Abandoned
Database & API changes
Target version:
Start date:
Due date:
% Done:


Estimated time:
SCRUM pts - complexity:


In order to improve the security around the taking of an exam, we should track the IP address and user agent string of the user while he/she is taking the exam.

As this might require much more processing time when a lot of users take the test simultaneously, the IP and user-agent should be stored in the session.

The track_e_attempt table should be made a full fixed-length table:
  • the course code should be changed to course int ID
  • the ipaddr (new field) should be made a char(38) (to accomodate IPv6)
  • the User-Agent string should be stored in a separate table and referenced by an integer ID in track_e_attempt

Related issues

Related to Chamilo LMS - Feature #7332: IPv6 compatibilityNew16/10/2014

Related to Chamilo LMS - Feature #5129: Track student IP when taking examFeature implemented03/07/2012




Updated by Jérôme Warnier about 7 years ago

  • Status changed from New to Assigned
  • Assignee set to Yannick Warnier

Updated by Yannick Warnier about 7 years ago

  • Category set to Exercises
  • Assignee deleted (Yannick Warnier)
  • Priority changed from High to Normal

This is not really necessary for 1.10.x, but we have already moved the litteral course code to a course ID.
The user_ip field has been added to track_e_exercise, but I think it's still a good idea to store it (additionally) into track_e_attempt for the "paranoid" mode.


Updated by Yannick Warnier over 5 years ago

  • Category changed from Exercises to Database & API changes
  • Assignee set to Julio Montoya
  • Priority changed from Normal to High

Updated by Julio Montoya over 5 years ago

  • Status changed from Assigned to Needs more info
  • Assignee changed from Julio Montoya to Yannick Warnier

"track_e_exercises" table already has a "user_ip" field. Only a new field called "user_agent" should be added.

Are you sure you're talking about "track_e_attempt"?


Updated by Yannick Warnier 8 months ago

  • Status changed from Needs more info to Rejected - Abandoned

Also available in: Atom PDF