terraform.azure.security.azure-postgresql-min-tls-version.azure-postgresql-min-tls-version

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

Ensure PostgreSQL is using the latest version of TLS encryption

Run Locally

Run in CI

Semgrep CI docs

Defintion

Edit RuleView Source
Open in Playground 
rules:
  - id: azure-postgresql-min-tls-version
    message: Ensure PostgreSQL is using the latest version of TLS encryption
    patterns:
      - pattern-either:
          - pattern: |
              "TLS1_2"
          - pattern: |
              "TLS1_1"
          - pattern: |
              "TLS1_0"
      - pattern-inside: ssl_minimal_tls_version_enforced = ...
      - pattern-inside: |
          $RESOURCE "azurerm_postgresql_server" "..." {
          ...
          }
      - pattern-not-inside: |
          $RESOURCE "azurerm_postgresql_server" "..." {
          ...
          ssl_enforcement_enabled = true
          ...
          }
    metadata:
      owasp:
        - A03:2017 - Sensitive Data Exposure
        - A02:2021 - Cryptographic Failures
      cwe:
        - "CWE-326: Inadequate Encryption Strength"
      category: security
      technology:
        - terraform
        - azure
      references:
        - https://owasp.org/Top10/A02_2021-Cryptographic_Failures
      subcategory:
        - audit
      likelihood: LOW
      impact: LOW
      confidence: LOW
      license: Commons Clause License Condition v1.0[LGPL-2.1-only]
      vulnerability_class:
        - Cryptographic Issues
    languages:
      - hcl
    severity: WARNING

Examples

azure-postgresql-min-tls-version.tf

# fail
resource "azurerm_postgresql_server" "example" {
    name                = "example-psqlserver"
    location            = azurerm_resource_group.example.location
    resource_group_name = azurerm_resource_group.example.name

    administrator_login          = "psqladminun"
    administrator_login_password = "H@Sh1CoR3!"

    sku_name   = "GP_Gen5_4"
    version    = "9.6"
    storage_mb = 640000

    backup_retention_days        = 7
    geo_redundant_backup_enabled = true
    auto_grow_enabled            = true

    public_network_access_enabled    = false
    ssl_enforcement_enabled          = false
    # ruleid: azure-postgresql-min-tls-version
    ssl_minimal_tls_version_enforced = "TLS1_2"
}

# pass
resource "azurerm_postgresql_server" "example" {
    name                = "example-psqlserver"
    location            = azurerm_resource_group.example.location
    resource_group_name = azurerm_resource_group.example.name

    administrator_login          = "psqladminun"
    administrator_login_password = "H@Sh1CoR3!"

    sku_name   = "GP_Gen5_4"
    version    = "9.6"
    storage_mb = 640000

    backup_retention_days        = 7
    geo_redundant_backup_enabled = true
    auto_grow_enabled            = true

    public_network_access_enabled    = false
    ssl_enforcement_enabled          = true
    ssl_minimal_tls_version_enforced = "TLS1_2"
}