Manually purging logs

General discussions here

Google Ads


Manually purging logs

Postby Callahan » Sat Aug 23, 2014 11:04 pm

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.
Callahan
New
 
Posts: 2
Joined: Sat Aug 23, 2014 10:53 pm

Urgent Question?

  • Pulling out your Hair?
  • Wasting Time and Money?
  • Deadline Approaching?

Re: Manually purging logs

Postby alorbach » Wed Sep 10, 2014 2:32 pm

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
alorbach
Site Admin
 
Posts: 1627
Joined: Thu Feb 13, 2003 11:55 am

Google Ads



Return to General

Who is online

Users browsing this forum: No registered users and 0 guests

cron