Update control with redundant sql query
lscrlstld
lscrlstld at gmail.com
Thu Jun 28 19:09:48 CEST 2012
Hi,
I use the policy configs to provide redundant and load-balance to update
the pool-name.
It´s work fine! But I have same questions...
- Is it the correct way to do it? Is it the better way, considering a
performance in high usage?
- Why the virtual module created in the policy and control update always
return "notfound" ?
+- entering group authorize {...}
++- entering policy update_ctlr_PN {...}
+++- entering redundant-load-balance group redundant-load-balance {...}
++++- entering policy update01_Pool-Name {...}
...
expand: select poolname from radpoolname where
nasipaddress="%{NAS-IP-Address}" -select poolname from radpoolname where
nasipaddress="X.X.X.X"
rlm_sql (sql01): Reserving sql socket id: 4
sql_xlat finished
rlm_sql (sql01): Released sql socket id: 4
expand: %{sql01:select poolname from radpoolname where
nasipaddress="%{NAS-IP-Address}"} -pool01
+++++[control] returns notfound
++++- policy update_ctlr_PN1 returns notfound
+++- redundant-load-balance group redundant-load-balance returns notfound
++- policy update_ctlr_PN returns notfound
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
}
}
}
Server conf:
...
authorize {
update_ctlr_PN
pap
chap
sql01
}
...
Thank you.
More information about the Freeradius-Users
mailing list