Add this to your Cisco config
aaa accounting update periodic 5
And that should send updates every 5 minutes. Also make sure you enable
gigawords or else any usage over 4GB will reset to 0 and wont count
properly. We had to make a small modification to FreeRADIUS sql.conf (as we
use MySQL for all auth and acct) to count and store gigawords which were;
accounting_update_query = "UPDATE radacct SET AcctInputOctets =
'%{Acct-Input-Octets}', AcctInputGigawords = '%{Acct-Input-Gigawords}',
AcctOutputOctets = '%{Acct-Output-Octets}', AcctOutputGigawords
='%{Acct-Output-Gigawords}', FramedIPAddress = '%{Framed-IP-Address}' WHERE
AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND
NASIPAddress= '%{NAS-IP-Address}' AND NASIPAddress= '%{NAS-IP-Address}' AND
AcctStopTime = '0000-00-00 00:00:00'"
accounting_stop_query = "UPDATE ${acct_table2} SET AcctStopTime = '%S',
AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets =
'%{Acct-Input-Octets}', AcctInputGigawords = '%{Acct-Input-Gigawords}',
AcctOutputOctets = '%{Acct-Output-Octets}', AcctOutputGigawords =
'%{Acct-Output-Gigawords}', AcctTerminateCause = '%{Acct-Terminate-Cause}',
AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}'
WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}'
AND NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime =
0"
And we added the AcctInputGigaWords and AcctOutputGigawords to the radacct
table.
Hope that helps a bit... it works for us, so yeah :)
Nikolas Geyer.
----- Original Message -----
From: "Russell Brenner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 28, 2004 12:04 PM
Subject: Freeradius + Cisco LNS + Accounting data
> Hi,
>
> After checking out some the accounting data we've collected for our ADSL
> users we obviously aren't getting usage data until we receieve a stop
record
> for the customer (ie sometimes upto a week later) when the customers
> disconnects.
>
> This isn't really that useful for data reporting to customers as they
might
> have exceeded their data usage but it won't display because they haven't
> disconnected...
>
> How can we combat this? I imagine other ISP's are collecting daily usage
> data but... yeah its perplexed me :)
>
> I was considering setting a Session-Limit variable for 24 hours, but I
don't
> see this as being ideal with a ADSL 'always on' type service...
>
> It'd be nice to have up to the minute (or as close to) stats.... at the
very
> least have a daily update...
>
> Russell.
>
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
