(RADIATOR) AuthSelect

[Hugh Irvine]

Hello Lloyd -

>hello,
>can i do this in an AuthBy SQL??
>
>   Session-Timeout = Class   <<----------------- this is basically my question
>
>   AuthColumnDef 0,Encrypted-Password,check
>   AuthColumnDef 1,Filter-Id,reply
>   AuthColumnDef 2,Session-Timeout,reply
>   AuthColumnDef 3,Simultaneous-Use,check
>   AuthColumnDef 4,Class, reply
>
>AuthSelect select PASS_WORD, STATICADDRESS, TIMELEFT, MAXLOGINS,
>SESSIONLIMIT, FRAMED_NETMASK, FRAMED_FILTER_ID from RADUSERS where
>USERNAME='%n' and VALIDFROM < %t and VALIDTO > %t
>
>
>what i want to do in here is to select  a "SESSIONLIMIT" from a table in
>database and then get the result of it (SESSIONLIMIT) and assigned it as a
>value on Session-Timeout

The AuthColumnDef's must appear in the same order as the results of 
the AuthSelect. In your case above, it would look like this:

	AuthColumnDef 0, Encrypted-Password, check
	AuthColumnDef 1, Framed-IP-Address, reply
	AuthColumnDef 2, ....
	AuthColumnDef 3, Simultaneous-Use, check
	AuthColumnDef 4, Session-Timeout, reply
	AuthColumnDef 5, Framed-IP-Netmask, reply
	AuthColumnDef 6, Filter-Id, reply

I am not sure what the difference above is between TIMELEFT and 
SESSIONLIMIT, however that is up to you.


regards

Hugh



-- 

NB: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.