Re: just introducing myself

On Thu, 2003-05-15 at 11:28, Paul Penley wrote:
> Hi
>
> I'm just starting on a project for my school to give our students a quota on
> the downloads from the net (we have a big problem with mp3 and video
> piracy). My background is that my original training in programming was over
> 20yrs ago (using punch cards.. boy am I glad those days are gone). My aim is
> to produce something that could eventually be linked in as an option within
> squid (it seems to be the best baseline to start from so I don't have to
> reinvent the wheel) & mysql as we already have some mysql db's that I need
> to talk to. My C knowledge is old (K&R) so I will probably ask a few stupid
> questions but any advice and constructive criticism will be greatly
> appreciated.

There are a number of scripts already out there that can do this very
well - without the need to hack squid itself. I've got my own one
in-house, which backs onto LDAP, and I know another admin developed one
for MySQL.

The idea is simple - you tail the squid logfile, parse out the username
and add it to their 'used' bytes in the database. Every few mins, you
read that database, find out who is over-quota and use either a
redirector or a ACL rule to deny them access :-).

Also make sure you look at what ANU has done.

Andrew Bartlett

-- 
Andrew Bartlett                                 abartlet@pcug.org.au
Manager, Authentication Subsystems, Samba Team  abartlet@samba.org
Student Network Administrator, Hawker College   abartlet@hawkerc.net
http://samba.org     http://build.samba.org     http://hawkerc.net