how get current TRAFFIC (ACCT) ?

[Andreas Sokov]

 Hi.

[ You wrote Thursday, December 15, 2005, 2:14:10 PM ]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
SE> Hi,

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

-)
i know what information about traffic collect in that table.
But please, look at this :

RadAcctId       AcctSessionId   AcctUniqueId        UserName  Realm    NASIPAddress     NASPortId  NASPortType  AcctStartTime  AcctStopTime            AcctSessionTime         AcctAuthentic           ConnectInfo_start       ConnectInfo_stop        AcctInputOctets         AcctOutputOctets        CalledStationId         CallingStationId        AcctTerminateCause      ServiceType             FramedProtocol          FramedIPAddress         AcctStartDelay          AcctStopDelay
19              43A154E9151B00  835535e0e65d3ace    test               213.159.102.146  0          Virtual      2005-12-15 14:35:05     0000-00-00 00:00:00     0       RADIUS                  0       0                               Framed-User     PPP     192.168.96.10   0       0
18              43A13CE87DBE00  73e57ea8afc72d3b    test               213.159.102.146  0          Virtual      2005-12-15 12:52:40     2005-12-15 14:10:12     4652    RADIUS                  6857793         7229167                         User-Request    Framed-User     PPP     192.168.96.10   0       0

look at id=19 into AcctStopTime and
while session OPENS! the value AcctInputOctets         AcctOutputOctets == 0 !!!

and if session will be open during 20 hourse - we can not know that current value of
AcctInputOctets         AcctOutputOctets ?!

What you think about it ?

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

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

SE> Regards,

SE> Edvin

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

SE> Hi, freeradius-users.

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

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

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

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

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

SE> HELP PLEASE.


 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

-- -------------------------------------
 Best Regards, Andreas
 Thursday, December 15, 2005 2:36:16 PM
 Web-Media L.t.d.
 +7 (901) 301-5811
 ICQ UIN 177624