Community discussions

MikroTik App
 
joserudi
Frequent Visitor
Frequent Visitor
Topic Author
Posts: 72
Joined: Thu Nov 22, 2007 10:16 pm

Usermanager history clear 6.33 rc16

Wed Sep 30, 2015 7:47 am

Hi, I am testing the new version 6.33 RC16 to try to clean the historic session but I can not properly use the userman / history / clean command. 1000 users currently handle with radius on the same machine as the PPPoE server and each time it restarts take long to respond database. How we can streamline the process of restarting without radius timeout error? Thank you
 
User avatar
ruebenmaster
newbie
Posts: 28
Joined: Fri Mar 01, 2013 6:37 pm
Location: Mannheim, Germany

Re: Usermanager history clear 6.33 rc16

Wed Sep 30, 2015 8:32 am

Hallo joserudi,
i'm not unterstanding. The router is the radius server? Or do you using an external radius server? Do you have an export file for better understanding? We have change to external radius server, because of more than 200 user.

Greetings
Stephan, the ruebenmaster
 
joserudi
Frequent Visitor
Frequent Visitor
Topic Author
Posts: 72
Joined: Thu Nov 22, 2007 10:16 pm

Re: Usermanager history clear 6.33 rc16

Wed Sep 30, 2015 1:11 pm

Yes. The router its radius ser server too. My data base its more than 100 Megabytes. I need to clean sesión user database.
 
User avatar
ruebenmaster
newbie
Posts: 28
Joined: Fri Mar 01, 2013 6:37 pm
Location: Mannheim, Germany

Re: Usermanager history clear 6.33 rc16

Wed Sep 30, 2015 4:11 pm

Hallo,

i've tested the usermanager in my virtual area with MikroTik x86 6.32.2... no Problems with cleaning, but there are only 200 User. (I take them from the radius server...)

Do you have the user manager in a virtual machine too? try to give more RAM. Sorry, i'vo not more tips at the moment.

Greetings
Stephan, the ruebenmaster
 
joserudi
Frequent Visitor
Frequent Visitor
Topic Author
Posts: 72
Joined: Thu Nov 22, 2007 10:16 pm

Re: Usermanager history clear 6.33 rc16

Wed Sep 30, 2015 6:17 pm

Please tell me how you clean session logs because I only can remove 1 on 1 withs this option tool/user-manager/session/remove numbers. Thanks
 
User avatar
strods
MikroTik Support
MikroTik Support
Posts: 1616
Joined: Wed Jul 16, 2014 7:22 am
Location: Riga, Latvia

Re: Usermanager history clear 6.33 rc16

Fri Oct 02, 2015 7:58 am

joserudi - Instead of number use [find]. It will execute command on all entries in list;

History clear function does not work with database. If you do something in UM, then you can undo this function by using history. History could grow up to ~150MB in RAM memory. After reboot it still would be clear. Now you can clear this history and get rid of used RAM. For example, if you have a UM on mipsbe with ~100MB of RAM, then there is pretty good chance that after a while device will run out of memory.
 
joserudi
Frequent Visitor
Frequent Visitor
Topic Author
Posts: 72
Joined: Thu Nov 22, 2007 10:16 pm

Re: Usermanager history clear 6.33 rc16

Sun Oct 04, 2015 1:18 am

I only need clean count session. I have registered two years. I would like to use tool/user-man/session clean but I only can clean one number. Numbers 0-20000 dont work.
 
User avatar
mousa1983
Frequent Visitor
Frequent Visitor
Posts: 75
Joined: Mon Apr 21, 2014 2:36 pm
Location: ilam-iran

Re: Usermanager history clear 6.33 rc16

Sun Oct 04, 2015 5:52 pm

Hi
You can use this script
/tool user-manager session remove [/tool user-manager session find where customer ="****"]
instead of **** you must type your customer name.
 
joserudi
Frequent Visitor
Frequent Visitor
Topic Author
Posts: 72
Joined: Thu Nov 22, 2007 10:16 pm

Re: Usermanager history clear 6.33 rc16

Mon Oct 12, 2015 10:27 pm

Don´t work, I need to clear the counter of sessions and just let me clear in 1000 and 1000 there are 30,000 records
 
User avatar
Omarc
Trainer
Trainer
Posts: 2
Joined: Wed Feb 01, 2017 8:13 pm
Location: Santa Cruz de la Sierra, Bolivia
Contact:

Re: Usermanager history clear 6.33 rc16

Mon Feb 28, 2022 10:51 pm

Don´t work, I need to clear the counter of sessions and just let me clear in 1000 and 1000 there are 30,000 records
This will go like this in v7.1. hope it helps.
/user-manager/session> remove [/user-manager session find where active=no]

Regards

Who is online

Users browsing this forum: No registered users and 14 guests