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

[Paul Dagnall]

Is the SESSION_IP column from SAKAI_SESSION not accurate for your purposes?

Paul Dagnall
Application Developer & Administrator
University of Dayton


On Fri, Sep 27, 2013 at 8:51 AM, Branden Visser <mrvisser at gmail.com> wrote:

> 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"
> _______________________________________________
> 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130927/0d8b233d/attachment.html