maintenance of radacct table

[Jonathan]

Hi Khouzam

might help many people to share these scripts?

On Sun, Mar 5, 2017 at 11:03 PM, khouzam yaghi <khouzam.yaghi at gmail.com>
wrote:

> In my case what i am doing is as follow:
>
> I am using triggers on insert and update of the radacct table to update
> another table with download quota and upload quota, so that i only check
> the data limit of a user on a separate table which contains only 1 record
> per user, also i am running a cronjob script which copy the radacct
> sessions which has an acctstoptime not null to another table and then
> delete them from the radacct table, so that the radacct table will always
> contain the online users.
>  i am not checking for data limit of a user on real time,so that the
> freeradius will only insert radacct sessions, and i am running a script
> every few minutes to get all users who exceeded there limit and make the
> action provided by the FUP rules and updating the radusergroup with the new
> speed.
>
> Its working perfectly without any problems!
>
> > On Mar 5, 2017, at 10:15 PM, bbnlradius <bbnlradius at bbnl.co.in> wrote:
> >
> > Again thanks in taking your precious time in helping me out.
> > Will talk to the dev team and see how they plan on going with the
> maintenance.
> >
> > An observation done and seeking help.
> > I see that every few mins 2 tables keep getting created every few mins.
> > rm_onlinecm1
> > rm_wlan1
> > These tables are getting created as myiasm engine, Could you please do
> let me know if you have come across these creations, if yes, can u please
> do let me know which file has this script so that i can change it to innodb.
> >
> > I see the following info in the mysql.conf file.
> >
> >    # If you want both stop and start records logged to the
> >    # same SQL table, leave this as is.  If you want them in
> >    # different tables, put the start table in acct_table1
> >    # and stop table in acct_table2
> >    acct_table1 = "radacct"
> >    acct_table2 = "radacct"-------------------------------> If i change
> this to another table name, will we face any issue, will it help in a
> better performance?
> >
> >    # Allow for storing data after authentication
> >    postauth_table = "radpostauth"-----------------------> I do not see
> any data in this table, are we missing anything, should anything be enabled
> to see the data.
> >
> >    authcheck_table = "radcheck"
> >    authreply_table = "radreply"-----------------------> I do not see
> any data in this table, are we missing anything, should anything be enabled
> to see the data.
> >
> >    groupcheck_table = "radgroupcheck"
> >    groupreply_table = "radgroupreply"
> >
> >    # Table to keep group info
> >    usergroup_table = "radusergroup"
> >
> >    # If set to 'yes' (default) we read the group tables
> >    # If set to 'no' the user MUST have Fall-Through = Yes in the
> radreply table
> >    # read_groups = yes
> >
> >    # Remove stale session if checkrad does not see a double login
> >    deletestalesessions = yes
> >
> >
> >
> >
> >
> >> On Monday 06 March 2017 01:14 AM, Alan DeKok wrote:
> >>> On Mar 5, 2017, at 2:22 PM, bbnlradius <bbnlradius at bbnl.co.in> wrote:
> >>> Thank you very much for helping.
> >>> I wanted to keep around 2 to 3 months data, hence the daily partition
> to drop the old data.
> >>> But we are not sure how the app is working here. what table does it
> refer.
> >>   All of the FreeRADIUS configuration is available in text files in the
> /etc/raddb directory.  The Wiki contains more documentation.  It's all
> public.
> >>
> >>> We are an isp here in Bangalore,India, have around 70k users with
> around 30k concurrent users logging in to the db.
> >>> We are using DMA Softlab software which takes care of the billing.
> >>> Since I am new to the radius and its app culture, I am not sure how it
> works, if I make any changes to the db, scared that it would mess up the
> app side and the customers billing scenario.
> >>   I suggested you add a table.  That won't break the RADIUS server.
> Changing the RADIUS configuration may be an issue, but that's what test
> systems are for.  Do the changes in a test system to see if they work.
> >>
> >>   And nothing beats *understanding* how the system works.  That takes
> time.  There's no short-cut here.
> >>
> >>> I see that the softlab software has a maintenance script which talks
> about creating temp tables called radacct1,rm_radacct1, they are
> summarising data,populating it and then updating the data in rm_users table.
> >>> But in this script the rm_radacct table does not even have any data to
> populate, I am worried to run the script on prod.
> >>   If you don't know what the script does, you shouldn't run it.
> >>
> >>> If by any chance any one of you have worked in this similar env,
> please do help me out as to how to get this resolved.
> >>   I gave specific technical suggestions for how to fix it.  The main
> one being you have to understand the system you're running, and what
> changes you're making.  We can't do that for you.
> >>
> >>   Alan DeKok.
> >>
> >>
> >> -
> >> List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html
> >
> > -
> > List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html
>