Execute SQL command after Authentication

[Arran Cudbard-Bell]

> 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