Execute SQL command after Authentication

[Marcelo Santoro]

WOW…. perfect Arran…. it worked like a charm …

Tks very much friend.

Happy New Year for all members !!!

Best Regards
Marcelo Santoro


> Em 02/01/2015, à(s) 17:15, Arran Cudbard-Bell <a.cudbardb at freeradius.org> escreveu:
> 
> 
>> On 2 Jan 2015, at 13:55, Marcelo Santoro <santoro.ice at gmail.com> wrote:
>> 
>> Hi Friends… 
>> 
>> i Would like to know, how to execute a SQL UPDATE command after my client Authenticate for example.
>> 
>> After client Authenticate… i want to execute a UPDATE command to my database sending the NAS where the client is connected… i know that this information exist in radacct, but i need this information in another table… 
>> 
>> My RadAcct table has more than 9 millions of registers… and i don`t want to make SELECTs in this table.
> 
> post-auth {
> 	update request {
> 		Tmp-Integer-0 := "%{sql:UPDATE foo bar}"
> 	}
> }
> 
> Arran Cudbard-Bell <a.cudbardb at freeradius.org>
> FreeRADIUS development team
> 
> FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html