Watch4Net: How can I enable/disable debug logging for the APG Datastore (legacy BH datastore) ?

Products

• VMware

Environment

VMware Smart Assurance - Watch4Net/M&R

Resolution

How can I enable debug logging for the Watch4Net APG Datastore?
How can I disable debug logging for the Watch4Net APG Datastore?



The following sections explain the procedures for enabling and disabling debug logging for the Watch4Net APG Datastore (legacy BH datastore)

Enabling Watch4net APG Datastore debug logging
You can enable full debug logging in the APG Datastore using the following procedure:

IMPORTANT! There are impacts to application processing performance and storage usage with this level of logging. It is not reccomended to leave debug logging enabled for an extended period of time or as a "normal" operating mode. Debug logging should only be enabled long enough for an issue being investigated to be reproduced, and then disabled as described in the following 'disabling logging' section.

1. Stop the Watch4net APG Event Processing Manager:
   
   /opt/APG/bin/manage-modules.sh service stop event-processing-manager
   
    
2. Stop the Watch4net APG Datastore:
   
   /opt/APG/bin/manage-modules.sh service stop datastore
   
    
3. Edit the Datastore logging settings as follows:
    
4. • Set the following parameter and value in the Watch4net APG brighthouse.ini file (/opt/APG/Databases/APG-Datastore/Default/data/brighthouse.ini):
     
                ControlMessages = 5
      
   • Uncomment (remove the # from the start of) the following lines in the Watch4net APG my.cnf file (/opt/APG/Databases/APG-Datastore/Default/my.cnf):
     
                # general_log=1
                # general_log_file = general_query.log # ADD FOR GENERAL QUERY LOGGING
                # slow_query_log=1
                # slow_query_log_file = slow_query.log # ADD FOR SLOW QUERY LOGGING
     
      
5. Start the Watch4net APG Datastore:
   
   /opt/APG/bin/manage-modules.sh service start datastore
   
    
6. Start the Event Processing Manager
   
   /opt/APG/bin/manage-modules.sh service start event-processing-manager

Disabling Watch4net APG Datastore debug logging
You can disable debug logging in the APG Datastore using the following procedure:

1. Stop the Watch4net APG Event Processing Manager:
   
   /opt/APG/bin/manage-modules.sh service stop event-processing-manager
   
    
2. Stop the Watch4net APG Datastore:
   
   /opt/APG/bin/manage-modules.sh service stop datastore
   
    
3. Edit the Datastore logging settings as follows:
    
4. • Set the following parameter and value in the Watch4net APG brighthouse.ini file (/opt/APG/Databases/APG-Datastore/Default/data/brighthouse.ini):
     
                ControlMessages = 0
   • Comment/disable (add # to the start of) the following lines in the Watch4net APG my.cnf file (/opt/APG/Databases/APG-Datastore/Default/my.cnf):
     
                general_log=1
                general_log_file = general_query.log # ADD FOR GENERAL QUERY LOGGING
                slow_query_log=1
                slow_query_log_file = slow_query.log # ADD FOR SLOW QUERY LOGGING
     
      
5. Start the Watch4net APG Datastore:
   
   /opt/APG/bin/manage-modules.sh service start datastore
   
    
6. Start the Event Processing Manager
   
   /opt/APG/bin/manage-modules.sh service start event-processing-manager