Re: Comparing Two Attributes

27 Jul 2012

      On a similar note, If I wanted to use the first result in the second update request, how can I go about that?

I've tried the following, but I get a blank value for SQL-Location-Id

update request {
       SQL-Location := "%{sql: SELECT xxx}"
 }

update request {
       SQL-Location-Id := "%{sql: SELECT * where XXX = '%{SQL-Location-Id}' }"
}

Is this possible?

On 26 Jul 2012, at 12:41, Jenny Blunt wrote:
...
How do I go about comparing two attributes from an update request?
I have the following in my default conf. file:
update request {
       SQL-Location := "%{sql: SELECT xxx}"
 }
update request {
       SQL-Location-Id := "%{sql: SELECT yyy }"
}
if (SQL-Location != SQL-Location-Id ) {
       reject
}
And my debug log shows:
Info: Failed parsing "SQL-Location-Id": Unknown value SQL-Location-Id for attribute SQL-Location
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html