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 ...
Thanks,
Scott
Scott Harris
Cairns, Queensland, Australia
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
