Re: (RADIATOR) time-based authentication

[Jos� Borges Ferreira]

Ayotunde Itayemi wrote:

Hi Hugh, Hi all,
 
Please I need to implement a configuration that involves the following:
 
1. pre-paid service users (sayd a payment for 100hours for example)
2. regular dial-in users with no time limitatation
 
What would be the best approach to this?
 
Two subscriber tables and a cascaded authby scheme?
 
I have taken a look at the pre-paid exampl in the goodies directory
but that only fits part of my requirements.
 
2. Is there a way to get accouting data back to optigold ISP for the
preparation/generation of billing invoices?
 
I intend to integrate optigoldISP and radiator tightly in this 
installation.
My session records and accouting records makes use of an Oracle DB BTW.
 
Thanks.
 
Regards,
Tunde I.
 
 
 
I'm not sure if the Session-Timeout = 0 means ilimited access. Bute if 
so you  can  try the following :

(Assuming MySQL)

create table SUBSCRIBERS (
      USERNAME        char(50) NOT NULL,
      PASSWORD        char(50),      
      TIMELEFT        int,            
       ISPREPAID        int           

);
and the on AuthBy clause
AuthSelect select PASSWORD, TIMELEFT*ISPREPAID from SUBSCRIBERS where 
USERNAME=%0 and (TIMELEFT > 0 or ISPREPAID=0)

Use ISPREPAID=1 for  prepaid custumers and  ISPREPAID=0 for ilimited users.

Jos� Borges Ferreira





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