Freeradius-Users post from at requires approval

A.L.M.Buxey at A.L.M.Buxey at
Mon Jan 12 16:27:59 CET 2015


> I am using the follow Post-Auth Command:
>         update request {
>                 Tmp-Integer-0 := "%{sql: UPDATE acessos_clientes set con_id = (select con_id from concentradores where con_ip = '%{Nas-IP-Address}'), ace_last_ip = '%{reply:Framed-IP-Address}' where ace_login = '%{SQL-User-Name}'}"
>         }

so the UPDATE returns no Tmp-Integer-0 isnt set to anything...thus fails....

so, a quick guess or can either wrap up the %sql{} stuff in a %{eval:} statement....or, you
can change the thing....are you even using the Tmp-Integer-0 string? why are you updating the request?
to be an 

if(%sql{}) statement instead....  the SQL will be can then look at the result and work on that.

running external script is extreme performance hit..running PERL not so..but still big hit


More information about the Freeradius-Users mailing list