Skip to main content

🧠 Azure MySQL Flexible Server audit_log_events Parameter is not set with the CONNECTION event - prod.logic.yaml 🟒

Flags​

Input Type​

TypeAPI NameExtractsExtract FilesLogic Files
πŸ”’πŸ“• Azure MySQL ServerCA10Z1__CaAzureMySqlServer__c514

Uses​

Test Results πŸŸ’β€‹

Generated at: 2025-05-10T12:02:54.631504848Z Open

ResultIdCondition IndexCondition TextRuntime Error
🟒test1βœ”οΈ 99βœ”οΈ isDisappeared(CA10Z1__disappearanceTime__c)βœ”οΈ null
🟒test2βœ”οΈ 499βœ”οΈ extract('caJsonFrom__configurations__c').jsonQueryText('[? name == \'audit_log_enabled\'].value | [0]') == 'on' && extract('caJsonFrom__configurations__c').jsonQueryText('[? name == \'audit_log_events\'].value | [0]') == 'CONNECTION'βœ”οΈ null
🟒test3βœ”οΈ 299βœ”οΈ extract('caJsonFrom__configurations__c').jsonQueryText('[? name == \'audit_log_enabled\'].value | [0]') == 'off'βœ”οΈ null
🟒test4βœ”οΈ 500βœ”οΈ otherwiseβœ”οΈ null
🟒test5βœ”οΈ 201βœ”οΈ CA10Z1__configurations__c.delegatedTo(CA10Z1__configurations__c).isEmpty()βœ”οΈ null
🟒test6βœ”οΈ 199βœ”οΈ extract('CA10Z1__deploymentMode__c') != 'Flexible'βœ”οΈ null
🟒test7βœ”οΈ 399βœ”οΈ extract('caJsonFrom__configurations__c').jsonQueryText('[? name == \'audit_log_enabled\'].value | [0]') == 'on' && extract('caJsonFrom__configurations__c').jsonQueryText('[? name == \'audit_log_events\'].value | [0]') != 'CONNECTION'βœ”οΈ null

Generation​

FileMD5
Open/ce/ca/azure/mysql-database/flexible-server-audit-log-events-parameter/policy.yaml08B32B3A47DDFBAEB5D38086EB367D91
Open/ce/ca/azure/mysql-database/flexible-server-audit-log-events-parameter/prod.logic.yamlD1D9B7C427FB7475BEB932E147598AA1
Open/ce/ca/azure/mysql-database/flexible-server-audit-log-events-parameter/test-data.jsonA820ED1D2BE98D6B54D79E291EC30D7E
Open/types/CA10Z1__CaAzureMySqlServer__c/object.extracts.yaml990A7F1866AD74ACB9B3004B364BDA8A

Generate FULL script​

java -jar repo-manager.jar policies generate FULL /ce/ca/azure/mysql-database/flexible-server-audit-log-events-parameter/prod.logic.yaml

Generate DEBUG script​

java -jar repo-manager.jar policies generate DEBUG /ce/ca/azure/mysql-database/flexible-server-audit-log-events-parameter/prod.logic.yaml

Generate CAPTURE_TEST_DATA script​

java -jar repo-manager.jar policies generate CAPTURE_TEST_DATA /ce/ca/azure/mysql-database/flexible-server-audit-log-events-parameter/prod.logic.yaml

Generate TESTS script​

java -jar repo-manager.jar policies generate TESTS /ce/ca/azure/mysql-database/flexible-server-audit-log-events-parameter/prod.logic.yaml

Execute tests​

java -jar repo-manager.jar policies test /ce/ca/azure/mysql-database/flexible-server-audit-log-events-parameter/prod.logic.yaml

Content​

Open File

---
inputType: "CA10Z1__CaAzureMySqlServer__c"
testData:
- file: "test-data.json"
importExtracts:
- file: "/types/CA10Z1__CaAzureMySqlServer__c/object.extracts.yaml"
conditions:
- status: "INAPPLICABLE"
currentStateMessage: "This is not the Flexible Server deployment mode."
check:
NOT_EQUAL:
left:
EXTRACT: "CA10Z1__deploymentMode__c"
right:
TEXT: "Flexible"
- status: "INCOMPLIANT"
currentStateMessage: "MySQL Flexible Server audit_log_enabled configuration parameter is disabled."
remediationMessage: "Consider enabling MySQL Flexible Server audit_log_enabled configuration."
check:
IS_EQUAL:
left:
JSON_QUERY_TEXT:
arg:
EXTRACT: "caJsonFrom__configurations__c"
expression: "[? name == 'audit_log_enabled'].value | [0]"
undeterminedIf:
evaluationError: "The JSON query has failed."
resultTypeMismatch: "The JSON query did not return text type."
right:
TEXT: "off"
- status: "INCOMPLIANT"
currentStateMessage: "MySQL Flexible Server audit_log_events configuration parameter is not set to CONNECTION."
remediationMessage: "Consider setting MySQL Flexible Server audit_log_events configuration to CONNECTION."
check:
AND:
args:
- IS_EQUAL:
left:
JSON_QUERY_TEXT:
arg:
EXTRACT: "caJsonFrom__configurations__c"
expression: "[? name == 'audit_log_enabled'].value | [0]"
undeterminedIf:
evaluationError: "The JSON query has failed."
resultTypeMismatch: "The JSON query did not return text type."
right:
TEXT: "on"
- NOT_EQUAL:
left:
JSON_QUERY_TEXT:
arg:
EXTRACT: "caJsonFrom__configurations__c"
expression: "[? name == 'audit_log_events'].value | [0]"
undeterminedIf:
evaluationError: "The JSON query has failed."
resultTypeMismatch: "The JSON query did not return text type."
right:
TEXT: "CONNECTION"
- status: "COMPLIANT"
currentStateMessage: "MySQL Flexible Server audit_log_events configuration parameter is set to CONNECTION."
check:
AND:
args:
- IS_EQUAL:
left:
JSON_QUERY_TEXT:
arg:
EXTRACT: "caJsonFrom__configurations__c"
expression: "[? name == 'audit_log_enabled'].value | [0]"
undeterminedIf:
evaluationError: "The JSON query has failed."
resultTypeMismatch: "The JSON query did not return text type."
right:
TEXT: "on"
- IS_EQUAL:
left:
JSON_QUERY_TEXT:
arg:
EXTRACT: "caJsonFrom__configurations__c"
expression: "[? name == 'audit_log_events'].value | [0]"
undeterminedIf:
evaluationError: "The JSON query has failed."
resultTypeMismatch: "The JSON query did not return text type."
right:
TEXT: "CONNECTION"
otherwise:
status: "UNDETERMINED"
currentStateMessage: "Unexpected value in the field."