[RADIATOR] AuthBy SQL results

[Heikki Vatiainen]

On 03/03/2011 04:49 PM, Vangelis Kyriakakis wrote:

>       I would like to know what happens when AuthSelect query in AuthBy 
> SQL returns two or more rows. Which one is used? The first or the last?
>       Example:
> 
> Username | Reply_item
> -----------------------------------
> user          |  reply1
> user          |  reply2
> 
> AuthSelect select Reply_item from table where Username='user'
> AuthColumnDef   0,GENERIC,reply
> 
> Which reply_item is going to be used?

Hello Vangelis,

the answer is reply1. Even if the select returns multiple rows, only the
first row is used. The rest of the rows are not saved or used later.

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.