Reporting usage by username
-
Ok, so I have Squid setup and is proxying connections as well as I have the category control in place. My big thing is that when I pull reports of usage I see ip addresses which is all well and good, however my client wants a list with usernames. I can obviously go into DNS and compare IP's with computer names and then cross reference to get the username list, but I really want a way to automate this. I was thinking of having a captive portal inside tied to AD to meet these needs, however I don't know how to do single sign on so the users don't get prompted again.
I'm just looking for a way to pull a report of internet usage by username. Is there anyway to achieve this or can someone point me in a general direction on how to rig something?
Thanks!
Zach -
you can use lightsquid for this
http://forum.pfsense.org/index.php/topic,42413.msg220310.html#msg220310