<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>RE: billing using radius</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hello,<BR>
Well, this can be very simple ... or very complicated ...<BR>
I'm doing traffic based accounting with freeradius and have been more then happy.<BR>
Our scenario is pretty complicated, it involves different pricing KB for day of week/time of day, users are able to purchase additional credit,etc.<BR>
to get you started:<BR>
<BR>
1. you can get user's traffic (acctinputoctets+acctoutputoctets) for a given time period and don't let the user login next time he/she wants to access the service. This will take care of not letting users over the quota to login...<BR>
<BR>
2. you can check your online users periodically send COA (Disconnect packet) if user's traffic is above your limit...<BR>
<BR>
3. you may have very long sessions(days, weeks or months) that cross bounderies for example: 10GB/week and have sessions longer then week. to solve this issue you need to have interim-update packets from your NAS, the nas will send you packets regularly... use this against your old data to calculate how much traffic was used. create a daily traffic table and update it with calculated amount. use counters based on the dailytraffic.<BR>
<BR>
depending on number of users you have you may need to partition your daily traffic table.<BR>
<BR>
this solution scales pretty good:<BR>
we have about 50,000 broadband users, 5 minute interim-update and we have hourly and daily traffic information tables. we are no where near our limits and freeradius/mysql is scaling very well. (10% load)<BR>
<BR>
You will be better off to do all this calculation in stored procedures instead of queries ...<BR>
Let me know if you need more info<BR>
<BR>
Cheers,<BR>
Parham<BR>
<BR>
------------------------------------------------------------------------------------------<BR>
<BR>
<BR>
Hi,<BR>
I use freeradius server for accounting of vpn users.I use monthly counter<BR>
to limit users but now I want if user's traffic is rather than specific<BR>
amount, I will be able to have billing for them and to disconnect some of<BR>
them. Is it possible to have billing with config in freeradius or a new<BR>
software is needed?<BR>
could radius disconnect users based on amount of traffic not counters?<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>