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: >> <[EMAIL PROTECTED]> >> Date: >> Wed, 14 Mar 2007 15:09:49 +0100 >> To: >> "FreeRadius users mailing list" <[email protected]> >> >> To: >> "FreeRadius users mailing list" <[email protected]> >> >> >> 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" >> <[EMAIL PROTECTED]> 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
