Using Virtuoso HTTP Logging to trace users NetID and WebID attributes

What?

A Common HTTP Log File Format extension for tracking activities of authenticated users, courtesy of their NetID or WebID.

Why?

Improved Activity Stream Analysis derived from HTTP log content. Fundamentally, this adds the a new degree of user identification granularity to standard HTTP logs.

How?

Simply perform the following steps:

  1. Enabling HTTP Logging in Virtuoso
  2. Enabling HTTP Logging Format in Virtuoso

With HTTP Logging Format enabled as detailed the Format String specifier "%{NetId}e" enables the logging of a users NetID or WebID (being a sub-set of NetID) to be logged.

Facebook Example

81.101.163.86 - - [23/Apr/2020:06:59:34 -0600] "GET /sparql?default-graph-uri=&qtxt=SELECT%20*%20WHERE%20%7B%3Fs%20%3Fp%20%3Fo%7D&should-sponge=&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000000 HTTP/1.1" 200 4631 "https://ods-qa.openlinksw.com/sparql/login.vsp?action=login&res=%2Fsparql%3Fdefault-graph-uri%3D%26qtxt%3DSELECT%2520*%2520WHERE%2520%257B%253Fs%2520%253Fp%2520%253Fo%257D%26should-sponge%3D%26format%3Dtext%252Fhtml%26CXML_redir_for_subjs%3D121%26CXML_redir_for_hrefs%3D%26timeout%3D30000000" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.92 Safari/537.36" "https://facebook.com/10158842828965550"

WebID Example

81.101.163.86 - - [23/Apr/2020:07:02:12 -0600] "GET /sparql?default-graph-uri=&qtxt=SELECT%20*%20WHERE%20%7B%3Fs%20%3Fp%20%3Fo%7D&should-sponge=&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000000 HTTP/1.1" 200 4608 "https://ods-qa.openlinksw.com/sparql/login.vsp" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.92 Safari/537.36" "http://ods-qa.openlinksw.com/dataspace/person/dba#this"

Related