We are using Steel-belted Radius Server v5.3.1 (from [url removed, login to view]). We configured the server to use our SQL Server as DB backend.
Now, the questions are:
1- How we can limit user accounts to some Rx/Tx rate. For example we want to define 2-3 profiles with different speed of download/upload and assing users to above profiles.
2- How we can limit download/upload volume. For example 20GB for a period of 30 days. The configuration must be able to accomulate sum of downloads/uploades for various sessions.
3- The configuration must be able to kill user session if time or download volume exceeded.
Note 1: All the above must be done using SQL queries. This means you have to send radius attributes from SQL tables to Radius Clients.
Note 2: Payment after solving above problems and full testing.
Only serious bidders please.
Attached files are our work for SQL Configuration.