terraform.azure.best-practice.azure-mariadb-geo-backup-enabled.azure-mariadb-geo-backup-enabled

profile photo of semgrepsemgrep
Author
unknown
Download Count*
LGPL Commons Clause
License

Ensure that MariaDB server enables geo-redundant backups

Run Locally

Run in CI

Semgrep CI docs

Defintion

Edit RuleView Source
Open in Playground 
rules:
  - id: azure-mariadb-geo-backup-enabled
    message: Ensure that MariaDB server enables geo-redundant backups
    patterns:
      - pattern: resource
      - pattern-not-inside: |
          resource "azurerm_mariadb_server" "..." {
          ...
          geo_redundant_backup_enabled = true
          ...
          }
      - pattern-inside: |
          resource "azurerm_mariadb_server" "..." {
          ...
          }
    metadata:
      category: best-practice
      technology:
        - terraform
        - azure
      license: Commons Clause License Condition v1.0[LGPL-2.1-only]
    languages:
      - hcl
    severity: WARNING

Examples

azure-mariadb-geo-backup-enabled.tf

# fail
# ruleid: azure-mariadb-geo-backup-enabled
resource "azurerm_mariadb_server" "example" {
    name                = var.server_name
    location            = var.resource_group.location
    resource_group_name = var.resource_group.name
    administrator_login          = var.admin_login
    administrator_login_password = random_string.password.result
    sku_name   = "B_Gen5_2"
    storage_mb = 5120
    version    = "10.2"
    auto_grow_enabled             = true
    backup_retention_days         = 7
    geo_redundant_backup_enabled  = false
    public_network_access_enabled = true
    ssl_enforcement_enabled = false
}

# fail
# ruleid: azure-mariadb-geo-backup-enabled
resource "azurerm_mariadb_server" "example" {
    name                = var.server_name
    location            = var.resource_group.location
    resource_group_name = var.resource_group.name
    administrator_login          = var.admin_login
    administrator_login_password = random_string.password.result
    sku_name   = "B_Gen5_2"
    storage_mb = 5120
    version    = "10.2"
    auto_grow_enabled             = true
    backup_retention_days         = 7
    public_network_access_enabled = true
    ssl_enforcement_enabled = false
}

# pass
resource "azurerm_mariadb_server" "example" {
    name                = var.server_name
    location            = var.resource_group.location
    resource_group_name = var.resource_group.name
    administrator_login          = var.admin_login
    administrator_login_password = random_string.password.result
    sku_name   = "B_Gen5_2"
    storage_mb = 5120
    version    = "10.2"
    auto_grow_enabled             = true
    backup_retention_days         = 7
    geo_redundant_backup_enabled  = true
    public_network_access_enabled = false
    ssl_enforcement_enabled = true
}