How can I manually reset all users accounting data back to 0 instead of using (Check FreeRADIUS Custom Rd-Reset-Type-Data := daily) in Profile Components?
Basically want to reset all user accounting data usage every month but I prefer to do it manually.
Thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Please can someone help me, I want to clear all users data history safely?
I've used these commands in previous radiusdesk terminal to clear users history, but it seemed that the vm file keeps increasing even when all history is cleared.
Commands:
mysql -u root rd
ENTER
delete from radacct;
ENTER
quit;
ENTER
logout
ENTER
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi
Using Radiusdesk-2016-4-0.ova
How can I manually reset all users accounting data back to 0 instead of using (Check FreeRADIUS Custom Rd-Reset-Type-Data := daily) in Profile Components?
Basically want to reset all user accounting data usage every month but I prefer to do it manually.
Thanks.
Please can someone help me, I want to clear all users data history safely?
I've used these commands in previous radiusdesk terminal to clear users history, but it seemed that the vm file keeps increasing even when all history is cleared.
Commands:
mysql -u root rd
ENTER
delete from radacct;
ENTER
quit;
ENTER
logout
ENTER
Take a look here: https://sourceforge.net/p/radiusdesk/discussion/help/thread/2f29f134/?limit=25#8da5
I'm pretty sure that in the discussion was a howto for this via the MySQL but Ivcan't find It.
Have a look here as well. http://www.radiusdesk.com/old_wiki/technical_discussions/user_stats_fix It's a page about fixing the user's usage stats but It can be helpful to understand what's kept where in the tables. It can be used as a guiding point.