Page 1 of 1

About Deleting Audit_db Files

Posted: Fri Mar 08, 2024 3:25 am
by 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?

Re: About Deleting Audit_db Files

Posted: Fri Mar 08, 2024 4:11 am
by FTP
I recommend you stop the WingFTP service first, and then delete Audit_db file, then start the WingFTP service again.

Re: About Deleting Audit_db Files

Posted: Mon Mar 11, 2024 10:31 pm
by 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?

Re: About Deleting Audit_db Files

Posted: Tue Mar 12, 2024 2:12 am
by 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")

Re: About Deleting Audit_db Files

Posted: Fri Mar 15, 2024 2:06 am
by 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.