Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Cloudera Navigator Audit Database clean up?

avatar
Rising Star

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

1 ACCEPTED SOLUTION

avatar
Master Collaborator

@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

avatar
Master Collaborator

@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.