Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cloudera Navigator Audit Database clean up?

Solved Go to solution

Cloudera Navigator Audit Database clean up?

Explorer

Is it okay to do some clean up on mysql database of Cloudera navigator Audit?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Cloudera Navigator Audit Database clean up?

Expert Contributor

@Mondi 

 

The property setting the retainment period can be found at: Cloudera Manager -> Cloudera Management Service -> Configuration -> and in the search field please type: "Navigator Audit Server Data Expiration Period"

After reducing this retention period and restarting the Nav Audit server role, the tables/data should be purged.

 If you still see old audit data remaining you can proceed with manual purging:
Connect to your database.
> show databases;
> use <nav_audit_database>;
> show tables;
> drop table <audit_event_table>;
You can also set audit filters for difffernt services to have a control on audit collection.

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cn_admcfg_audit_filters.html

 

Hope this helps,

Paras

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

View solution in original post

1 REPLY 1
Highlighted

Re: Cloudera Navigator Audit Database clean up?

Expert Contributor

@Mondi 

 

The property setting the retainment period can be found at: Cloudera Manager -> Cloudera Management Service -> Configuration -> and in the search field please type: "Navigator Audit Server Data Expiration Period"

After reducing this retention period and restarting the Nav Audit server role, the tables/data should be purged.

 If you still see old audit data remaining you can proceed with manual purging:
Connect to your database.
> show databases;
> use <nav_audit_database>;
> show tables;
> drop table <audit_event_table>;
You can also set audit filters for difffernt services to have a control on audit collection.

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cn_admcfg_audit_filters.html

 

Hope this helps,

Paras

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here