Re: Accounting Issue

[Chris Parker]

At 02:32 PM 10/17/2002 +1000, Scott Harris wrote:

Hi guys,

Having an accounting issue ... why does the bandwidth not get detected
everytime ... it is not being captured in sql or detailed?

Version - Freeradius 0.7.1

Radius.conf Section -
<snip>
accounting {
        acct_unique
        detail
        sql
        radutmp
}
<snip>

Sql.conf Section -
<snip>
accounting_update_query = "UPDATE ${acct_table1} SET FramedIPAddress =
'%{Framed-IP-Address}', AcctInputOctets = '%{Acct-Input-Octets}',
AcctOutputOctets = '%{Acct-Output-Packets}' WHERE AcctSessionId =
'%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress=
'%{NAS-IP-Address}' AND AcctStopTime = 1"
<snip>

Sample of report -
<snip>
Radius Log Report for: scott
Date       Login    Logout    Ontime  Port BandWt-In/Out   Total
----------------------------------------------------------------------------
-
07/10/2002 20:48:34 20:54:31   5m57s  A11  0.0K/0.0K        0h05m
07/10/2002 20:59:14 21:07:24   8m10s  A11  0.0K/0.0K        0h14m
08/10/2002 12:07:32 12:15:20   7m48s  A11  111.2K/1.4M      0h21m
09/10/2002 13:12:39 13:19:15   6m36s  A12  7.1K/1.7K        0h28m
16/10/2002 21:20:53 02:17:40 296m47s  A11  0.0K/0.0K        5h25m
17/10/2002 06:40:48 07:29:38  48m50s  A11  0.0K/0.0K        6h14m
------------------------------------------------------------------------
<snip>

I changed my account config in radiusd.conf and added acct_unique. I also
changed the AcctStopTime from 0 to 1 in my attempts to get things working
well.

Any suggestions would be appreciated ...

Check the 'detail' files to ensure that the attributes were sent
properly by the NAS. If they are being sent properly, then you'll want
to debug the SQL functionality, to examine what SQL statements are being
executed by the Server and whether they are being properly completed by
the server.

Also note that Accouting_Update is only for interim accounting packets,
it does not affect Start or Stop packets and the queries executed when
those accounting packets are received.

-Chris
--
\\\|||/// \ StarNet Inc. \ Chris Parker
\ ~ ~ / \ WX *is* Wireless! \ Director, Engineering
| @ @ | \ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\------------------------------------------------------
\ Wholesale Internet Services - http://www.megapop.net



- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html