Re: (RADIATOR) AddToReply & SQL

2000-01-17 Thread Hugh Irvine


Hello Lufti -

On Mon, 17 Jan 2000, Lutfi YUNUSOGLU wrote:
> 
> I want to add to all reply's " Ascend-Maximum-Time= [ sessiontime value from
> table subscribers] " attribute.
> I want to create some accounts with limited time like 30 hours in one month
> and after 30 hours it will disconnect. 
> Then after every disconnect I'll update Total-Session-time value like
> total-session-time=total-session-time - last-session-time. In next login I
> want to use the new total-session-time from last subtraction.
> Can I do it with AddToReply or is there any other way to do it.
> 

If you use AuthBy SQL, you can do this with an AuthSelect statement and the
corresponding AuthColumnDef:


DBSource 
DBAuth 
DBUsername 
AuthSelect your SQL statement

AuthColumnDef total-session-time, Ascend-Maximum-Time, reply



Have a look at section 6.24 in the Radiator 2.14.1 reference manual, and the
various examples in the radius.cfg file and the goodies directory in the
distribution.

hth

Hugh

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody

===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.



(RADIATOR) AddToReply & SQL

2000-01-17 Thread Lutfi YUNUSOGLU
Title: AddToReply & SQL





Hi,


I want to add to all reply's " Ascend-Maximum-Time= [ sessiontime value from table subscribers] " attribute.
I want to create some accounts with limited time like 30 hours in one month and after 30 hours it will disconnect. 
Then after every disconnect I'll update Total-Session-time value like total-session-time=total-session-time - last-session-time. In next login I want to use the new total-session-time from last subtraction.

Can I do it with AddToReply or is there any other way to do it.



Regards
Lutfi