About Deleting Audit_db Files

[kaneko]

The Audit_db file is bloated and I want to delete it.
Please tell me the following 3 points.

1. Is the procedure for deleting the Audit_db file as follows?
(1) Server → Setting → General Settings → Logs
Uncheck [Enable Audit & Report]
(2) Delete the Audit_db file.

2. Is there a restart of the FTP service to delete the Audit_db file?

3. Is the effect of deleting the Audit_db file just that "Audit & Report" is no longer available?

[FTP]

I recommend you stop the WingFTP service first, and then delete Audit_db file, then start the WingFTP service again.

[kaneko]

Thank you for your answer.

I don't want to stop the FTP service because I am using Wing FTP Server for a business system that is running 24 hours a day, 365 days a year.
Is it possible to delete the Audit_db file without stopping the FTP service?

[FTP]

OK, if you want to delete the audit_db file without stopping the WingFTP service, just execute the following Lua script under "Administrator > Console":

Code: Select all

c_SetGlobalOptionInt(GOPTION_AUDIT_ENABLE_INT, 0)
c_DisconnectSQLITE()
c_RemoveFileDir(c_GetAppPath().."/Log/audit_db")

[kaneko]

Thank you for your answer.

After running the command in the validation environment, I was able to verify that I could delete the Audit_db file without stopping the FTP service.
Try applying the command to a running server.
Thank you for your response.