Alan DeKok напиша:
Ljupco Vangelski wrote:
I want FreeRADIUS to return the Filter-Id attribute, on behalf of a service of the client which is in another table (not in radreply or radgroupreply). The idea is to have a different Filter-Id depending on the region the client is connecting to (which means depending on the CallingStation-Id parameter). So I have a separate table in which CallingStation-Ids and Filter-Ids are mapped.
That should work.
Now if I put that query in the Filter-Id, the XLAT function doesn't get
executed: ==In radreply===================================== UserName......Attribute..........op.........Value ljupco............Filter-Id.............=.........%{sql:select service from userinfo where username='ljupco' limit 1;}
This doesn't work. You will have to put the Filter-Id in the "users" file, and put back-tics around it. Or, put it in the configuration file via "unlang". See "man unlang" for examples.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thanks Alan, it works great. I tried unlang with freeradius 2.0.5, in the authorize section: authorize { ... update reply { Filter-Id = "%{sql:select MYFIELD from MYTABLE where username='%{User-Name}';}" } ... } Another great feature, thanks again! -- Ljupco