GCP Terraform Misconfiguration: Cloud SQL Backup Disabled

Abstract

Terraform 配置设置了一个禁用备份配置的数据库实例。

Explanation

数据库备份对于防止数据丢失或损坏至关重要。应当显式配置和启用 Cloud SQL 数据库实例的自动备份。

示例 1：以下示例显示的 Terraform 配置通过将 enabled 设置为 false，禁用了数据库实例备份配置。


resource "google_sql_database_instance" "database_instance_demo" {
  ...
  settings {
    backup_configuration {
      enabled = false
      ...
    }
  }
}

References

[1] HashiCorp google_sql_database_instance

[2] Google Cloud About Cloud SQL backups

[3] Standards Mapping - CIS Google Cloud Computing Platform Benchmark Recommendation 6.7

[4] Standards Mapping - Common Weakness Enumeration CWE ID 1188

[5] Standards Mapping - DISA Control Correlation Identifier Version 2 CCI-000366, CCI-003109

[6] Standards Mapping - FIPS200 CM

[7] Standards Mapping - NIST Special Publication 800-53 Revision 4 SC-38 Operations Security (P0)

[8] Standards Mapping - NIST Special Publication 800-53 Revision 5 SC-38 Operations Security

[9] Standards Mapping - OWASP API 2023 API8 Security Misconfiguration

[10] Standards Mapping - OWASP Application Security Verification Standard 4.0 8.1.5 General Data Protection (L3)

[11] Standards Mapping - OWASP Top 10 2017 A6 Security Misconfiguration

[12] Standards Mapping - OWASP Top 10 2021 A05 Security Misconfiguration

[13] Standards Mapping - Payment Card Industry Data Security Standard Version 3.2.1 Requirement 12.10.1

[14] Standards Mapping - Payment Card Industry Data Security Standard Version 4.0 Requirement 12.10.1

[15] Standards Mapping - Payment Card Industry Data Security Standard Version 4.0.1 Requirement 12.10.1

[16] Standards Mapping - Payment Card Industry Software Security Framework 1.0 Control Objective 2.2 - Secure Defaults

[17] Standards Mapping - Payment Card Industry Software Security Framework 1.1 Control Objective 2.2 - Secure Defaults

[18] Standards Mapping - Payment Card Industry Software Security Framework 1.2 Control Objective 2.2 - Secure Defaults

desc.structural.hcl.gcp_terraform_misconfiguration_cloud_sql_backup_disabled