I did understand you well. We have the same thing, only with access phone numbers (mainly spammers) as Calling-Station-ID's that we want to ban. We also keep them in a table so they can be searched easily when someone calls and asks "why can't I connect when I have time on my account?" but in order to stop them connecting we append such entries to huntgroups file. Works great and is far simpler than rewriting code. Ivan Kalik Kalik Informatika ISP Dana 14/3/2007, "Jean Carlos Oliveira Guandalini" <jeanguandalini@visaonet.com.br> piše:
I did not explain correctly. I have a table in database with mac-adress registered, when the user connect, radius makes a verification in this table(on database) comparing mac-address of the user with mac-address registered in the database, if the mac-adress of user contain in the table(on database), user not be able to connect.
Sorry for my english. I use translator! lol
Thanks
------------------------------------------------------------------------
Subject:
From: <tnt@kalik.co.yu> Date: Wed, 14 Mar 2007 15:09:49 +0100 To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org>
To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org>
use huntgroups:
ohnoyouwont Calling-Station-ID == whatever SQL-Group == suspended
where suspended is a group with Auth-Type reject.
Ivan Kalik Kalik Informatika ISP
Dana 14/3/2007, "Jean Carlos Oliveira Guandalini" <jeanguandalini@visaonet.com.br> pi�e:
I use freeradius for authentication of pppoe wifi.
I need to make new sql query in a table with a list of mac-address, if the CallingStationId will be equal to the some mac-adress of the table then will not have to be connected. A system of mac-adress blacklist. I tried to make adding one query in sql.conf but it does not function.
I find that it would have to add a new function in rlm_sql.c, but am not habil C programmer.
Somebody can help me?
Sorry for my english
Thanks
Jean - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/usershtml
------------------------------------------------------------------------
Jean - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html