Register
It is currently Wed Jul 23, 2014 1:15 am

K12LTSP: Reporting software for URL requests from sessions


All times are UTC


Post new topic Reply to topic  [ 14 posts ] 
Author Message
 PostPosted: Tue Jun 14, 2005 3:15 pm   
New Member

Joined: Tue Jun 14, 2005 3:05 pm
Posts: 3
Hi!

I have a Terminal Server running K12LTSP v4.2 with about 20+ dumb/vnc terminal clients. We have an external web filtering appliance that protects the whole school district (St. Bernard's IPRISM) and we are very happy with that. One of the great functions that I like about IPRISM is that it is very user friendly and has a great reporting tool. The problem is that say for example, a student surfing the web from one of the dumb terminals goes to porn.com, it does get blocked by IPRISM, but the IP being registered on the report is not the terminal's IP but the server's IP, so we can't trace which student it is (we need this function).

So what I tried to do was enable the built-in Squid in the K12LTSP server and downloaded/installed SARG (Squid Analysis Report Generator) and integrated it to Webmin. Now I can view reports on Internet Access from the Terminal Server. Problem is that the USERID field is NOT the session name (or linux username) but instead the hostname of the Terminal Server.

Now, is there any other report generator that I can use on our K12LTSP server that reflects the linux username logged-in OR session name instead of the server hostname?

Please help.


Last edited by maquisos on Wed Jun 15, 2005 4:37 pm, edited 1 time in total.

Top
 Profile  
 PostPosted: Wed Jun 15, 2005 4:13 am   
Linux Guru
User avatar

Joined: Wed Jul 07, 2004 3:30 am
Posts: 7211
Location: Central Montana & Eastern Tennessee
maquisos Welcome to the LUG. Glad to have you here. I think we have some here that use K12LTSP, and we have a School admin. You might try a pm to crouse (LUG admin) I know he was using K12LTSP last I noticed. Once again, Welcome to the LUG :D :D
Another thing you might try instead is to change the Subject Line of the post to something like "K12LTSP problems for school admin" or "School Admin needs Login-tracing help!" to attract the people that might be familiar with the OS or the User Login problems. In other words, make the title specific to the type of help you want, then in the post you can tell all the relevant details, such as you have done. Just a suggestion.....

_________________
Dell E6400 Lappy
SolydX


Top
 Profile  
 PostPosted: Wed Jun 15, 2005 6:44 am   
Moderator
User avatar

Joined: Tue Dec 02, 2003 7:48 pm
Posts: 1723
Location: Georgia
hey maquisos...welcome to the LUG :)

if i'm understanding your comment...you have one terminal server...and the reporting software you are currently using is only listing that one server's name as the USERID instead of the dumb clients USERID...is that correct?....if so...is there a way to edit the configuration in webmin...unfortunately i don't have either k12ltsp or sarg...but it seems like a configuration issue...

_________________
server: Arch Linux - Kernel 2.6.33-ARCH
Lenovo T60 StinkPad: Arch Linux - Kernel 3.10.10-1-ARCH
VirtualBox 4.2.18 Hosted on MacOS X (10.7.5) Mountain Lion: Arch Linux - Kernel 3.10.10-1-ARCH


Top
 Profile  
 PostPosted: Wed Jun 15, 2005 7:53 am   
Ultimate Member
User avatar

Joined: Tue Apr 13, 2004 7:19 pm
Posts: 2709
Location: Kent, United Kingdom
First off wewlcome to the LUG. I've done a little bit of digging and and have found a couple of links that may be of use to you:
http://www.k12ltsp.org/phpwiki/
https://listman.redhat.com/cgi-bin/search.cgi?q=k12ltsp+squid

_________________
Ubuntu 13.04
Xubuntu 13.04


Top
 Profile  
 PostPosted: Wed Jun 15, 2005 5:02 pm   
New Member

Joined: Tue Jun 14, 2005 3:05 pm
Posts: 3
I tried everything I can in webmin's SARG configuration module... and turned on the appropriate options to supposedly display the UNIX username on the report instead of the server's hostname.. but it doesn't work. The report will still display the server's hostname. I already did all the research I can on K12ltsp wiki website and redhat's forums, but nobody has yet posted (or encountered) a similar issue.


Top
 Profile  
 PostPosted: Wed Jun 15, 2005 5:28 pm   
Ultimate Member
User avatar

Joined: Tue Apr 13, 2004 7:19 pm
Posts: 2709
Location: Kent, United Kingdom
It almost certainly is a configuration issue but as of yet I haven't found any more info for you :(

_________________
Ubuntu 13.04
Xubuntu 13.04


Top
 Profile  
 PostPosted: Wed Jun 15, 2005 6:45 pm   
Site Admin
User avatar

Joined: Thu Apr 17, 2003 3:44 am
Posts: 12193
Location: Iowa
perhaps a grep of the firefox file logs for all the students is in order ? ;)

/home/USERNAME/.mozilla/firefox/wb5xfjqk.default/history.dat

