Community discussions

MikroTik App
 
User avatar
winagain
Member Candidate
Member Candidate
Topic Author
Posts: 254
Joined: Sat Jul 15, 2006 10:18 pm
Location: Botswana
Contact:

Possibility of deleting user manager sessions older than 3 months

Wed Sep 12, 2018 3:49 pm

Hi,

I am having an issue with my User Manager sessions filling up my database and slowing down the system.

Doing anything in the user manager interface sets 100% CPU. I have been able to resolve by deleting old sessions and logs.

I am looking for a solution that would automate this process.

I would ideally like to set something up, presume it would be a script that would run on the 30th of every month, that will export sessions that are older than 90days to a file and upload to ftp server, then delete those sessions, leaving only the latest entries.

Is there anyone that can assist with a script capable of doing this.

Thanks in advance
 
User avatar
ADahi
Member Candidate
Member Candidate
Posts: 209
Joined: Thu Sep 21, 2017 7:16 pm
Location: Iraq, Ninavah
Contact:

Re: Possibility of deleting user manager sessions older than 3 months

Thu Sep 13, 2018 9:38 pm

better idea, when user get expired, export his sessions to file before remove his sessions
file name = USER_sessions _of_month

Who is online

Users browsing this forum: No registered users and 7 guests