Freeradius-Users post from santoro.ice at gmail.com requires approval

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


Hi,

> 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 value....so Tmp-Integer-0 isnt set to anything...thus fails....

so, a quick guess or 2....you 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 run...you 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

alan


More information about the Freeradius-Users mailing list