[RADIATOR] UpdateQuery details

[Heikki Vatiainen]

On 03/01/2013 12:25 PM, Vangelis Kyriakakis wrote:

>       Without defining UpdateQuery in SessionDatabase SQL, Radiator
> updates the contents of the RADONLINE database whenever an Alive packet
> is processed.

Hello Vangelis,

yes, it runs DeleteQuery followed by AddQuery by default if UpdateQuery
is not defined.

>       Manual says: "If UpdateQuery is defined as an empty string, then
> the query will not be executed. The default is the empty string."
>       If I define UpdateQuery will Radiator update the contents of the
> RADONLINE plus do the defined query, or just the second?

The second. If you define UpdateQuery, it will not do the default
action, run DeleteQuery followed by AddQuery, but will only run the
UpdateQuery you have defined.

You should then see something like '... Updating session for ...'
instead of what is otherwise logged.

Thanks,
Heikki

-- 
Heikki Vatiainen <hvn at open.com.au>

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS,
NetWare etc.