Microsoft AzureOverview
Enable SSL connection on MariaDB Database Servers.
Rationale
SSL connectivity helps to provide a new layer of security by connecting the database server to client applications using Secure Sockets Layer (SSL). Enforcing SSL connections between database servers and client applications helps protect against "man-in-the-middle" attacks by encrypting the data stream between the server and application.
Remediation guidance
From Azure Console
- Go to
Azure Database for MariaDB servers - For each
Azure Database for MariaDB server, underSettings, selectConnection security - Under the
SSL settingsheader, click onENABLEDforEnforce SSL connection
Using Azure Command Line Interface
Use the below command to Enforce ssl connection for MariaDB Database Server.
az mariadb server update --resource-group <resourceGroupName> --name <serverName> --ssl-enforcement Enabled
References
- https://learn.microsoft.com/en-us/azure/postgresql/concepts-ssl-connection-security
- https://learn.microsoft.com/en-us/security/benchmark/azure/security-controls-v3-data-protection#dp-4-encrypt-sensitive-information-in-transit
Service-wide remediation
Recommended when many resources are affected: fix the platform baseline first so new resources inherit the secure setting, then remediate the existing flagged resources in batches.
Azure
Use management group or subscription Azure Policy assignments, remediation tasks where supported, landing-zone standards, and IaC modules so drift is prevented at scale.
Operational rollout
- Fix the baseline first at the account, subscription, project, cluster, or tenant scope that owns this control.
- Remediate the currently affected resources in batches, starting with internet-exposed and production assets.
- Re-scan and track approved exceptions with an owner and expiry date.
Query logic
These are the stored checks tied to this control.
'Enforce SSL connection' is set to 'ENABLED' for MariaDB Database Server
Connectors
Covered asset types
Expected check: eq []
{
mariaDbServers(
where: {
OR: [
{ sslEnforcement_MATCHES: "Disabled" }
{ sslEnforcement: null }
]
}
) {
...AssetFragment
}
}
