maintenance of radacct table

[bbnlradius]

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