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.
Sorry, that instruction is wrong, you can't delete audit records via WingFTP's Lua API, maybe you can consider to use SQLite client to manage that database file.
ok. We will use SQLLite to delete the records. Do we also need to run VACUUM command periodically to save space or WFTP Server will do it automatically?