Clean up old logs

Server
#1

Hi uroni
i just want to clean up old logging. when i open up the webserver:55414 and then logs i see old (errors) from jan 2014.
can you please tell me hou to cleanup old logging ???

many many thanks
Micheal

#2

Currently only through hackery with the sqlite3 shell.

# sqlite3 backup_server.db
DELETE FROM logs;
.quit

#3

Sorry for bringing this old thread back to life, but I think this is genuinely useful!

However, just executing the command above will leave you with a broken logging function, as logs are incorrectly referenced (so you might see logs for old clients, or different clients than the log is actually aimed at).

To really clean the logs, I had to do this:

# sqlite3 backup_server.db
DELETE FROM logs;
DELETE FROM log_data;
.quit

This is with urbackup 2.4.13 running in docker. I am by no means a database expert, but I have not seen anything break so far.