New entry for Interim packet
tony at tonyspencer.co.uk
Thu Nov 20 20:15:03 CET 2008
I'd rather not disconnect 4,000 users in one go.
> -----Original Message-----
> From: freeradius-users-bounces+tony=tonyspencer.co.uk at lists.freeradius.org
> bounces+tony=tonyspencer.co.uk at lists.freeradius.org] On Behalf Of Marinko
> Sent: 20 November 2008 19:02
> To: FreeRadius users mailing list
> Subject: Re: New entry for Interim packet
> Create CRON script which starts 5-10 min after midnight (first day in
> the month) and disconnect all active users. Then you will have
> AcctStopTime information in your database and you can sum traffic from
> previous month...
> Tony Spencer wrote:
> > Hello
> > Our setup is as follows:
> > Centos 5.2
> > FreeRADIUS Version 2.0.2
> > MySQL Version: 4.1.20
> > We are using FreeRadius for our ADSL users and its working fine.
> > Except when it comes to working out the usage stats for each user at
> > the end of each month.
> > Its easy to do with all sessions that started in the previous month
> > and have a Stop status.
> > But it's difficult when a session rolled over to the next month
> > because the status is Alive.
> > We're trying to find a why to make FreeRadius:
> > Enter a new entry into the Radacct table for a session for an Interim
> > update
> > Mark the previous session with a stop Status and update the OctetsIn
> > and OctetsOut for that session with the current value.
> > Set the new session OctetsIn and OctetsOut at zero until the next
> > update and then it starts from the beginning again.
> > However we can't find a way of making FreeRadius:
> > Run 2 sql statements in the same update.
> > Set the new session counter to zero and not roll over the next updates
> > Octets.
> > We have found the following site:
> > http://www.netexpertise.eu/en/freeradius/daily-accounting.html with a
> > way of doing this within MySQL with procedures, but apparently this
> > only works with MySQL 5.
> > Having installed MySQL 5 on a test server and importing our Radius
> > database we tried running the first procedure but get an error:
> > ERROR 1064 (42000): You have an error in your SQL syntax; check the
> > manual that corresponds to your MySQL server version for the right
> > syntax to use near 'DECLARE COUNTER_LIMIT BIGINT(12)' at line 1
> > mysql> SET COUNTER_LIMIT = POW(2,32);
> > ERROR 1193 (HY000): Unknown system variable 'COUNTER_LIMIT
> > Has anyone any ideas on how to do what we require or has anyone had
> > any luck with the instructions on the URL?
> > Thanks in advance.
> > Tony
> > ------------------------------------------------------------------------
> > -
> > List info/subscribe/unsubscribe? See
> List info/subscribe/unsubscribe? See
More information about the Freeradius-Users