PostgreSQL Misconfigured Logging Duration Flag
- Query id: aed98a2a-e680-497a-8886-277cea0f4514
- Query name: PostgreSQL Misconfigured Logging Duration Flag
- Platform: Ansible
- Severity: Low
- Category: Insecure Configurations
- CWE: 20
- URL: Github
Description¶
PostgreSQL database 'log_min_duration_statement' flag isn't set to '-1'
Documentation
Code samples¶
Code samples with security vulnerabilities¶
Positive test num. 1 - yaml file
- name: sql_instance
google.cloud.gcp_sql_instance:
auth_kind: serviceaccount
database_version: SQLSERVER_13_1
name: "{{ resource_name }}-2"
project: test_project
region: us-central1
service_account_file: /tmp/auth.pem
settings:
database_flags:
- name: log_min_duration_statement
value: 0
tier: db-n1-standard-1
state: present
Code samples without security vulnerabilities¶
Negative test num. 1 - yaml file
- name: sql_instance
google.cloud.gcp_sql_instance:
auth_kind: serviceaccount
database_version: SQLSERVER_13_1
name: '{{ resource_name }}-2'
project: test_project
region: us-central1
service_account_file: /tmp/auth.pem
settings:
database_flags:
- name: log_min_duration_statement
value: -1
tier: db-n1-standard-1
state: present