new query verification in sql.conf

[Pierluigi Di Lorenzo]

Jean Carlos Oliveira Guandalini ha scritto:
> 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.

I think you can try changing authorize_check_query giving result only if 
macaddress exists in your table.
if you use chillispot, %i is the variable having macaddress of client 
(CallingStationId).
hope this help, ciao!


> 
> Sorry for my english. I use translator! lol
> 
> Thanks
> 
> 
> Jean
>> ------------------------------------------------------------------------
>>
>> Subject:
>>
>> From:
>> <tnt at kalik.co.yu>
>> Date:
>> Wed, 14 Mar 2007 15:09:49 +0100
>> To:
>> "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
>>
>> To:
>> "FreeRadius users mailing list" <freeradius-users at 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 at 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/users.html
>>>
>>>
>>>     
>>
>>   
>>
>> ------------------------------------------------------------------------
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


-- 
Pierluigi Di Lorenzo
ePrometeus s.r.l