On Mon 16 Oct 2006 16:25, Guilherme Franco wrote: > Hi, > > Does anyone already have a program to block freeradius on-the-fly? > > ie: user has PAID = YES in radcheck table.
Sure.
Change:
authorize_check_query = "SELECT id, UserName, Attribute, Value, Op \
FROM ${authcheck_table} \
WHERE Username = '%{SQL-User-Name}' AND calledstationid
= '%{Called-Station-Id}' \
ORDER BY id"
to
authorize_check_query = "SELECT id, UserName, Attribute, Value, Op \
FROM ${authcheck_table} \
WHERE Username = '%{SQL-User-Name}' AND calledstationid
= '%{Called-Station-Id}' \
AND PAID = 'YES' \
ORDER BY id"
Cheers
--
Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc
pgp6m1fcdzGmO.pgp
Description: PGP signature
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
