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