So what is your actual question? :-) If you're looking for a way to track down the users' cybertrail, get MySQL or PostgreSQL to suck in the old (rotated) Squid logs (separate the fields of the logs into cells in the SQL tables when importing them), then perform searches using SQL queries. Well, write a PHB... erm, sorry ;-) a PHP interface over the database. You can identify users by IP address, or by forcing them to login to the proxy and use their usernames as keys in the search. If you rotate logs daily, then the searches are almost real-time. Not hard to do, fairly fast and very powerful. On Fri, 2003-07-18 at 13:01, Thom Paine wrote: > I have quite a bit lined up today. > > Next order of business is getting squid configured better on the > network. I'm up in arms about having it work where the users have to > input a username and password, or whether to just let it run > automatically and I'll just track the sites they visit and let the > Executive Director sort out who was on what computer when. > > I'm sure someone, or most of you on this list use squid in some capacity > to audit where the users on the network go, as well as hopefully block > access to certain websites. I've had a request to try and block a few of > the web based email sites like hotmail and yahoomail because the > employees are spending a good deal of time socializing instead of > working. > > I found a few helpful places to start, one was a porn blocker that I > thought I could use and add the other sites I want to block to the list, > but I'm having a little trouble getting it to work. It does not seem to > block the sites. Also, I set up the transparent proxy so that I can use > the squid logs to make this work. > > http://web.onda.com.br/orso/ is a site I tried to get the porn blocking > to work. Does anyone have a little time to help me with this? > > Thanks, > > -=/>Thom -- Florin Andrei "Never send a human to do a machine's job." - Agent Smith -- Shrike-list mailing list Shrike-list@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/shrike-list
