On Tue, 21 Sep 2004, Flo4000 wrote: > 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!
So check out the corresponding rows in the acounting table, any detail file you may have and try to find out why you get such numbers. There's no magic any of us can do to find out what's wrong. > > 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 > -- 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
