maintenance of radacct table

[khouzam yaghi]

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