The SQL-String is OK! I get the result from sum(acctoctets). This seems good.
But a user can not download 4344.00 MBs in 7,44 Minutes using a 56k Modem! This was my question! regards Florian ----- Original Message ----- From: "Kostas Kalevras" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 20, 2004 10:08 PM Subject: Re: wrong 'statistic' in dialupadmin interface > On Mon, 20 Sep 2004 [EMAIL PROTECTED] wrote: > > > > > Hallo! > > > > The statistic page works but does not show correct values: > > > > This user was two times connected with 56k-Modem for 7,44 minutes . > > He was just logged in without any transfers of data. > > In this time he had 4344.00 MBs (???) download. > > This must be wrong!!! Any idea? > > > > > > 2004-09-16 2 100% 00:07:44 100% 4344.00 MBs 100% > > > > Connections 2 > > Online time 7 minutes 44 seconds > > Upload 3092.94 MBs > > Download 4344.00 MBs > > Average Time 3 minutes 52 seconds > > Average Upload 1546.47 MBs > > Average Download 2172.00 MBs > > So enable sql_debug to see the sql queries run and the corresponding results. > > > > > > > > > Thanks Florian > > > > > > > > > > > > PS maybe bits and octets? > > -- > > [site=fn&prod=chetools&kat=rub&tbl=webmail&ppos=1&TransactionID=109570442357 879&rgtg=256] - List > > info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > > > -- > Kostas Kalevras Network Operations Center > [EMAIL PROTECTED] National Technical University of Athens, Greece > Work Phone: +30 210 7721861 > 'Go back to the shadow' Gandalf > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html