🧠 Azure VM Scale Set Instance allows public access to MySQL port - prod.logic.yaml 🟢
- Contextual name: 🧠 prod.logic.yaml 🟢
- ID:
/ce/ca/azure/vm-scale-set/instance-allows-unrestricted-traffic-to-mysql/prod.logic.yaml - Located in: 📝 Azure VM Scale Set Instance allows public access to MySQL port 🟢
Flags
Input Type
| Type | API Name | Extracts | Extract Files | Logic Files | |
|---|---|---|---|---|---|
| 🔒 | 📕 Azure VM Scale Set Instance | CA10__CaAzureVmScaleSetInstance__c | 1 | 1 | 17 |
Uses
Test Results 🟢
Generated at: 2025-05-03T12:05:26.550955894Z Open
| Result | Id | Condition Index | Condition Text | Runtime Error |
|---|---|---|---|---|
| 🟢 | test-0 | ✔️ 99 | ✔️ isDisappeared(CA10__disappearanceTime__c) | ✔️ null |
| 🟢 | test-1 | ✔️ 200 | ✔️ otherwise | ✔️ null |
| 🟢 | test-2 | ✔️ 200 | ✔️ otherwise | ✔️ null |
| 🟢 | test-3 | ✔️ 200 | ✔️ otherwise | ✔️ null |
| 🟢 | test-4 | ✔️ 200 | ✔️ otherwise | ✔️ null |
| 🟢 | test-5 | ✔️ 199 | ✔️ CA10Z1__Azure_VM_Scale_Set_Instance_Network_Ints__r.has(INCOMPLIANT) | ✔️ null |
| 🟢 | test-6 | ✔️ 199 | ✔️ CA10Z1__Azure_VM_Scale_Set_Instance_Network_Ints__r.has(INCOMPLIANT) | ✔️ null |
| 🟢 | test-7 | ✔️ 200 | ✔️ otherwise | ✔️ null |
Generation
| File | MD5 | |
|---|---|---|
| Open | /ce/ca/azure/vm-scale-set/instance-allows-unrestricted-traffic-to-mysql/policy.yaml | 7C9A49E31534A432354B497C164C871C |
| Open | /ce/ca/azure/vm-scale-set/instance-allows-unrestricted-traffic-to-mysql/prod.logic.yaml | 03E33F881B7A0E6E157D1B52E23A5734 |
| Open | /types/CA10__CaAzureNetworkSecurityGroupRule__c/object.extracts.yaml | A60C817EFBC8F066D6D082898E8597BC |
| Open | /ce/ca/azure/vm-scale-set/instance-allows-unrestricted-traffic-to-mysql/test-data.json | 5BB14266F9584595A01DF41C7D694E3C |
Generate FULL script
java -jar repo-manager.jar policies generate FULL /ce/ca/azure/vm-scale-set/instance-allows-unrestricted-traffic-to-mysql/prod.logic.yaml
Generate DEBUG script
java -jar repo-manager.jar policies generate DEBUG /ce/ca/azure/vm-scale-set/instance-allows-unrestricted-traffic-to-mysql/prod.logic.yaml
Generate CAPTURE_TEST_DATA script
java -jar repo-manager.jar policies generate CAPTURE_TEST_DATA /ce/ca/azure/vm-scale-set/instance-allows-unrestricted-traffic-to-mysql/prod.logic.yaml
Generate TESTS script
java -jar repo-manager.jar policies generate TESTS /ce/ca/azure/vm-scale-set/instance-allows-unrestricted-traffic-to-mysql/prod.logic.yaml
Execute tests
java -jar repo-manager.jar policies test /ce/ca/azure/vm-scale-set/instance-allows-unrestricted-traffic-to-mysql/prod.logic.yaml
Content
---
inputType: "CA10__CaAzureVmScaleSetInstance__c"
testData:
- file: test-data.json
conditions:
- status: "INCOMPLIANT"
currentStateMessage: "The Instance has a Network Interface with a NSG with a rule that allows MySQL access from the Internet."
remediationMessage: "Restrict inbound MySQL access from the Internet."
check:
RELATED_LIST_HAS:
status: "INCOMPLIANT"
relationshipName: "CA10Z1__Azure_VM_Scale_Set_Instance_Network_Ints__r"
otherwise:
status: "COMPLIANT"
currentStateMessage: "The Instance doesn't allow MySQL access from the Internet."
relatedLists:
- relationshipName: "CA10Z1__Azure_VM_Scale_Set_Instance_Network_Ints__r"
importExtracts:
- file: "/types/CA10__CaAzureNetworkSecurityGroupRule__c/object.extracts.yaml"
conditions:
- status: "INCOMPLIANT"
currentStateMessage: "Interface with publicly accessible Network Security Group"
check:
RELATED_LIST_HAS:
status: "INCOMPLIANT"
relationshipName: "CA10Z1__networkSecurityGroup__r.CA10__Azure_Network_Security_Group_Rules__r"
otherwise:
status: "COMPLIANT"
currentStateMessage: "Interface is not publicly accessible"
relatedLists:
- relationshipName: "CA10Z1__networkSecurityGroup__r.CA10__Azure_Network_Security_Group_Rules__r"
importExtracts:
- file: "/types/CA10__CaAzureNetworkSecurityGroupRule__c/object.extracts.yaml"
conditions:
# sort public group rules
- status: "INAPPLICABLE"
currentStateMessage: "NSG Outbound Rule."
check:
NOT_EQUAL:
left:
EXTRACT: "CA10__direction__c"
right:
TEXT: "Inbound"
- status: "INAPPLICABLE"
currentStateMessage: "NSG Deny Rule."
check:
NOT_EQUAL:
left:
EXTRACT: "CA10__access__c"
right:
TEXT: "Allow"
- status: "INAPPLICABLE"
currentStateMessage: "NSG Rule with the port other than TCP or Any."
check:
NOT:
arg:
OR:
args:
- IS_EQUAL:
left:
EXTRACT: "CA10__protocol__c"
right:
TEXT: "Tcp"
- IS_EQUAL:
left:
EXTRACT: "CA10__protocol__c"
right:
TEXT: "*"
- IS_EQUAL:
left:
EXTRACT: "CA10__protocol__c"
right:
TEXT: "null"
- status: "INAPPLICABLE"
currentStateMessage: "NSG Rule source is not any address."
check:
NOT:
arg:
OR:
args:
- IS_EQUAL:
left:
EXTRACT: "CA10__sourceAddressPrefix__c"
right:
TEXT: "Internet"
- IS_EQUAL:
left:
EXTRACT: "CA10__sourceAddressPrefix__c"
right:
TEXT: "*"
- IS_EQUAL:
left:
EXTRACT: "CA10__sourceAddressPrefix__c"
right:
TEXT: "0.0.0.0"
- IS_EQUAL:
left:
EXTRACT: "CA10__sourceAddressPrefix__c"
right:
TEXT: "Any"
- CONTAINS:
arg:
EXTRACT: "CA10__sourceAddressPrefix__c"
substring:
TEXT: "/0"
- status: "INCOMPLIANT"
currentStateMessage: "NSG Rule with MySQL port with public access from the Internet."
remediationMessage: "Close MySQL port"
check:
# PORT 3306
OR:
args:
- IS_EQUAL:
left:
EXTRACT: "CA10__destinationPortRange__c"
right:
TEXT: "3306"
- AND:
args:
- LESS_THAN_EQUAL:
left:
EXTRACT: "CA10__destinationPortFrom__c"
right:
NUMBER: 3306.0
- GREATER_THAN_EQUAL:
left:
EXTRACT: "CA10__destinationPortTo__c"
right:
NUMBER: 3306.0
otherwise:
status: "COMPLIANT"
currentStateMessage: "NSG rule without public access on MySQL port"