wi12.unix7.org

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 https://github.com/kindsoldier/sqm
The release a beta but work good.

• Source sqm.dia

sqm.conf

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

# ./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.conf

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
OK
some_bad_login bad_password
ERR
^C
#