RE: freeradius bandwidth counter help

[Jamal Taweel]

Title: freeradius bandwidth counter help

I think it is possible. What do you want is to add another column to USERS table that hold the bandwidth in parallel with creating a script to included in sql.conf which aims to update the USERS table in order to decrement the previous with the used bandwidth. This script should be launched at receiving accounting stop packet.   Another way is to create a trigger on RADACCT table to be launched after update. This trigger will update the USERS table according to the request.   BR, Jamal   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Micky S Sent: Sunday, April 03, 2005 10:23 AM To: freeradius-users@lists.freeradius.org Subject: FW: freeradius bandwidth counter help   Does anybody think this is possible?   Any help much appreciated.   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Micky S Sent: 01 April 2005 12:32 To: freeradius-users@lists.freeradius.org Subject: freeradius bandwidth counter help   Hi all, Here is the scernario Authenicating users against a MySQL database, what i want to do is to have a counter to how much bandwidth the user has used, but to count DOWN from a set amount ie 100mb, if they use 3mb in one session then the next session they have 97mb etc... when the user has reached 0mb they are disconnected, any of the above, help would be well appreciated. ************************************************************************************* The contents of this email and any attachments are confidential. It is intended for the named recipient(s) only. If you have received this email in error please notify the system manager or the sender immediately and do not disclose the contents to any one or make copies. ************************************************************************************* PALTEL E-Safety System scanned this email and found NO viruses, vandals or malicious content. ************************************************************************************* Should you need any information or clarifications regarding this system, please do not hesitate to contact our team at the IP Dep. <[EMAIL PROTECTED]>. *************************************************************************************