SQL xlat and multivalued attributes

Phil Mayers p.mayers at imperial.ac.uk
Wed Sep 24 13:36:39 CEST 2014


On 22/09/14 16:05, Alan DeKok wrote:

>    That sounds simple, but the implementation and even configuration file
> syntax isn't obvious. :(

I've wondered about some dirt-simple rlm_sqlmap like this:

sqlmap map1 {
   sql_instance = sqlmodname
   update {
     Attr-Name = row[0][0]
     Attr-Other = row[1][2]
   }
}

Alternatively, just enforce that the SQL query has to return:

select attrname, op, val from ...

...i.e. returning

request:Foo | := | bar
reply:Class | := | baz


More information about the Freeradius-Users mailing list