Page 1 of 1

Manually purging logs

PostPosted: Sat Aug 23, 2014 11:04 pm
by Callahan
Hi,

There is an error in the wiki support page for LogAnalyser here:
http://wiki.rsyslog.com/index.php/LogAn ... pplication

It states that to clear the log files via the command line on a Linux box, you should run:

Code: Select all
php maintenance.php cleardata 2 olderthan 3600


Other examples are listed. They are all incorrect and will result in an error. You should replace cleardata with cleandata

All that being said, I am still confused as to why when I run the following:

Code: Select all
php maintenance.php cleandata 1 olderthan 60


it still leaves logs in the DB that are older than 1 minute. Repeatedly running this command will now and then shave a few records off the end of the log file but it means that it's not clear what specifying a variable time-frame is actually doing. Can anyone confirm?

Issuing:
Code: Select all
php maintenance.php cleandata 1 all
will work and purge the DB of all records.

Any help gratefully received.

Re: Manually purging logs

PostPosted: Wed Sep 10, 2014 2:32 pm
by alorbach
It is possible that the Mysql has timeouts definied for DELETE statements that hit before the data is deleted. Check your MYSQL settings.

best regards,
Andre Lorbach