multiple columns in rlm_sql
petr.linke at seznam.cz
petr.linke at seznam.cz
Fri Apr 13 17:40:43 CEST 2018
Hi,
I have question, is it possible in virtual server config do something like
this?
update control {
&value1,&value2, ... ,&valueN="%{sql:SELECT value1,value2, ... ,valueN
from some_table where ...}"
}
I know, that is no problem to do more sql queries like:
update control {
&value1="%{sql:SELECT value1,from some_table where ...}"
&value2="%{sql:SELECT value2,from some_table where ...}"
...
&valueN="%{sql:SELECT valueN,from some_table where ...}"
}
but it is too expensive for performance, much better is to do with one sql
select.
I looked into rlm_sql.c, and the line #462 - "for (i = 0; i < fields; i++)
names[i] = field_info[i].name;" looks as multiple column separation.
I tried find some info in the freerarius WiKi and in the documentation, but
without success.
Thank you for any idea, Petr Linke
More information about the Freeradius-Users
mailing list