[freeside] Automatic Suspension of Packages

[ivan]

Use RADIUS groups or bin/fs-radius-add-{check,reply}

On Fri, Apr 08, 2005 at 12:13:48PM +0530, Shivkumar wrote:
> hi,
> I have a freeside server up and running with the following config:
> debian sarge/testing kernel 2.4.27-1
> freeside v1.5.0 pre6
> HTML::Mason
> apache-ssl-1.3.33+mod_perl-1.29
> postgresql-7.4.7-2
> 
> I was wondering if there was some way for packages like say
> introductory -10 hr or 3 day free trial packages, to become suspended
> automatically after that period based on the RADIUS accounting
> information.
> ~ For example, I create a package with 1 hr usage and provision it to a
> customer.
> I then log in as the customer on another machine ( through my hotspot
> controller). I see that the user could stay logged on well past the 1
> hr limit. and in fact logout and login subsequently after  the 1 hour
> period is over.
> I know that there is a way to do it in freeradius wherein an SQL query
> is run checking for SUM(Max-All-Sessions) where Max-All-Sessions is a
> value defined in the radcheck table. The RADIUS sends an Access-Reject
> for requests that exceed this value. Currently, I am forced to add
> this value manually as soon as each user is created if I want to
> enforce this because the Freeside Insert query just inserts the
> UserName and Password value into the database.
> 
> Bottom-Line is: Can the Insert query be changed in Freeside without
> palying with the source code?
> 
> -- 
> Regards,
> 
> Shivkumar
> 
> 

-- 
_ivan