16 Oct
2006
16 Oct
'06
2:04 p.m.
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