how get current TRAFFIC (ACCT) ?

[Seferovic Edvin]

Well you have set up your pppoe-server to send the accounting information
only at the end of the session. If connection is "lost", you will have the
accounting data in your database with AcctTerminateCause something like
"terminated by server". 

The session you have sent me is just an open session.

As I said - you can set the Acct-Interim-Interval attribute so that your
server sends the accouting packets every few minutes for example.

-----Original Message-----
From: Andreas Sokov [mailto:andre.s at j8.com.ru] 
Sent: Donnerstag, 15. Dezember 2005 12:42
To: freeradius-users at lists.freeradius.org
Cc: edvin.seferovic at kolp.at
Subject: Re[2]: how get current TRAFFIC (ACCT) ?


 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