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@lists.freeradius.org SE> [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Andreas SE> Sokov SE> Sent: Donnerstag, 15. Dezember 2005 11:33 SE> To: freeradius-users@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
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@j8.com.ru] Sent: Donnerstag, 15. Dezember 2005 12:42 To: freeradius-users@lists.freeradius.org Cc: edvin.seferovic@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@lists.freeradius.org SE> [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Andreas SE> Sokov SE> Sent: Donnerstag, 15. Dezember 2005 11:33 SE> To: freeradius-users@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
participants (2)
-
Andreas Sokov -
Seferovic Edvin