I have a Mikrotik CCR1009-7G-1C-1S+PC router acting as a RADIUS server as well with help of user manager package.
Today when I wanted to upgrade to the latest RouterOS release I noticed there is no enough free space to do so. I can I free up some space?
I noticed user-manager eats up almost all the disk space while there is no too many users in my network: 81 registered only as it is my home network.
I noticed that there are so many sessions: 679289
I read that in some cases sessions can get stuck and needs to be cleaned out manually. While I don't understand why manual cleanup would be needed in an industrial grade device, I tried to do so as well as attached a UPS to my router.
If I try to remove the sessions, router thinking a lot then after a while my command gets interrupted:
Here are the file sizes what I think is unjustified in this network size:
[halacs@router] > /tool user-manager session remove numbers: 0-10000 Script Error: action cancelled
And just because of the the package versions:
# NAME TYPE SIZE CREATION-TIME 7 user-manager directory sep/23/2020 13:08:23 8 user-manager/sqldb file 130.1MiB sep/23/2020 13:08:21 10 user-manager/logsqldb file 6.0KiB sep/05/2020 07:57:48 11 user-manager/sqldb-journal file 14.6KiB sep/23/2020 13:08:23
Does anyone have an idea how to compress sqldb to free up some space to upgrade RouterOS?
[halacs@router] > /system package print Flags: X - disabled # NAME VERSION SCHEDULED 0 ntp 6.47.3 1 ups 6.47.3 2 routeros-tile 6.47.3 3 system 6.47.3 4 ipv6 6.47.3 5 wireless 6.47.3 6 hotspot 6.47.3 7 mpls 6.47.3 8 routing 6.47.3 9 ppp 6.47.3 10 dhcp 6.47.3 11 security 6.47.3 12 advanced-tools 6.47.3 13 user-manager 6.47.3
Thanks & br,