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