grep google.com /home/USERNAME/.mozilla/firefox/*.default/history.dat

-----------------------------------------

With a bit of tweaking you could have a bash script that would let you search the logs of all the students ..... and enter a specific SEARCH term.....

something like:

Code:
#!/bin/bash
#A bash script to search firefox history logs on all users....
read -p "Enter a website or url to search for : " searchurl

grep -H $searchurl /home/*/.mozilla/firefox/*.default/history.dat

# Should print out a nice list and get you the info you need as long as you submit the url you want to search for ;) 


ends up looking something like this when you run it......


crouse@linux:~/Scripts> sh firefoxhistorysearch.sh
Enter a website or url to search for : midiowacamaroclub.com
/home/crouse/.mozilla/firefox/wb5xfjqk.default/history.dat:<(F2F3=http://midiowacamaroclub.com/)(F2F4=1118786369098893)(F2F5
/home/crouse/.mozilla/firefox/wb5xfjqk.default/history.dat: =midiowacamaroclub.com)(F2F6=M$00i$00d$00 $00I$00o$00w$00a$00 $00C$00a$00m\
/home/crouse/.mozilla/firefox/wb5xfjqk.default/history.dat:<(F301=1118786457418506)(F300=http://www.midiowacamaroclub.com/)>
crouse@linux:~/Scripts>

obviously the offending party will have his/her username showing up right beside the offending url ;)

_________________

Warlock (VmWare Workstation - Desktop)- Linux Mint 16 64-bit -- Cinnamon Edition.
VmWare 5.1.0 ESXI Hypervisor - I7-3770K/32GB ram.
Nas4Free - 6X3TB File Server.
Multiple ubuntu 64 bit servers on the ESXI machine.


Top
 Profile WWW  
 PostPosted: Wed Jun 15, 2005 7:48 pm   
New Member

Joined: Tue Jun 14, 2005 3:05 pm
Posts: 3
OMG OMG OMG, thanks a million crouse, that script works like a charm!!! It definitely serves our purpose for the issue at hand. Best of all, its a fast search engine and I don't have to even go through webmin. Saves a lot of time, plus it's a perfect compliment for use with our IPRISM firewall.

THANKS AGAIN SIR!


Top
 Profile  
 PostPosted: Wed Jun 15, 2005 8:24 pm   
Site Admin
User avatar

Joined: Thu Apr 17, 2003 3:44 am
Posts: 12193
Location: Iowa
Your quite welcome :D Glad I could help :)

_________________

Warlock (VmWare Workstation - Desktop)- Linux Mint 16 64-bit -- Cinnamon Edition.
VmWare 5.1.0 ESXI Hypervisor - I7-3770K/32GB ram.
Nas4Free - 6X3TB File Server.
Multiple ubuntu 64 bit servers on the ESXI machine.


Top
 Profile WWW  
 PostPosted: Thu Jun 16, 2005 3:32 am   
Moderator
User avatar

Joined: Tue Dec 02, 2003 7:48 pm
Posts: 1723
Location: Georgia
enter crouse...the scripting guru... 8)

_________________
server: Arch Linux - Kernel 2.6.33-ARCH
Lenovo T60 StinkPad: Arch Linux - Kernel 3.10.10-1-ARCH
VirtualBox 4.2.18 Hosted on MacOS X (10.7.5) Mountain Lion: Arch Linux - Kernel 3.10.10-1-ARCH


Top
 Profile  
 PostPosted: Thu Jun 16, 2005 3:35 am   
Site Admin
User avatar

Joined: Thu Apr 17, 2003 3:44 am
Posts: 12193
Location: Iowa
bah ha ha ha ....... not

what i know i learned from you ;) , and my bash books lol.

_________________

Warlock (VmWare Workstation - Desktop)- Linux Mint 16 64-bit -- Cinnamon Edition.
VmWare 5.1.0 ESXI Hypervisor - I7-3770K/32GB ram.
Nas4Free - 6X3TB File Server.
Multiple ubuntu 64 bit servers on the ESXI machine.


Top
 Profile WWW  
 PostPosted: Thu Jun 16, 2005 3:44 am   
Moderator
User avatar

Joined: Tue Dec 02, 2003 7:48 pm
Posts: 1723
Location: Georgia
no...you may have learned the syntax from me and the bash books...but the problem solving is what makes a good programmer...someone could know all the syntax in the world and run themselves into the ground trying to find a way to solve a problem that someone else could do with two lines of code :wink:

_________________
server: Arch Linux - Kernel 2.6.33-ARCH
Lenovo T60 StinkPad: Arch Linux - Kernel 3.10.10-1-ARCH
VirtualBox 4.2.18 Hosted on MacOS X (10.7.5) Mountain Lion: Arch Linux - Kernel 3.10.10-1-ARCH


Top
 Profile  
 PostPosted: Fri Jun 17, 2005 3:35 am   
Linux Guru
User avatar

Joined: Wed Jul 07, 2004 3:30 am
Posts: 7211
Location: Central Montana & Eastern Tennessee
maquisos, glad you got your answer. I knew someone could "git 'er done" :D :D

_________________
Dell E6400 Lappy
SolydX


Top
 Profile  
 PostPosted: Fri Jun 17, 2005 12:42 pm   
Site Admin
User avatar

Joined: Thu Aug 28, 2003 7:09 pm
Posts: 3815
Location: 42 miles north of Ogdensburg, NY
Crouse, you rock! :D

crouse wrote:
crouse@linux:~/Scripts> sh firefoxhistorysearch.sh
Enter a website or url to search for : midiowacamaroclub.com
/home/crouse/.mozilla/firefox/wb5xfjqk.default/history.dat:<(F2F3=http://midiowacamaroclub.com/)(F2F4=1118786369098893)(F2F5
/home/crouse/.mozilla/firefox/wb5xfjqk.default/history.dat: =midiowacamaroclub.com)(F2F6=M$00i$00d$00 $00I$00o$00w$00a$00 $00C$00a$00m\
/home/crouse/.mozilla/firefox/wb5xfjqk.default/history.dat:<(F301=1118786457418506)(F300=http://www.midiowacamaroclub.com/)>
crouse@linux:~/Scripts>

obviously the offending party will have his/her username showing up right beside the offending url ;)


I'm glad that that doesn't say porn.com. :D


Top
 Profile WWW  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 14 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron


Powered by phpBB © 2012 phpBB Group
© 2003 - 2012 USA LINUX USERS GROUP