RE: Redundant SQL

[Garber, Neal]

> Source code patched.

Thanks..

> The redundant sections work just fine
> for normal queries to radcheck && radreply.  If you're doing %{...},
> then the redundant sections don't apply.

Ah, now I understand.  I abandoned redundant and used if/elsif instead in my 
dynamic_client virtual server:

  if ("%{sqlaugs: SELECT ...}'}") {
     update control {
        FreeRADIUS-Client-IP-Address = "%{Packet-Src-IP-Address}"
        FreeRADIUS-Client-Shortname = "%{sqlaugs: SELECT ...}'}"
        FreeRADIUS-Client-Secret = "%{sqlaugs: SELECT ...}'}"
        FreeRADIUS-Client-NAS-Type = "%{sqlaugs: SELECT ...}'}"
     }
  }
  elsif ("%{sqlroch: SELECT ...}'}") {
     update control {
        FreeRADIUS-Client-IP-Address = "%{Packet-Src-IP-Address}"
        FreeRADIUS-Client-Shortname = "%{sqlroch: SELECT ...}'}"
        FreeRADIUS-Client-Secret = "%{sqlroch: SELECT ...}'}"
        FreeRADIUS-Client-NAS-Type = "%{sqlroch: SELECT ...}'}"
     }
  }

This works great.  Thanks again for your help Alan..

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html