On Fri, Jun 29, 2012 at 12:09 AM, lscrlstld <lscrls...@gmail.com> wrote: > Hi, > > I use the policy configs to provide redundant and load-balance to update > the pool-name. > > It´s work fine!
Does it? > The policy.conf > policy { > update_ctlr_PN1 { > update control { > Pool-Name := "%{sql01:select poolname from > radpoolname where nasipaddress=\"%{NAS-IP-Address}\"}" > } > } > update_ctlr_PN2 { > update control { > Pool-Name := "%{sql02:select poolname from > radpoolname where nasipaddress=\"%{NAS-IP-Address}\"}" > } > } > update_ctlr_PN { > redundant-load-balance { > update_ctlr_PN1 > update_ctlr_PN2 > } > } > } last time I check the "%{sql" block does NOT return an error if the sql server is dead. So your "load-balance" part definitely works, but I wouldn't be so sure about the "redundant" part. Try killing one of the sql servers and see what happens. IIRC I had to explicitly hack a query so it would return some value (e.g. NOTFOUND, or whatever) when it would usually return zero rows. That way, if the "%{sql" block returns an empty string, I know something is wrong and I need to ask the next server. That method works, but it doesn't provide load balance. -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html