update reply with multiple attributes from mysql table

Little Snooze littlesnooze at yahoo.fr
Fri Apr 21 15:09:27 CEST 2017


On Apr 21, 2017, at 9:00 AM, Little Snooze via Freeradius-Users 
<freeradius-users at lists.freeradius.org> wrote:
>> I'm running freeradius v3.0.4 (and can't run later version).
>    You can always run a later version.  The only reason not to is political.
exactly. not in repos.
>
>> I would like to update reply with all attributes concerning a specific user, from a mysql table.
>>
>> Is there a way to do that?
>>
>> I tried this solution, found in previous post, in this mailing list:
>    That would be the solution.
>
>> update control {
>>                         Tmp-String-0 := "%{sql:SELECT CONCAT(attribute,'#',op,'#',value) from specreply2lns where username = '%{User-Name}'}"
>>                 }
>>                 if ("%{explode:&control:Tmp-String-0 #}" > 0) {
>>                         foreach &control:Tmp-String-0 {
>>                                 if ("%{Foreach-Variable-0}" =~ /^([^=]+)=(.*)$/) {
>>                                         update reply {
>>                                                 "%{1}" "%{2}" "%{3}"
>>                                         }
>>                                 }
>>                         }
>>                 }
>>
>> pb is "explode" module doesn't available in earlier version of FR  3.0.7 :-(
>    Yup.
>
>> Is there a way to do that in unlang and FR V3.0.4?
>    Upgrade.
can't
>
>    Or, write a shell script to query SQL and return the columns as individual attributes.
>
>    Alan DeKok.
>
ok. thanks.


More information about the Freeradius-Users mailing list