SQL statement in radcheck

Alan DeKok aland at deployingradius.com
Wed Sep 3 01:50:51 CEST 2008


Ljupco Vangelski wrote:
> I'm trying to allow a user to log in from few Calling-Station-Ids, but
> to load them at run-time (read them from mysql table). For that I'm
> trying to use sql statement in radcheck, but it doesn't seem to be working.
> 
> Here is a simplified example (mysql, table radcheck):
> 
>     UserName..........Attribute..............op..........Value
> (1) test                    Calling-Station-Id  ==        
> 001122334455                              (is working)
> (2) test                    Calling-Station-Id  ==         %{sql:select
> "001122334455";}    (is not working)

  That isn't valid SQL, for one.

> Can sql statements be used to compare against the Attribute Value in
> CHECK statements, like in the cases (2) above?

  Not really.

  Alan DeKok.



More information about the Freeradius-Users mailing list