Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
############################################
## audit entries with no logged in user aren't really all that useful.  There is point in time data still.  
## So removing these shouldn't be a big deal
## default is remove these that are 5 years old.
############################################

# number of days to retain db rows in grouper_audit_entry with no logged in user (loader, gsh, etc).  -1 is forever.  
# suggested is 365 or five years: 1825.  Default is -1
loader.retain.db.audit_entry_no_logged_in_user.days=31

############################################
## Some think its ok to remove all audit entries over 10 (or X) years, but will default this
## auditto entriesnever withsince noeven loggedat inlarge userinstitutions there aren't reallythat allmany that usefulrecords.
## These Thereare isaudits pointfor inthings timepeople datado still.on the UI or WS generally (as a different to records with no logged in user)
############################################
# number of days to retain db rows in grouper_audit_entry.  
##-1 Sois removingforever. these shouldn'tsuggested beis a-1 bigor dealten years: 3650
loader.retain.db.audit_entry.days=365

############################################
## After you delete an object in grouper, it is still in point in time.  So if you want to know who 
## was in a group a year ago, you need this info
## However, after some time it might be ok to let it go.  So the default is 5 years
############################################

# number of days to retain db rows for point in time deleted objects.  -1 is forever.  suggested is 365 or five years: 1825.  
# Default     is -1
loader.retain.db.point_in_time_deleted_objects.days=31

############################################
## defaultThis is removeoptional. these thatYou arecan 5just yearsautomatically old.obliterate folders *directly in a parent folder* 
## that are a certain age old  e.g. courses.
## so you could delete a term of courses 4 years old if you like.  Note, make sure the loader isn't going to recreate 
## or you will get churn
## Note this will also delete the point in time data as well.
############################################

# number of days after a subfolder (directly in a parent folder) is created that it will be         
############################################                                                                                        

# number of days to retain db rows in grouper_audit_entry with no logged in user (loader, gsh, etc).  -1 is forever.                
# suggested is 365 or five years: 1825.  Default is -1                                                                              
loader.retain.db.audit_entry_no_logged_in_user.days=31

############################################                                                                                        
## After you delete an object in grouper, it is still in point in time.  So if you want to know who                                 
## was in a group a year ago, you need this info                                                                                    
## However, after some time it might be ok to let it go.  So the default is 5 years                                                 
############################################                                                                                        

# number of days to retain db rows for point in time deleted objects.  -1 is forever.  suggested is 365 or five years: 1825.        
# Default is -1                                                                                                                     
loader.retain.db.point_in_time_deleted_objects.days=31

############################################                                                                                        
## This is optional.  You can just automatically obliterate folders *directly in a parent folder*                                   
## that are a certain age old  e.g. courses.                                                                                        
## so you could delete a term of courses 4 years old if you like.  Note, make sure the loader isn't going to recreate               
## or you will get churn                                                                                                            
## Note this will also delete the point in time data as well.                                                                       
############################################                                                                                        

# number of days after a subfolder (directly in a parent folder) is created that it will be obliterated (deleted)                   
# and point in time will be deleted too.                                                                                            
# "courses" or "anotherLabel" are variables you make up in these examples                                                           
loader.retain.db.folder.test.days=1825
loader.retain.db.folder.test.parentFolderName=users:penn
loader.retain.db.folder.test.deletePointInTime=true

Run the daemon with GSH

Code Block
gsh 0% grouperSession = GrouperSession.startRootSession();
edu.internet2.middleware.grouper.GrouperSession: 7f8474d2914a4cecac143be77768a34b,'GrouperSystem','application'
gsh 1% loaderRunOneJob("MAINTENANCE_cleanLogs");

loader ran successfully: Deleted 3872 records from grouper_loader_log older than 7 days old.  Deleted 2038 records from grouper_change_log_entry older than 14 days old. (1517867128940000)  Deleted 0 instrumentation records older than 30 days old. (1516484734612)  Configured to not delete records from audit_entry table with null logged in member idConfigured to not delete records from audit_entry tableConfigured to not delete records from DeletedPointInTimeObjects

Counts afterwards

obliterated (deleted) 
# and point in time will be deleted too. 
# "courses" or "anotherLabel" are variables you make up in these examples
loader.retain.db.folder.test.days=1825
loader.retain.db.folder.test.parentFolderName=users:penn
loader.retain.db.folder.test.deletePointInTime=true

Run the daemon with GSH

Code Block
gsh 0% grouperSession = GrouperSession.startRootSession();
edu.internet2.middleware.grouper.GrouperSession: 7f8474d2914a4cecac143be77768a34b,'GrouperSystem','application'
gsh 1% loaderRunOneJob("MAINTENANCE_cleanLogs");

loader ran successfully: Deleted 3872 records from grouper_loader_log older than 7 days old.  Deleted 2038 records from grouper_change_log_entry older than 14 days old. (1517867128940000)  Deleted 0 instrumentation records older than 30 days old. (1516484734612)  Configured to not delete records from audit_entry table with null logged in member idConfigured to not delete records from audit_entry tableConfigured to not delete records from DeletedPointInTimeObjects

Counts afterwards

Code Block
Audit entries: 53540
Audit entries no logged in user: 44657
Audit entries no logged in user older than a month old: 0
PIT entries: 66930
PIT entries of deleted objects: 44508
PIT entries of deleted objects older than a month: 0
Folders in delete folder 'users:penn' newer than 5 years: 5
Folders in delete folder 'users:penn' older than 5 years: 

Counts

Code Block
Audit entries: 9071
Code Block
Audit entries: 53540
Audit entries no logged in user: 44657
Audit entries no logged in user older than a month old: 0
PIT entries: 66930
PIT entries of deleted objects: 44508
PIT entries of deleted objects older than a month: 0
Folders in delete folder 'users:penn' newer than 5 years: 5
Folders in delete folder 'users:penn' older than 5 years: 

...