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