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:
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') ")