I want to use the result from a sql query in something like this: ... switch "%{sqlnastype:SELECT nas.type FROM `nas` WHERE nas.nasname ='%{NAS-IP-Address}'}" { case "Cisco" { ... It works, and it is a great feature. The point is, it seems to work only if there is an authorize_check_query and a authorize_reply_query in the sql module. So I have to setup an authorize_reply_query with UserName,Attr Nam, Attr Value, Op, although I am only interested in the answer to the query above, which might be Cisco, Entrasys or something like that. Is there a way to avoid such an authorize_reply_query or even the authorize_check_query? Norbert Wegener
Norbert Wegener wrote:
The point is, it seems to work only if there is an authorize_check_query and a authorize_reply_query in the sql module. So I have to setup an authorize_reply_query with UserName,Attr Nam, Attr Value, Op, although I am only interested in the answer to the query above, which might be Cisco, Entrasys or something like that.
Is there a way to avoid such an authorize_reply_query or even the authorize_check_query?
Code changes in rlm_sql. Maybe for 2.1, or 3.x, we can re-factor the code into "connect to db", and separately, "do something with that data". Alan DeKok.
participants (2)
-
Alan DeKok -
Norbert Wegener