About Deleting Audit_db Files

Please post here if you have problems in using Wing FTP Server.
Post Reply
kaneko
Posts: 5
Joined: Fri Mar 08, 2024 3:23 am

About Deleting Audit_db Files

Post 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?
FTP
Site Admin
Posts: 2094
Joined: Tue Sep 29, 2009 6:09 am

Re: About Deleting Audit_db Files

Post by FTP »

I recommend you stop the WingFTP service first, and then delete Audit_db file, then start the WingFTP service again.
kaneko
Posts: 5
Joined: Fri Mar 08, 2024 3:23 am

Re: About Deleting Audit_db Files

Post 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?
FTP
Site Admin
Posts: 2094
Joined: Tue Sep 29, 2009 6:09 am

Re: About Deleting Audit_db Files

Post 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")
kaneko
Posts: 5
Joined: Fri Mar 08, 2024 3:23 am

Re: About Deleting Audit_db Files

Post 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.
Post Reply