On Wed, 28 Jul 2004, Nikolas Geyer wrote:
> 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.
You could use the expr module to calculate the correct value for
Acct-Input-Octets and Acct-Output-Octets. Probably something like:
%{expr: %{Acct-Input-Octets} + 1024*1024*1024*4*%{Acct-Input-Gigawords:-0}}
Hmm, maybe adding support for KB,MB,GB,TB in rlm_expr would be nice.
>
> 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
>
--
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
