Severity Framework
Snyk CCSS
Rule category
Logging / Configuration
Is your enviroment affected by this misconfiguration?
In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.
Test your applicationsFrameworks
CIS-Controls
CIS-Google
HIPAA
ISO-27001
NIST-800-53
SOC-2
- Snyk ID SNYK-CC-00360
- credit Snyk Research Team
Description
The PostgreSQL database instance flag 'log_connections' causes successful and unsuccessful connections to be logged. This data can be used to identify, troubleshoot, and repair configuration errors and denial of service attacks. This flag and the 'log_disconnections' flag are typically used together.
How to fix?
Set settings.database_flags.name attribute to "log_connections", and settings.database_flags.value attribute to "on".
Example Configuration
resource "google_sql_database_instance" "allowed" {
name = "master-instance"
database_version = "POSTGRES_11"
region = "us-central1"
settings {
tier = "db-f1-micro"
database_flags {
name = "log_connections"
value = "on"
}
}
}