User Tools

Site Tools

Squid account and quota manager

Or SQM for short.

I made it application from Maacom, with some specific logiс changes (access log scanner, password exporter, etc).

The application include sqm-helper, autentification helpler for Squid.

Used time for programming: total about 8-9 hours, too many time was checking in real work.


Order of installation and start is the same as Maacom. The application ready for use.

Source now here
The release a beta but work good.

UML object diagramm

Sqm config example

# $Id$
loglevel = debug
dbname = /var/db/sqm/sqm.db
user = squid
group = squid
# -- for postgresql --
#dbname = sqm
#dbhost =
#dblogin = sqm
#dbpassword = password
#dbengine = postgres

And install procedure for the example

# ./configure --prefix=/usr/local
# make install
# mkdir -p /var/db/sqm/
# sqlite3 /var/db/sqm/sqm.db <usr/local/share/sqm/schema.sql
# chown -Rv squid:squid /var/*/sqm
# service sqm start

Where squid:squid is user squid system user and group. You can use another ids.

Squid config example

auth_param basic program /usr/local/sbin/sqm-helper
auth_param basic children 5
auth_param basic realm WEB PROXY SERVER
auth_param basic credentialsttl 2 hours
auth_param basic casesensitive off

For checing squid auth helper you can start sqm-helper in command line

# sqm-helper
good_login good_password
some_bad_login bad_password

First PagePrevious PageBack to overviewNext PageLast Page