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

[Marcelo Santoro]

Alan… please… can you give me an example how to use:
> %sql{} stuff in a %{eval:} statement.

or

> if(%sql{}) statement

Tks so much friend.

Best Regards
Marcelo Santoro


> Em 12/01/2015, à(s) 13:27, A.L.M.Buxey at lboro.ac.uk escreveu:
> 
> 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
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html