Playbook 12: RDS unencrypted instances

Introduction

This playbook describes how to configure Dow Jones Hammer to detect RDS instances that are not encrypted at rest.

1. Issue Identification

Dow Jones Hammer identifies those RDS instances for which StorageEncrypted parameter value is false.

When Dow Jones Hammer detects an issue, it writes the issue to the designated DynamoDB table.

According to the Dow Jones Hammer architecture, the issue identification functionality uses two Lambda functions. The table lists the Python modules that implement this functionality:

2. Issue Reporting

You can configure automatic reporting of cases when Dow Jones Hammer identifies an issue of this type. Dow Jones Hammer supports integration with JIRA and Slack. These types of reporting are independent from one another and you can turn them on/off in the Dow Jones Hammer configuration.

Thus, in case you have turned on the reporting functionality for this issue and configured corresponding integrations, Dow Jones Hammer, as defined in the configuration, can:

• raise a JIRA ticket and assign it to a specific person in your organization;
• send the issue notification to the Slack channel or directly to a Slack user.

Additionally Dow Jones Hammer tries to detect person to report issue to by examining owner tag on affected RDS instance. In case when such tag exists and is valid JIRA/Slack user:

• for JIRA: jira_owner parameter from ticket_owners.json is ignored and discovered owner is used instead as a JIRA assignee;
• for Slack: discovered owner is used in addition to slack_owner value from ticket_owners.json.

This Python module implements the issue reporting functionality:

hammer/reporting-remediation/reporting/create_rds_unencrypted_instance_issue_tickets.py

3. Setup Instructions For This Issue

To configure the detection, reporting, you should edit the following sections of the Dow Jones Hammer configuration files:

3.1. The config.json File

The config.json file is the main configuration file for Dow Jones Hammer that is available at deployment/terraform/accounts/sample/config/config.json. To identify and report issues of this type, you should add the following parameters in the rds_encryption section of the config.json file:

Sample config.json section:

"rds_encryption": {
    "enabled": true,
    "ddb.table_name": "hammer-rds-unencrypted",
    "reporting": true
}

3.2. The whitelist.json File

You can define exceptions to the general automatic remediation settings for specific RDS instances. To configure such exceptions, you should edit the rds_encryption section of the whitelist.json configuration file as follows:

Sample whitelist.json section:

"rds_encryption": {
    "123456789012": ["instance_arn1", "instance_arn2"]
}

3.3. The ticket_owners.json File

You should use the ticket_owners.json file to configure the integration of Dow Jones Hammer with JIRA and/or Slack for the issue reporting purposes.

You can configure these parameters for specific AWS accounts and globally. Account-specific settings precede the global settings in the ticket_owners.json configuration file.

Check the following table for parameters:

Sample ticket_owners.json section:

Account-specific settings:

{
    "account": {
        "123456789012": {
            "jira_project": "",
            "jira_owner": "Support-Cloud",
            "jira_parent_ticket": "",
            "slack_owner": ""
        }
    },
    "jira_project": "AWSSEC",
    "jira_owner": "Support-General",
    "jira_parent_ticket": "AWSSEC-1234",
    "slack_owner": ["#devops-channel", "bob"]
}

4. Logging

Dow Jones Hammer uses CloudWatch Logs for logging purposes.

Dow Jones Hammer automatically sets up CloudWatch Log Groups and Log Streams for this issue when you deploy Dow Jones Hammer.

4.1. Issue Identification Logging

Dow Jones Hammer issue identification functionality uses two Lambda functions:

• Initialization: this Lambda function selects slave accounts to check for this issue as designated in the Dow Jones Hammer configuration files and triggers the check.
• Identification: this Lambda function identifies this issue for each account/region selected at the previous step.

You can see the logs for each of these Lambda functions in the following Log Groups:

4.2. Issue Reporting Logging

Dow Jones Hammer issue reporting functionality uses /aws/ec2/hammer-reporting-remediation CloudWatch Log Group for logging. The Log Group contains issue-specific Log Streams named as follows:

4.3. Slack Reports

In case you have enabled Dow Jones Hammer and Slack integration, Dow Jones Hammer sends notifications about issue identification and reporting to the designated Slack channel and/or recipient(s).

Check ticket_owners.json configuration for further guidance.

4.4. Using CloudWatch Logs for Dow Jones Hammer

To access Dow Jones Hammer logs, proceed as follows:

1. Open AWS Management Console.
2. Select CloudWatch service.
3. Select Logs from the CloudWatch sidebar.
4. Select the log group you want to explore. The log group will open.
5. Select the log stream you want to explore.

Check CloudWatch Logs documentation for further guidance.

5. Issue specific details in DynamoDB

Dow Jones Hammer stores various issue specific details in DynamoDB as a map under issue_details key. You can use it to create your own reporting modules.