Authorize based on Calling-Station-ID | Auth-type issue

[Koos Myburgh]

Hi Alan, 

I have added it to the authorize section and it works as expected. What would be the best way to get the full reply attributes from the sql radreply table other than setting the reply items for each attribute one by one?: 


if (Calling-Station-Id == "%{sql:SELECT CallingStationId FROM `radcheck` WHERE CallingStationId = %{Calling-Station-ID}}") { 
update control { 
Auth-Type := Accept 
} 
update reply { 
Framed-Ip-Address := "%{sql:SELECT staticip FROM `radreply` WHERE CallingStationId = %{Calling-Station-ID}}" 
Cisco-AVPair := "%{sql:SELECT dnsservers FROM `radreply` WHERE CallingStationId = %{Calling-Station-ID}}" 
} 
} 

Is there a way to call the "authorize_reply_query" from the sql module to get the reply items? 

Regards 
Koos 


From: "Alan DeKok" <aland at deployingradius.com> 
To: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org> 
Sent: Friday, January 20, 2017 5:44:47 PM 
Subject: Re: Authorize based on Calling-Station-ID | Auth-type issue 

On Jan 20, 2017, at 8:34 AM, Koos Myburgh <koos at rsaweb.co.za> wrote: 
> 
> I want to authorize subscribers based on calling-station-id, but I am not sure how to correctly set the auth-type. For this I have commented the pap and chap sections. 

If you want to authenticate based on Calling-Station-Id, then add this to the "authorize" section: 

if (Calling-Station-Id == "27842280395") { 
update control { 
Auth-Type := Accept/ 
} 
} 

Alan DeKok. 


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html 

Kind Regards
Koos Myburgh
Network Engineer
RSAWEB Internet Services