Project

General

Profile

Feature #7268

IP address of the users

Added by Eric Petitdemange about 5 years ago. Updated over 4 years ago.

Status:
Feature implemented
Priority:
Normal
Assignee:
Category:
Database & API changes
Target version:
Start date:
14/09/2014
Due date:
% Done:

100%

Estimated time:
8.00 h
Spent time:
Complexity:
Challenging
SCRUM pts - complexity:
13

Description

Hi all,

I could be wrong (this is why I stated feature rather than bug), but in "Follow-up" tab I can't find anymore the IP address of the trainees (I obviously login as Administrator).

In "Administration" tab I can find the IP for something like major events, but it is very good for a better follow-up to get the IP address (given that it changes quite often, so this can be a field that is using the connection date and the user Id to fill the "IP table".

If any could give me a hand to retreive the IP address of the trainees, this would be more than great.

If at least you could tell e in which tables of the database I could find the info this would be nice :)

Thanks in advance !
Have a nice end of week-end.

Associated revisions

Revision d2d1206f (diff)
Added by Angel Fernando Quiroz Campos over 4 years ago

Rename table column from login_ip to user_ip - refs #7268

Revision 39c65769 (diff)
Added by Angel Fernando Quiroz Campos over 4 years ago

Add and register ip in new fields - refs #7268

Revision d1a21a6c (diff)
Added by Angel Fernando Quiroz Campos over 4 years ago

Rename track_e_exercices to track_e_exercises table - refs #7268

Revision 999c61ed (diff)
Added by Angel Fernando Quiroz Campos over 4 years ago

Show user IP on exercise report - refs #7268

Revision 857fc4c0 (diff)
Added by Angel Fernando Quiroz Campos over 4 years ago

Show user IP on exercise overview - refs #7268

Revision fec32f85 (diff)
Added by Angel Fernando Quiroz Campos over 4 years ago

Show user IP on exercise results - refs #7268

Revision 30b8f4bf (diff)
Added by Angel Fernando Quiroz Campos over 4 years ago

Fix exercise results page - refs #7268

Revision 04c7fff3 (diff)
Added by Angel Fernando Quiroz Campos over 4 years ago

Show user IP on grade activity for teacher - refs #7268

Revision a9df86da (diff)
Added by Yannick Warnier over 4 years ago

Update api_get_real_ip() function to use explode - refs #7268

Revision 01882969 (diff)
Added by Yannick Warnier over 4 years ago

Fix remaining track_e_exercices and other minor issues with the renaming of the table (and update db version) - refs #7268

History

#1

Updated by Yannick Warnier almost 5 years ago

  • Target version set to 1.10.0
#2

Updated by Yannick Warnier over 4 years ago

  • Category set to Database & API changes
  • Status changed from New to Assigned
  • Assignee set to Angel Quiroz
  • Estimated time set to 8.00 h
  • Complexity changed from Normal to Challenging
  • SCRUM pts - complexity changed from ? to 13

This could require the addition of the IP address to some track_e_ tables.

track_e_login and track_e_online already have a "login_ip" field.

I believe it would be good to uniformize this and make sure they can store IPv6 addresses (39 chars):
  • change login_ip to user_ip in track_e_login and track_e_online
  • add user_ip to track_e_exercices, track_e_access and track_e_course_access (I believe this would be enough to have a decent tracking of all important activities)
  • add the code necessary to log these IPs wherever we try to fill these tables
  • additionally, let's enjoy this opportunity to rename track_e_exercices to track_e_exercises as it always should have been

Finally, to ensure that this task can be closed, make sure that the IP appears next to the attempts in the exercises results pages.

#3

Updated by Eric Petitdemange over 4 years ago

Hi to you all,
First of all, IP V4 was working from yesterday's github update.
I will double check on the stable 1.9.10 just to ensure :)

IP V6 seems to be important, agree :)

Thanks for your efforts.

#5

Updated by Angel Quiroz over 4 years ago

  • Status changed from Assigned to Needs testing
  • Assignee deleted (Angel Quiroz)

Due to updating the table name to track_e_exercises, you must update your Chamilo installation. Otherwise the data will be not registered

#6

Updated by Yannick Warnier over 4 years ago

We will be explaining in two weeks or so how to test 1.10.0. At the moment we're making a series of structural changes, so the only way to get the latest version is to download a git version from github and install it from 0. Other techniques are more... technical.

#7

Updated by Yannick Warnier over 4 years ago

  • Status changed from Needs testing to Feature implemented
  • Assignee set to Angel Quiroz
  • % Done changed from 0 to 100

Also available in: Atom PDF