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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.