(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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.