Michael Bryant wrote:
authorize {
   update request {
     Tmp-String=0 = "%{sql:select ...}"
   }
   sql
}

Unfortunately that's no use, as I understand it, redundant blocks aren't
supported in xlat?

Ah, so your "sql" module is actually:

instantiate {
  sql {
    sql1
    sql2
  }
}

Your original message didn't say that.

You can't do this entirely in FreeRadius' built-in logic I believe. You could write a stored procedure to do the logic on the server-side (if your database supports it) or run the logic inside a perl/python script.

What are you trying to accomplish? Perhaps there are alternatives.

In some respects the sql module is a bit limited; it would be nice for some use-cased if FR could pull back rowsets (i.e. >1 row, >1 column) into some kind of unlang variable which you could then loop over, but then unlang would be more a... lang ;o)
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to