[Building Sakai] Obtain IP address of user who logged in at a certain time

[Branden Visser]

Hi Jeremy,

There is the SAKAI_EVENTS table which logs the IP address of an event
-- I think the event is "sakai.login". Note that this is the IP
address as perceived by the Sakai server, so if you are load-balancing
behind a reverse proxy it won't be useful. There was some talk a long
time ago about also logging the X-Forwarded-For header but I don't
think there was movement on that.

If you're behind a reverse proxy, you'll want to pair your
SAKAI_EVENTS at the time of login with your HTTP access log to get the
"real" ip address of the request that triggered the login event.
Depending on how many logins there were at the time it could be
difficult to correlate.

Hope that helps,
Branden




On Fri, Sep 27, 2013 at 8:26 AM, Jeremy O'Connor <joconnor at uwc.ac.za> wrote:
> Hi
>
> Can one obtain the IP address of a user who logged in at a certain time?
>
> Regards
> Jeremy
>
> --
> Jeremy O'Connor
> Programmer
> Applications Development and Support
> Centre for Innovative Educational and Communication Technologies
> University of the Western Cape
> Tel : +27 21 959 3147
> E-Mail : joconnor at uwc.ac.za
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"