audit_db file kept growing
Posted: Fri Apr 05, 2019 11:19 pm
Hi, we have a scheduled task set up to run weekly that cleans up the audit log ( following the instruction from this thread http://www.wftpserver.com/bbs/viewtopic.php?f=2&t=3075" rel="nofollow" rel="nofollow" rel="nofollow), however I did notice the audit_db file has never gotten smaller even right after the cleanup task runs. I wonder if this is normal. Also I'd like to know if we manually remove the file from the server in case of emergency situation, would it impair the ftp service ? (It's ok if it just impacts the audit report generation)
The audit db file size issue has been going on for long time since we started using WFTPServer many years ago. Now we are running version 5.1.2 and the concern of the file size is growing as the file becomes larger.
Following is our scheduled task definition:
The audit db file size issue has been going on for long time since we started using WFTPServer many years ago. Now we are running version 5.1.2 and the concern of the file size is growing as the file becomes larger.
Following is our scheduled task definition:
Code: Select all
--remove all the logs which are older than 30 days
c_DoSQL("delete from wftp_dblogs where f_time < datetime('now','localtime',’-30 day') ")