Bug 984611 - RFE: delete/dump auditing information from the _log tables
Summary: RFE: delete/dump auditing information from the _log tables
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Usability
Version: 560
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Grant Gainey
QA Contact: Dimitar Yordanov
URL:
Whiteboard:
Depends On:
Blocks: sat560-blockers sat560-misc 993254
TreeView+ depends on / blocked
 
Reported: 2013-07-15 14:32 UTC by Tomas Lestach
Modified: 2013-10-01 21:26 UTC (History)
3 users (show)

Fixed In Version: spacewalk-utils2.0.2-11-sat
Doc Type: Release Note
Doc Text:
Database changes from predefined tables are logged by the Satellite auditing feature. In time, the logging data could potentially grow too big and take up excessive disk space in the Satellite database. A script has been created to enable Satellite to purge the audit-log tables on a user set date.
Clone Of:
: 993254 (view as bug list)
Environment:
Last Closed: 2013-10-01 21:26:13 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)

Description Tomas Lestach 2013-07-15 14:32:46 UTC 
Description of problem:
We've introduced the auditing feature within the Bug 871711. We log DB changes of predefined tables.

We need a mechanism, that would purge the DB logging data, so the logging information do not grow too much.
Comment 1 Grant Gainey 2013-08-05 17:57:32 UTC 
249fe86e5cb129bdb3e819de75e97f0b1c2eeced
Comment 2 Tomas Lestach 2013-08-12 08:55:01 UTC 
Grant, would you add a Spacewalk commit to the BZ as well?
Comment 3 Grant Gainey 2013-08-12 11:47:21 UTC 
SW commit 9868543d14407e287d65edcc5fa52a6141f004ab
Comment 7 Grant Gainey 2013-09-11 19:23:23 UTC 
Fixes:
SW abc0e9ab27087acc3f0960becf934f40c589ee67 spacewalk-utils-2.1.15-1
SAT cb45de398aa9915d4fcf91b8f548e23d0d41721a
Comment 14 Clifford Perry 2013-10-01 21:26:13 UTC 
Satellite 5.6 has been released. This bug was tracked under the release.  

This bug was either VERIFIED or RELEASE_PENDING (re-verified prior shortly
before release). 

Moving to CLOSED CURRENT_RELEASE. 

Text from Upgrade Erratum follows:

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHEA-2013-1395.html
Note You need to log in before you can comment on or make changes to this bug.