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.

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
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.....

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...

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

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.

It almost certainly is a configuration issue but as of yet I haven't found any more info for you

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:



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

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!

Your quite welcome Glad I could help

enter crouse...the scripting guru...

bah ha ha ha ....... not

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

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

maquisos, glad you got your answer. I knew someone could "git 'er done"

Crouse, you rock!



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