arr2036
commented
9 years ago The concept Alan and I discussed was to create mapping sections in the rlm_sql module. This is consistent with the ldap module, and couchbase.
In the sql module you would have something like:
sql {
map {
static_ip {
Framed-Route := 'framedRoute'
Framed-IP-Address := 'framedIPAddress'
<radaddr> := '<sqlattr>'
}
multi {
<radaddr> += '<sqlattr>'
}
}
}Then in a virtual-server:
if ("%{static_ip:SELECT framedRoute, framedIpAddress FROM staticIps WHERE username = \"%{User-Name}\"" < 0) {
reject # need static ip
}Operators in the map sections work as they do in an update {} block, so if you want the result of multiple rows you'd use += instead.
In any case, for this to work we'd need the names of the columns, so one of these https://github.com/FreeRADIUS/freeradius-server/commit/25ecad94f749d783602d3775b6f9c72382ebc65a
Has to be defined for every driver.
jpereira
spaetow
viniciussotti
Hi,
I have started the thread called "multiple fields from rlm_mysql" on the FreeRadius users list. And following the suggestion of Alan DeKok here we are.
My idea it's create a solution to be able to do something like:
And with the result saved in query_arr be able to transform in an array or do the concept of "eval" then will set the AVP based on the name of column-table. what do you think about the idea? if possible i would like to get more information about the ideas that was discussed between @alandekok and @arr2036 to thus be able to continue.
I believe that have many ways (possible solutions) to be done.