I have been running radiusdesk for sometime now and my database is quite large. I don'tneed all the historical data inside it. So how would I aproach deleting some of the radact entries and the old depleted users?
Thank you.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You can ssh into your server and run the following,
mysql rd -u root -p
DELETE FROM ap_stations WHERE created < '2018-03-01 00:00:00';
DELETE FROM node_stations WHERE created < '2018-03-01 00:00:00';
DELETE FROM radpostauth WHERE authdate < '2018-03-01 00:00:00';
DELETE FROM radacct WHERE acctstoptime < '2018-03-01 00:00:00';
DELETE FROM user_stats WHERE timestamp < '2018-03-01 00:00:00';
DELETE FROM mac_usages WHERE created < '2018-03-01 00:00:00';
DELETE FROM node_ibss_connections WHERE created < '2018-03-01 00:00:00';
just change the dates as required.
cheers,
Jimmy
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I have been running radiusdesk for sometime now and my database is quite large. I don'tneed all the historical data inside it. So how would I aproach deleting some of the radact entries and the old depleted users?
Thank you.
Hi Albert,
You can ssh into your server and run the following,
mysql rd -u root -p
DELETE FROM ap_stations WHERE created < '2018-03-01 00:00:00';
DELETE FROM node_stations WHERE created < '2018-03-01 00:00:00';
DELETE FROM radpostauth WHERE authdate < '2018-03-01 00:00:00';
DELETE FROM radacct WHERE acctstoptime < '2018-03-01 00:00:00';
DELETE FROM user_stats WHERE timestamp < '2018-03-01 00:00:00';
DELETE FROM mac_usages WHERE created < '2018-03-01 00:00:00';
DELETE FROM node_ibss_connections WHERE created < '2018-03-01 00:00:00';
just change the dates as required.
cheers,
Jimmy
hello,
Thanks for this. It helped. But radact table is still big. To many connections it seems :P