Hi, Is there any tool or script with help of which I can get to know how much data downloaded by all user in last 30 days. Please share the solution. Best regards, Fazal Ahmed Malik
Here is how I do it (this is for traffic in a particular month) SELECT username, truncate(sum(acctinputoctets + acctoutputoctets) / 1000000, 1) traffic FROM radacct WHERE month(acctstarttime) = 12 AND year(acctstarttime) = 2011 GROUP BY username This assumes you are using mysql for accounting. Mike On 25/02/12 17:49, Fazal Ahmed Malik wrote:
Hi,
Is there any tool or script with help of which I can get to know how much data downloaded by all user in last 30 days.
Please share the solution.
Best regards,
Fazal Ahmed Malik
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi, I have freeradius installed with mpd for pppoe dialin users. If some users power off computer without disconnecting than session hangs up. When I run radwho it shows user is connected where as practically user is disconnected. Is there any script or utility which can clean up radwho. 2ndly how can I disconnect connected users by force. Best regards, Fazal Ahmed Malik
On Tue, Mar 6, 2012 at 8:54 PM, Fazal Ahmed Malik <fam@solacetel.com> wrote:
Is there any script or utility which can clean up radwho.
radzap? Personally I just remove all reference to *radutmp in sites-available/* since I don't use it anyway.
2ndly how can I disconnect connected users by force.
Your NAS needs to support it, e.g. using some administrative interface (telnet, snmp) or CoA: http://wiki.freeradius.org/Disconnect-Messages -- Fajar
participants (3)
-
Fajar A. Nugraha -
Fazal Ahmed Malik -
Mike