how get current TRAFFIC (ACCT) ?

[Seferovic Edvin]

Hi,

for traffic information - look at the RADACCT table in your mysql database
called radius. A simple sql query could be -

SELECT SUM(AcctOutputOctets) as download, SUM(AcctInputOctets) as upload
GROUP BY Username ORDER BY Username ASC;

This should give you a list of your users and their upload and download
traffic ( list is sorted ascending by usernames ).

Regards,

Edvin

-----Original Message-----
From: freeradius-users-bounces at lists.freeradius.org
[mailto:freeradius-users-bounces at lists.freeradius.org] On Behalf Of Andreas
Sokov
Sent: Donnerstag, 15. Dezember 2005 11:33
To: freeradius-users at lists.freeradius.org
Subject: how get current TRAFFIC (ACCT) ?
Importance: High

Hi, freeradius-users.

Linux Debian, # uname -a
Linux g48 2.6.14.3-1 #4 Sun Dec 11 05:57:57 MSK 2005 i686 GNU/Linux

#freeradius -v
freeradius: FreeRADIUS Version 1.0.5, for host , built on Oct 16 2005 at
11:56:56

# mysql -V
mysql  Ver 14.12 Distrib 5.0.13-rc, for pc-linux-gnu (i486) using readline
5.0

TELL ME PLEASE : HOW I CAN GET CURRENT TRAFFIC INFORMATION ?
I need to kno how much traffic user eat before it close your session.

Do Know anybody ?
I try radwho, radlast - but they show all but acct information
Try radacct - but it is not show anything info, just run and no information
...

HELP PLEASE.


-- 
 Best Regards, Andreas                          
 Thursday, December 15, 2005 1:29:42 PM

 "Do not hesitate to ask me"
 ICQ UIN 177624
 http://ServersLease.net - Offshore Dedicated Servers, Offshore Collocation
 http://HOST-LUX.RU      - Offshore Virtual Hosting, Web Hosting, as low as
5$ per 1Gb HDD/month
 http://Reg-Master.net   - Register`s Master of Domains
 http://Web-Media.Ru     - Web Design studio.

 http://VEHICLE.RU       - автомобили на заказ из США

- 
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html