(RADIATOR) question

[Mike McCauley]

Hello Chris,

On Fri, 18 Jul 2003 09:56 pm, Chris wrote:
> > You could use an AcctSQLStatement that sets thir expiry date if it is
> > currently NULL. The the first successful session start will set their
>
> expiry
>
> > date to, say the current date + 30 days (or whatever your policy is).
>
> thanks mike should I be safe then if  I add this to my AcctSQLStatement to
> update my VALIDFROM table:
>
> AcctSQLStatement update RADUSERS set VALIDFROM=now where VALIDFROM='0',
> TIMELEFT=TIMELEFT-0%{Acct-Session-Time} etc.

It might be more common to let the starting value of VALIDFROM be NULL (which 
means Radiator would ignore it first time around), and then set it with:

AcctSQLStatement update RADUSERS set VALIDFROM=now where VALIDFROM IS NULL and 
...

>
> thanks,
> Chris
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.501 / Virus Database: 299 - Release Date: 7/14/2003
>
> This Email is protected by RAV AntiVirus Security Software for SuSE Linux
> eMail Server

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

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 etc on Unix, Windows, MacOS etc.

===
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.