27/07/2026 17:08:05 UTC
TCP
8123 · HTTP
clickhouse probe
clickhouse probe · via HTTP:8123 · (sonde / probe)
Élevée
Moyen · 53
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
29
Recommandation
Investiguer
Tags
950005:sqli-1
950037:sqli-9
950325:rce-0
950734:sap-sapcontrol-path
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Pourquoi cette classification : Type « clickhouse_probe » (signaux protocolaires) · confiance 49%
Confiance classification
49%
Confiance modérée — signal unique
Risque capteur
Moyen
· 53
Confiance : Confiance 49 % — Motif catalogue confirmé · 5 tag(s) WAF
Protocole émulé
1 Signaux
pat-0737
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Motifs de détection (base)
ClickHouse query
Ligne de requête
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2010 HTTP/1.1
User-Agent
curl/8
Règles WAF
sqli-1
sqli-9
rce-0
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%2
Requête brute (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2010 HTTP/1.1
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "77fca0ef672687aa56e5235009133ed5f91cbf3f",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 347,
"payload_entropy": 5.291007100888589,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 100,
"risk_classification": 60,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 35,
"risk_boost": 0,
"risk_granularity": 3.2,
"risk_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35
},
"risk_score": 53,
"tag_count": 9,
"anomaly_count": 2,
"campaign_key": "e84efbc9ffcdb7d0dd5ae8251a2f0667c7a8bbf7",
"event_fingerprint": "f949cb1ecaf1f2e8e4912fbb83a1c2bc818cc317",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"confidence": 0.49,
"classification_confidence": 0.49,
"precision_score": 58,
"precision_signals": [
"pat-0737"
],
"kb_rule_ids": [
"pat-0737"
],
"matched_patterns": [
"pat-0737"
],
"matched_pattern_names": [
"ClickHouse query"
],
"pattern_ids": [
"pat-0737"
],
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 49,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "862e255dd582f595406603eb2b082fa1",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 53
},
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2010",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2010 HTTP\/1.1",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%2",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2010",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2010 HTTP\/1.1",
"request_sample": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2010 HTTP\/1.1\r\n",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%2",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"scanner"
],
"recommended_client_action": "investigate",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "948c50bf71a5bb8d8ccaa65dc57abb357a3a7b0d",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%2",
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"classification_reason_label_fr": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u2014 risque 53\/100 (Moyen) \u2014 MITRE TA0007 \u2014 confiance 49 % \u2014 via HTTP",
"confidence_pct": 49,
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 53,
"risk_label": "Moyen",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": [
"pat-0737"
],
"tags_summary_labels_fr": [
"pat-0737"
],
"recommended_action": "investigate",
"recommended_action_label": "Investiguer",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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": "Confiance mod\u00e9r\u00e9e \u2014 signal unique",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%27%2",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"confidence_factors_fr": "Confiance 49 % \u2014 Score WAF 100 \u00b7 5 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"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": "discovery",
"ban_policy": "advisory_investigate",
"tags_list": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 17:06:39 UTC
TCP
8123 · HTTP
Sonde port 8123/TCP
port 8123 tcp · via HTTP:8123 · (sonde / probe)
Élevée
Faible · 38
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
6
Recommandation
Surveiller
Tags
950734:sap-sapcontrol-path
scanner-ua
anomaly:scanner-ua
http_ua_suspicious
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Preuve honeypot — Sonde port 8123/TCP
Connexion détectée sur le port 8123 (TCP) du capteur simulé.
Pourquoi cette classification : Type « port_8123_tcp » (signaux protocolaires) · confiance 55%
Confiance classification
55%
Risque capteur
Faible
· 38
Confiance : Confiance 55 % — Classification nommée non retenue — preuves insuffisantes · 2 tag(s) WAF
Protocole émulé
1
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Ligne de requête
GET /?query=SHOW%20DATABASES HTTP/1.1
User-Agent
curl/8
Règles WAF
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SHOW%20DATABASES HTTP/1.1
Accept-Encoding: identity
Host: 62.3.50.33:8123
User-Agent: curl/8
Connection: close
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "fdf86d4f1b483f5ec36c5f63c0d2edab7b9dddbb",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 130,
"payload_entropy": 5.193753464020308,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 32,
"risk_classification": 38,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 30,
"risk_boost": 0,
"risk_granularity": 1.9,
"risk_breakdown": {
"waf": 32,
"classification": 38,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 30
},
"risk_score": 38,
"tag_count": 5,
"anomaly_count": 1,
"campaign_key": "9fa83b631b47c2a330b4d59d07a14c0ec24c59e5",
"event_fingerprint": "12d54887e9b449f1412515f589d0a10f48748249",
"classification_reason": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%",
"confidence": 0.55,
"classification_confidence": 0.55,
"precision_score": 0,
"precision_signals": [],
"kb_rule_ids": [],
"confidence_breakdown": {
"waf": 32,
"classification": 38,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 30,
"risk_score": 38
},
"named_classification_skipped": true,
"named_candidate": "web_scanner",
"service_name": "http",
"risk_confidence_factor": 55,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "383ce9cbdaf89ac66638f09759e329f3",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 38
},
"payload_preview": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r\n",
"method": "GET",
"path": "\/",
"query_string": "query=SHOW%20DATABASES",
"user_agent": "curl\/8",
"waf_tags": [
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SHOW%20DATABASES HTTP\/1.1",
"request_sample": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r\n\r\n",
"payload_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SHOW%20DATABASES",
"user_agent": "curl\/8",
"waf_tags": [
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SHOW%20DATABASES HTTP\/1.1",
"request_sample": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r\n\r\n",
"payload_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"classification_reason": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"unknown"
],
"recommended_client_action": "monitor",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "bf9895a42d239499c071e79661527abe485813a5",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SHOW%20DATABASES HTTP\/1.1",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"attack_vector": "port 8123 tcp \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 55 % \u2014 Classification nomm\u00e9e non retenue \u2014 preuves insuffisantes \u00b7 2 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%",
"classification_reason_label_fr": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u00b7 risque 38\/100",
"confidence_pct": 55,
"confidence_breakdown": {
"waf": 32,
"classification": 38,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 30,
"risk_score": 38
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 38,
"risk_label": "Faible",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": null,
"tags_summary_labels_fr": null,
"recommended_action": "monitor",
"recommended_action_label": "Surveiller",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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=SHOW%20DATABASES HTTP\/1.1",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "port 8123 tcp \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 55 % \u2014 Classification nomm\u00e9e non retenue \u2014 preuves insuffisantes \u00b7 2 tag(s) WAF",
"confidence_factors_fr": "Confiance 55 % \u2014 Score WAF 32 \u00b7 2 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"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": "discovery",
"matched_patterns": [],
"ban_policy": "advisory_monitor",
"tags_list": [
"950734:sap-sapcontrol-path",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 16:34:59 UTC
TCP
8123 · HTTP
clickhouse probe
clickhouse probe · via HTTP:8123 · (sonde / probe)
Élevée
Moyen · 53
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
29
Recommandation
Investiguer
Tags
950005:sqli-1
950037:sqli-9
950325:rce-0
950734:sap-sapcontrol-path
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Pourquoi cette classification : Type « clickhouse_probe » (signaux protocolaires) · confiance 49%
Confiance classification
49%
Confiance modérée — signal unique
Risque capteur
Moyen
· 53
Confiance : Confiance 49 % — Motif catalogue confirmé · 5 tag(s) WAF
Protocole émulé
1 Signaux
pat-0737
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Motifs de détection (base)
ClickHouse query
Ligne de requête
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e
User-Agent
curl/8
Règles WAF
sqli-1
sqli-9
rce-0
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr
Requête brute (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "a188491183ce0f82cc9b34aec12281908fc1e44c",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 1015,
"payload_entropy": 5.025393174295087,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 100,
"risk_classification": 60,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 35,
"risk_boost": 0,
"risk_granularity": 3.2,
"risk_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35
},
"risk_score": 53,
"tag_count": 9,
"anomaly_count": 2,
"campaign_key": "e84efbc9ffcdb7d0dd5ae8251a2f0667c7a8bbf7",
"event_fingerprint": "7521f23b5d84c64f5123df59ca34b30117961fd4",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"confidence": 0.49,
"classification_confidence": 0.49,
"precision_score": 58,
"precision_signals": [
"pat-0737"
],
"kb_rule_ids": [
"pat-0737"
],
"matched_patterns": [
"pat-0737"
],
"matched_pattern_names": [
"ClickHouse query"
],
"pattern_ids": [
"pat-0737"
],
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 49,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "2607fcf4e9e07c0a33f5849c9df5ccef",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 53
},
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29epin%28",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29epin%28",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e",
"request_sample": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"scanner"
],
"recommended_client_action": "investigate",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "8740ea8e95aacbc11558983ac9e28ceea71ceac0",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"classification_reason_label_fr": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u2014 risque 53\/100 (Moyen) \u2014 MITRE TA0007 \u2014 confiance 49 % \u2014 via HTTP",
"confidence_pct": 49,
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 53,
"risk_label": "Moyen",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": [
"pat-0737"
],
"tags_summary_labels_fr": [
"pat-0737"
],
"recommended_action": "investigate",
"recommended_action_label": "Investiguer",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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": "Confiance mod\u00e9r\u00e9e \u2014 signal unique",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"confidence_factors_fr": "Confiance 49 % \u2014 Score WAF 100 \u00b7 5 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"active": true,
"kind": "chain",
"hint_fr": null
}
]
},
"meta_truncated": true,
"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": "discovery",
"ban_policy": "advisory_investigate",
"tags_list": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 16:06:29 UTC
TCP
8123 · HTTP
clickhouse probe
clickhouse probe · via HTTP:8123 · (sonde / probe)
Élevée
Moyen · 53
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
29
Recommandation
Investiguer
Tags
950005:sqli-1
950037:sqli-9
950325:rce-0
950734:sap-sapcontrol-path
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Pourquoi cette classification : Type « clickhouse_probe » (signaux protocolaires) · confiance 49%
Confiance classification
49%
Confiance modérée — signal unique
Risque capteur
Moyen
· 53
Confiance : Confiance 49 % — Motif catalogue confirmé · 5 tag(s) WAF
Protocole émulé
1 Signaux
pat-0737
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Motifs de détection (base)
ClickHouse query
Ligne de requête
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e
User-Agent
curl/8
Règles WAF
sqli-1
sqli-9
rce-0
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr
Requête brute (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "a188491183ce0f82cc9b34aec12281908fc1e44c",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 1015,
"payload_entropy": 5.025393174295087,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 100,
"risk_classification": 60,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 35,
"risk_boost": 0,
"risk_granularity": 3.2,
"risk_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35
},
"risk_score": 53,
"tag_count": 9,
"anomaly_count": 2,
"campaign_key": "e84efbc9ffcdb7d0dd5ae8251a2f0667c7a8bbf7",
"event_fingerprint": "7521f23b5d84c64f5123df59ca34b30117961fd4",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"confidence": 0.49,
"classification_confidence": 0.49,
"precision_score": 58,
"precision_signals": [
"pat-0737"
],
"kb_rule_ids": [
"pat-0737"
],
"matched_patterns": [
"pat-0737"
],
"matched_pattern_names": [
"ClickHouse query"
],
"pattern_ids": [
"pat-0737"
],
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 49,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "2607fcf4e9e07c0a33f5849c9df5ccef",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 53
},
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29epin%28",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29epin%28",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e",
"request_sample": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"scanner"
],
"recommended_client_action": "investigate",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "8740ea8e95aacbc11558983ac9e28ceea71ceac0",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"classification_reason_label_fr": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u2014 risque 53\/100 (Moyen) \u2014 MITRE TA0007 \u2014 confiance 49 % \u2014 via HTTP",
"confidence_pct": 49,
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 53,
"risk_label": "Moyen",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": [
"pat-0737"
],
"tags_summary_labels_fr": [
"pat-0737"
],
"recommended_action": "investigate",
"recommended_action_label": "Investiguer",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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": "Confiance mod\u00e9r\u00e9e \u2014 signal unique",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"confidence_factors_fr": "Confiance 49 % \u2014 Score WAF 100 \u00b7 5 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"active": true,
"kind": "chain",
"hint_fr": null
}
]
},
"meta_truncated": true,
"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": "discovery",
"ban_policy": "advisory_investigate",
"tags_list": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 15:42:01 UTC
TCP
8123 · HTTP
Sonde port 8123/TCP
port 8123 tcp · via HTTP:8123 · (sonde / probe)
Élevée
Faible · 38
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
6
Recommandation
Surveiller
Tags
950734:sap-sapcontrol-path
scanner-ua
anomaly:scanner-ua
http_ua_suspicious
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Preuve honeypot — Sonde port 8123/TCP
Connexion détectée sur le port 8123 (TCP) du capteur simulé.
Pourquoi cette classification : Type « port_8123_tcp » (signaux protocolaires) · confiance 55%
Confiance classification
55%
Risque capteur
Faible
· 38
Confiance : Confiance 55 % — Classification nommée non retenue — preuves insuffisantes · 2 tag(s) WAF
Protocole émulé
1
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Ligne de requête
GET /?query=SHOW%20DATABASES HTTP/1.1
User-Agent
curl/8
Règles WAF
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SHOW%20DATABASES HTTP/1.1
Accept-Encoding: identity
Host: 62.3.50.33:8123
User-Agent: curl/8
Connection: close
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "fdf86d4f1b483f5ec36c5f63c0d2edab7b9dddbb",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 130,
"payload_entropy": 5.193753464020308,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 32,
"risk_classification": 38,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 30,
"risk_boost": 0,
"risk_granularity": 1.9,
"risk_breakdown": {
"waf": 32,
"classification": 38,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 30
},
"risk_score": 38,
"tag_count": 5,
"anomaly_count": 1,
"campaign_key": "9fa83b631b47c2a330b4d59d07a14c0ec24c59e5",
"event_fingerprint": "12d54887e9b449f1412515f589d0a10f48748249",
"classification_reason": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%",
"confidence": 0.55,
"classification_confidence": 0.55,
"precision_score": 0,
"precision_signals": [],
"kb_rule_ids": [],
"confidence_breakdown": {
"waf": 32,
"classification": 38,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 30,
"risk_score": 38
},
"named_classification_skipped": true,
"named_candidate": "web_scanner",
"service_name": "http",
"risk_confidence_factor": 55,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "383ce9cbdaf89ac66638f09759e329f3",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 38
},
"payload_preview": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r\n",
"method": "GET",
"path": "\/",
"query_string": "query=SHOW%20DATABASES",
"user_agent": "curl\/8",
"waf_tags": [
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SHOW%20DATABASES HTTP\/1.1",
"request_sample": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r\n\r\n",
"payload_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SHOW%20DATABASES",
"user_agent": "curl\/8",
"waf_tags": [
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SHOW%20DATABASES HTTP\/1.1",
"request_sample": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r\n\r\n",
"payload_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"classification_reason": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"unknown"
],
"recommended_client_action": "monitor",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "bf9895a42d239499c071e79661527abe485813a5",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SHOW%20DATABASES HTTP\/1.1",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"attack_vector": "port 8123 tcp \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 55 % \u2014 Classification nomm\u00e9e non retenue \u2014 preuves insuffisantes \u00b7 2 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%",
"classification_reason_label_fr": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u00b7 risque 38\/100",
"confidence_pct": 55,
"confidence_breakdown": {
"waf": 32,
"classification": 38,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 30,
"risk_score": 38
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 38,
"risk_label": "Faible",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": null,
"tags_summary_labels_fr": null,
"recommended_action": "monitor",
"recommended_action_label": "Surveiller",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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=SHOW%20DATABASES HTTP\/1.1",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "port 8123 tcp \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 55 % \u2014 Classification nomm\u00e9e non retenue \u2014 preuves insuffisantes \u00b7 2 tag(s) WAF",
"confidence_factors_fr": "Confiance 55 % \u2014 Score WAF 32 \u00b7 2 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"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": "discovery",
"matched_patterns": [],
"ban_policy": "advisory_monitor",
"tags_list": [
"950734:sap-sapcontrol-path",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 15:23:20 UTC
TCP
8123 · HTTP
clickhouse probe
clickhouse probe · via HTTP:8123 · (sonde / probe)
Élevée
Moyen · 53
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
29
Recommandation
Investiguer
Tags
950005:sqli-1
950037:sqli-9
950325:rce-0
950734:sap-sapcontrol-path
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Pourquoi cette classification : Type « clickhouse_probe » (signaux protocolaires) · confiance 49%
Confiance classification
49%
Confiance modérée — signal unique
Risque capteur
Moyen
· 53
Confiance : Confiance 49 % — Motif catalogue confirmé · 5 tag(s) WAF
Protocole émulé
1 Signaux
pat-0737
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Motifs de détection (base)
ClickHouse query
Ligne de requête
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e
User-Agent
curl/8
Règles WAF
sqli-1
sqli-9
rce-0
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr
Requête brute (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "a188491183ce0f82cc9b34aec12281908fc1e44c",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 1015,
"payload_entropy": 5.025393174295087,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 100,
"risk_classification": 60,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 35,
"risk_boost": 0,
"risk_granularity": 3.2,
"risk_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35
},
"risk_score": 53,
"tag_count": 9,
"anomaly_count": 2,
"campaign_key": "e84efbc9ffcdb7d0dd5ae8251a2f0667c7a8bbf7",
"event_fingerprint": "7521f23b5d84c64f5123df59ca34b30117961fd4",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"confidence": 0.49,
"classification_confidence": 0.49,
"precision_score": 58,
"precision_signals": [
"pat-0737"
],
"kb_rule_ids": [
"pat-0737"
],
"matched_patterns": [
"pat-0737"
],
"matched_pattern_names": [
"ClickHouse query"
],
"pattern_ids": [
"pat-0737"
],
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 49,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "2607fcf4e9e07c0a33f5849c9df5ccef",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 53
},
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29epin%28",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29epin%28",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e",
"request_sample": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"scanner"
],
"recommended_client_action": "investigate",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "8740ea8e95aacbc11558983ac9e28ceea71ceac0",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"classification_reason_label_fr": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u2014 risque 53\/100 (Moyen) \u2014 MITRE TA0007 \u2014 confiance 49 % \u2014 via HTTP",
"confidence_pct": 49,
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 53,
"risk_label": "Moyen",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": [
"pat-0737"
],
"tags_summary_labels_fr": [
"pat-0737"
],
"recommended_action": "investigate",
"recommended_action_label": "Investiguer",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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": "Confiance mod\u00e9r\u00e9e \u2014 signal unique",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"confidence_factors_fr": "Confiance 49 % \u2014 Score WAF 100 \u00b7 5 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"active": true,
"kind": "chain",
"hint_fr": null
}
]
},
"meta_truncated": true,
"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": "discovery",
"ban_policy": "advisory_investigate",
"tags_list": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 14:54:58 UTC
TCP
8123 · HTTP
clickhouse probe
clickhouse probe · via HTTP:8123 · (sonde / probe)
Élevée
Moyen · 53
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
29
Recommandation
Investiguer
Tags
950005:sqli-1
950037:sqli-9
950325:rce-0
950734:sap-sapcontrol-path
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Pourquoi cette classification : Type « clickhouse_probe » (signaux protocolaires) · confiance 49%
Confiance classification
49%
Confiance modérée — signal unique
Risque capteur
Moyen
· 53
Confiance : Confiance 49 % — Motif catalogue confirmé · 5 tag(s) WAF
Protocole émulé
1 Signaux
pat-0737
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Motifs de détection (base)
ClickHouse query
Ligne de requête
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cwework%7Cwecom%7Cqq_bot%7Cbot_%29%27%29%20AND%20match%28lower%28name%29%2C%27%28token%7Csecret%7Ckey%7Cpassword%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2012 HTTP/1.1
User-Agent
curl/8
Règles WAF
sqli-1
sqli-9
rce-0
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cw
Requête brute (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cwework%7Cwecom%7Cqq_bot%7Cbot_%29%27%29%20AND%20match%28lower%28name%29%2C%27%28token%7Csecret%7Ckey%7Cpassword%29%27%29%20AND%20
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "aaf8da33cc3d5e9051aa0815616510372af95e59",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 465,
"payload_entropy": 5.209989831177737,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 100,
"risk_classification": 60,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 35,
"risk_boost": 0,
"risk_granularity": 3.2,
"risk_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35
},
"risk_score": 53,
"tag_count": 9,
"anomaly_count": 2,
"campaign_key": "e84efbc9ffcdb7d0dd5ae8251a2f0667c7a8bbf7",
"event_fingerprint": "d20e595c8767ddfa9cb9ba272fa0ad517bce7477",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"confidence": 0.49,
"classification_confidence": 0.49,
"precision_score": 58,
"precision_signals": [
"pat-0737"
],
"kb_rule_ids": [
"pat-0737"
],
"matched_patterns": [
"pat-0737"
],
"matched_pattern_names": [
"ClickHouse query"
],
"pattern_ids": [
"pat-0737"
],
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 49,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "e92447169129a844e1409ef968858fe1",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 53
},
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cwework%7Cwecom%7Cqq_bot%7Cbot_%29%27%29%20AND%20match%28lower%28name%29%2C%27%28token%7Csecret%7Ckey%7Cpassword%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2012",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cwework%7Cwecom%7Cqq_bot%7Cbot_%29%27%29%20AND%20match%28lower%28name%29%2C%27%28token%7Csecret%7Ckey%7Cpassword%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2012 HTTP\/1.1",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cw",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cwework%7Cwecom%7Cqq_bot%7Cbot_%29%27%29%20AND%20match%28lower%28name%29%2C%27%28token%7Csecret%7Ckey%7Cpassword%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2012",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cwework%7Cwecom%7Cqq_bot%7Cbot_%29%27%29%20AND%20match%28lower%28name%29%2C%27%28token%7Csecret%7Ckey%7Cpassword%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2012 HTTP\/1.1",
"request_sample": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cwework%7Cwecom%7Cqq_bot%7Cbot_%29%27%29%20AND%20match%28lower%28name%29%2C%27%28token%7Csecret%7Ckey%7Cpassword%29%27%29%20AND%20",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cw",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"scanner"
],
"recommended_client_action": "investigate",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "d78d7cb5dac0e8319f230f15723303b0cab564d6",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cwework%7Cwecom%7Cqq_bot%7Cbot_%29%27%29%20AND%20match%28lower%28name%29%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cw",
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"classification_reason_label_fr": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u2014 risque 53\/100 (Moyen) \u2014 MITRE TA0007 \u2014 confiance 49 % \u2014 via HTTP",
"confidence_pct": 49,
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 53,
"risk_label": "Moyen",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": [
"pat-0737"
],
"tags_summary_labels_fr": [
"pat-0737"
],
"recommended_action": "investigate",
"recommended_action_label": "Investiguer",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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": "Confiance mod\u00e9r\u00e9e \u2014 signal unique",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cwework%7Cwecom%7Cqq_bot%7Cbot_%29%27%29%20AND%20match%28lower%28name%29%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28robot%7Cwxid%7Cw",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"confidence_factors_fr": "Confiance 49 % \u2014 Score WAF 100 \u00b7 5 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"active": true,
"kind": "chain",
"hint_fr": null
}
]
},
"meta_truncated": true,
"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": "discovery",
"ban_policy": "advisory_investigate",
"tags_list": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 14:47:55 UTC
TCP
8123 · HTTP
clickhouse probe
clickhouse probe · via HTTP:8123 · (sonde / probe)
Élevée
Moyen · 53
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
29
Recommandation
Investiguer
Tags
950005:sqli-1
950037:sqli-9
950325:rce-0
950734:sap-sapcontrol-path
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Pourquoi cette classification : Type « clickhouse_probe » (signaux protocolaires) · confiance 49%
Confiance classification
49%
Confiance modérée — signal unique
Risque capteur
Moyen
· 53
Confiance : Confiance 49 % — Motif catalogue confirmé · 5 tag(s) WAF
Protocole émulé
1 Signaux
pat-0737
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Motifs de détection (base)
ClickHouse query
Ligne de requête
GET /?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28fb%7Cfacebook%7Cinstagram%7Ctiktok%7Cvk_%7Ctg_%7Ctelegram%7Cbot%7Cfarm%7Caccount%7Cacc_%7Csocial%29%27%29%20AND%20match%28lower%28name%29%2C%27%28password%7Ccookie%7Csession%7Ctoken%7Csecret%7Cauth_key%7Cprivate%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20GROUP%20BY%20database%2Ctable%20LIMIT%2020 HTTP/1.1
User-Agent
curl/8
Règles WAF
sqli-1
sqli-9
rce-0
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28
Requête brute (extrait)
GET /?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28fb%7Cfacebook%7Cinstagram%7Ctiktok%7Cvk_%7Ctg_%7Ctelegram%7Cbot%7Cfarm%7Caccount%7Cacc_%7Csocial%29%27%29%20AND%20match%28lower%
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "7a3425f9f03afe1b5ab1ea5ea3ea92b48e9263df",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 598,
"payload_entropy": 5.182841353235583,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 100,
"risk_classification": 60,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 35,
"risk_boost": 0,
"risk_granularity": 3.2,
"risk_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35
},
"risk_score": 53,
"tag_count": 9,
"anomaly_count": 2,
"campaign_key": "e84efbc9ffcdb7d0dd5ae8251a2f0667c7a8bbf7",
"event_fingerprint": "ffb9af41ae5b50cf74585266abff6657b9502ab9",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"confidence": 0.49,
"classification_confidence": 0.49,
"precision_score": 58,
"precision_signals": [
"pat-0737"
],
"kb_rule_ids": [
"pat-0737"
],
"matched_patterns": [
"pat-0737"
],
"matched_pattern_names": [
"ClickHouse query"
],
"pattern_ids": [
"pat-0737"
],
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 49,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "89d4a00b3857b77a5378c5293ecd268d",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 53
},
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28fb%7Cfacebook%7Cinstagram%7Ctiktok%7Cvk_%7Ctg_%7Ctelegram%7Cbot%7Cfarm%7Caccount%7Cacc_%7Csocial%29%27%29%20AND%20match%28lower%28name%29%2C%27%28password%7Ccookie%7Csession%7Ctoken%7Csecret%7Cauth_key%7Cprivate%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20GROUP%20BY%20database%2Ctable%20LIMIT%2020",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28fb%7Cfacebook%7Cinstagram%7Ctiktok%7Cvk_%7Ctg_%7Ctelegram%7Cbot%7Cfarm%7Caccount%7Cacc_%7Csocial%29%27%29%20AND%20match%28lower%28name%29%2C%27%28password%7Ccookie%7Csession%7Ctoken%7Csecret%7Cauth_key%7Cprivate%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20GROUP%20BY%20database%2Ctable%20LIMIT%2020 HTTP\/1.1",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28fb%7Cfacebook%7Cinstagram%7Ctiktok%7Cvk_%7Ctg_%7Ctelegram%7Cbot%7Cfarm%7Caccount%7Cacc_%7Csocial%29%27%29%20AND%20match%28lower%28name%29%2C%27%28password%7Ccookie%7Csession%7Ctoken%7Csecret%7Cauth_key%7Cprivate%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20GROUP%20BY%20database%2Ctable%20LIMIT%2020",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28fb%7Cfacebook%7Cinstagram%7Ctiktok%7Cvk_%7Ctg_%7Ctelegram%7Cbot%7Cfarm%7Caccount%7Cacc_%7Csocial%29%27%29%20AND%20match%28lower%28name%29%2C%27%28password%7Ccookie%7Csession%7Ctoken%7Csecret%7Cauth_key%7Cprivate%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20GROUP%20BY%20database%2Ctable%20LIMIT%2020 HTTP\/1.1",
"request_sample": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28fb%7Cfacebook%7Cinstagram%7Ctiktok%7Cvk_%7Ctg_%7Ctelegram%7Cbot%7Cfarm%7Caccount%7Cacc_%7Csocial%29%27%29%20AND%20match%28lower%",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"scanner"
],
"recommended_client_action": "investigate",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "ed156d795c6c28c998e374a761877a093edb5115",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28fb%7Cfacebook%7Cinstagram%7Ctiktok%7Cvk_%7Ctg_%7Ctelegram%7Cbot%7Cfarm%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28",
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"classification_reason_label_fr": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u2014 risque 53\/100 (Moyen) \u2014 MITRE TA0007 \u2014 confiance 49 % \u2014 via HTTP",
"confidence_pct": 49,
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 53,
"risk_label": "Moyen",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": [
"pat-0737"
],
"tags_summary_labels_fr": [
"pat-0737"
],
"recommended_action": "investigate",
"recommended_action_label": "Investiguer",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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": "Confiance mod\u00e9r\u00e9e \u2014 signal unique",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28fb%7Cfacebook%7Cinstagram%7Ctiktok%7Cvk_%7Ctg_%7Ctelegram%7Cbot%7Cfarm%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20match%28lower%28table%29%2C%27%28",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"confidence_factors_fr": "Confiance 49 % \u2014 Score WAF 100 \u00b7 5 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"active": true,
"kind": "chain",
"hint_fr": null
}
]
},
"meta_truncated": true,
"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": "discovery",
"ban_policy": "advisory_investigate",
"tags_list": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 14:34:49 UTC
TCP
8123 · HTTP
clickhouse probe
clickhouse probe · via HTTP:8123 · (sonde / probe)
Élevée
Moyen · 53
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
29
Recommandation
Investiguer
Tags
950005:sqli-1
950037:sqli-9
950325:rce-0
950734:sap-sapcontrol-path
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Pourquoi cette classification : Type « clickhouse_probe » (signaux protocolaires) · confiance 49%
Confiance classification
49%
Confiance modérée — signal unique
Risque capteur
Moyen
· 53
Confiance : Confiance 49 % — Motif catalogue confirmé · 5 tag(s) WAF
Protocole émulé
1 Signaux
pat-0737
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Motifs de détection (base)
ClickHouse query
Ligne de requête
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e
User-Agent
curl/8
Règles WAF
sqli-1
sqli-9
rce-0
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr
Requête brute (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "a188491183ce0f82cc9b34aec12281908fc1e44c",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 1015,
"payload_entropy": 5.025393174295087,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 100,
"risk_classification": 60,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 35,
"risk_boost": 0,
"risk_granularity": 3.2,
"risk_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35
},
"risk_score": 53,
"tag_count": 9,
"anomaly_count": 2,
"campaign_key": "e84efbc9ffcdb7d0dd5ae8251a2f0667c7a8bbf7",
"event_fingerprint": "7521f23b5d84c64f5123df59ca34b30117961fd4",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"confidence": 0.49,
"classification_confidence": 0.49,
"precision_score": 58,
"precision_signals": [
"pat-0737"
],
"kb_rule_ids": [
"pat-0737"
],
"matched_patterns": [
"pat-0737"
],
"matched_pattern_names": [
"ClickHouse query"
],
"pattern_ids": [
"pat-0737"
],
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 49,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "2607fcf4e9e07c0a33f5849c9df5ccef",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 53
},
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29epin%28",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29epin%28",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%7Ctax_lot%7Crealized_gain%7Cform8949%7Ckoinly%7Ctokentax%7Ccointracker%7Ccard_number%7C%28%5E%7C_%29cvv%28_%7C%24%29%7Cpassword_digest%7Cpass_code%7Capi_secret%7Cwallet_priv%7Csession_token%7C%28%5E%7C_%29ssn%28_%7C%24%29%7Cssnit%7Cvoucher%7C%28%5E%7C_%29e",
"request_sample": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%7Csecret_key%7Cpassport%7Cnational_id%7Cssn%7Ccost_basis%",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"scanner"
],
"recommended_client_action": "investigate",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "8740ea8e95aacbc11558983ac9e28ceea71ceac0",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"classification_reason_label_fr": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u2014 risque 53\/100 (Moyen) \u2014 MITRE TA0007 \u2014 confiance 49 % \u2014 via HTTP",
"confidence_pct": 49,
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 53,
"risk_label": "Moyen",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": [
"pat-0737"
],
"tags_summary_labels_fr": [
"pat-0737"
],
"recommended_action": "investigate",
"recommended_action_label": "Investiguer",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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": "Confiance mod\u00e9r\u00e9e \u2014 signal unique",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cprivate_key%7Cmnemonic%7Cseed_phrase%7Cseed_key%7Ckeystore%7Csigning_key%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27moonshot%7Ckimi%7Cpr",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"confidence_factors_fr": "Confiance 49 % \u2014 Score WAF 100 \u00b7 5 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"active": true,
"kind": "chain",
"hint_fr": null
}
]
},
"meta_truncated": true,
"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": "discovery",
"ban_policy": "advisory_investigate",
"tags_list": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 14:32:33 UTC
TCP
8123 · HTTP
Sonde port 8123/TCP
port 8123 tcp · via HTTP:8123 · (sonde / probe)
Élevée
Faible · 38
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
6
Recommandation
Surveiller
Tags
950734:sap-sapcontrol-path
scanner-ua
anomaly:scanner-ua
http_ua_suspicious
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Preuve honeypot — Sonde port 8123/TCP
Connexion détectée sur le port 8123 (TCP) du capteur simulé.
Pourquoi cette classification : Type « port_8123_tcp » (signaux protocolaires) · confiance 55%
Confiance classification
55%
Risque capteur
Faible
· 38
Confiance : Confiance 55 % — Classification nommée non retenue — preuves insuffisantes · 2 tag(s) WAF
Protocole émulé
1
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Ligne de requête
GET /?query=SHOW%20DATABASES HTTP/1.1
User-Agent
curl/8
Règles WAF
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SHOW%20DATABASES HTTP/1.1
Accept-Encoding: identity
Host: 62.3.50.33:8123
User-Agent: curl/8
Connection: close
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "fdf86d4f1b483f5ec36c5f63c0d2edab7b9dddbb",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 130,
"payload_entropy": 5.193753464020308,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 32,
"risk_classification": 38,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 30,
"risk_boost": 0,
"risk_granularity": 1.9,
"risk_breakdown": {
"waf": 32,
"classification": 38,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 30
},
"risk_score": 38,
"tag_count": 5,
"anomaly_count": 1,
"campaign_key": "9fa83b631b47c2a330b4d59d07a14c0ec24c59e5",
"event_fingerprint": "12d54887e9b449f1412515f589d0a10f48748249",
"classification_reason": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%",
"confidence": 0.55,
"classification_confidence": 0.55,
"precision_score": 0,
"precision_signals": [],
"kb_rule_ids": [],
"confidence_breakdown": {
"waf": 32,
"classification": 38,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 30,
"risk_score": 38
},
"named_classification_skipped": true,
"named_candidate": "web_scanner",
"service_name": "http",
"risk_confidence_factor": 55,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "383ce9cbdaf89ac66638f09759e329f3",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 38
},
"payload_preview": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r\n",
"method": "GET",
"path": "\/",
"query_string": "query=SHOW%20DATABASES",
"user_agent": "curl\/8",
"waf_tags": [
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SHOW%20DATABASES HTTP\/1.1",
"request_sample": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r\n\r\n",
"payload_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SHOW%20DATABASES",
"user_agent": "curl\/8",
"waf_tags": [
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SHOW%20DATABASES HTTP\/1.1",
"request_sample": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r\n\r\n",
"payload_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"classification_reason": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"unknown"
],
"recommended_client_action": "monitor",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "bf9895a42d239499c071e79661527abe485813a5",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SHOW%20DATABASES HTTP\/1.1",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"attack_vector": "port 8123 tcp \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 55 % \u2014 Classification nomm\u00e9e non retenue \u2014 preuves insuffisantes \u00b7 2 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%",
"classification_reason_label_fr": "Type \u00ab port_8123_tcp \u00bb (signaux protocolaires) \u00b7 confiance 55%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u00b7 risque 38\/100",
"confidence_pct": 55,
"confidence_breakdown": {
"waf": 32,
"classification": 38,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 30,
"risk_score": 38
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 38,
"risk_label": "Faible",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": null,
"tags_summary_labels_fr": null,
"recommended_action": "monitor",
"recommended_action_label": "Surveiller",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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=SHOW%20DATABASES HTTP\/1.1",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "port 8123 tcp \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SHOW%20DATABASES HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 55 % \u2014 Classification nomm\u00e9e non retenue \u2014 preuves insuffisantes \u00b7 2 tag(s) WAF",
"confidence_factors_fr": "Confiance 55 % \u2014 Score WAF 32 \u00b7 2 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"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": "discovery",
"matched_patterns": [],
"ban_policy": "advisory_monitor",
"tags_list": [
"950734:sap-sapcontrol-path",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 14:20:15 UTC
TCP
8123 · HTTP
clickhouse probe
clickhouse probe · via HTTP:8123 · (sonde / probe)
Élevée
Moyen · 53
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
29
Recommandation
Investiguer
Tags
950005:sqli-1
950037:sqli-9
950325:rce-0
950734:sap-sapcontrol-path
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Pourquoi cette classification : Type « clickhouse_probe » (signaux protocolaires) · confiance 49%
Confiance classification
49%
Confiance modérée — signal unique
Risque capteur
Moyen
· 53
Confiance : Confiance 49 % — Motif catalogue confirmé · 5 tag(s) WAF
Protocole émulé
1 Signaux
pat-0737
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Motifs de détection (base)
ClickHouse query
Ligne de requête
GET /?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Ctopup%7Ctop_up%7Cpoint_card%7Ccharge_card%7Cdianka%7Cdk_%7Cgamecard%7Cgame_card%7Ctime_card%7Cmonth_card%7Cseason_card%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20total_rows%20%3E%2020%20LIMIT%2012 HTTP/1.1
User-Agent
curl/8
Règles WAF
sqli-1
sqli-9
rce-0
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Cto
Requête brute (extrait)
GET /?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Ctopup%7Ctop_up%7Cpoint_card%7Ccharge_card%7Cdianka%7Cdk_%7Cgamecard%7Cgame_card%7Ctime_card%7Cmonth_card%7Cseason_card%29%27%29%20
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "e69d8352d97c4ee829312ff2c226518f9f713c50",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 501,
"payload_entropy": 5.216773495164399,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 100,
"risk_classification": 60,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 35,
"risk_boost": 0,
"risk_granularity": 3.2,
"risk_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35
},
"risk_score": 53,
"tag_count": 9,
"anomaly_count": 2,
"campaign_key": "e84efbc9ffcdb7d0dd5ae8251a2f0667c7a8bbf7",
"event_fingerprint": "3d663211d76690a87bbcef0f1adab85c8986edfb",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"confidence": 0.49,
"classification_confidence": 0.49,
"precision_score": 58,
"precision_signals": [
"pat-0737"
],
"kb_rule_ids": [
"pat-0737"
],
"matched_patterns": [
"pat-0737"
],
"matched_pattern_names": [
"ClickHouse query"
],
"pattern_ids": [
"pat-0737"
],
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 49,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "9b9640aa0e0ad14bfa0d38a26303604e",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 53
},
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Ctopup%7Ctop_up%7Cpoint_card%7Ccharge_card%7Cdianka%7Cdk_%7Cgamecard%7Cgame_card%7Ctime_card%7Cmonth_card%7Cseason_card%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20total_rows%20%3E%2020%20LIMIT%2012",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Ctopup%7Ctop_up%7Cpoint_card%7Ccharge_card%7Cdianka%7Cdk_%7Cgamecard%7Cgame_card%7Ctime_card%7Cmonth_card%7Cseason_card%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20total_rows%20%3E%2020%20LIMIT%2012 HTTP\/1.1",
"payload_snippet": "GET \/?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Cto",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Ctopup%7Ctop_up%7Cpoint_card%7Ccharge_card%7Cdianka%7Cdk_%7Cgamecard%7Cgame_card%7Ctime_card%7Cmonth_card%7Cseason_card%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20total_rows%20%3E%2020%20LIMIT%2012",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Ctopup%7Ctop_up%7Cpoint_card%7Ccharge_card%7Cdianka%7Cdk_%7Cgamecard%7Cgame_card%7Ctime_card%7Cmonth_card%7Cseason_card%29%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20total_rows%20%3E%2020%20LIMIT%2012 HTTP\/1.1",
"request_sample": "GET \/?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Ctopup%7Ctop_up%7Cpoint_card%7Ccharge_card%7Cdianka%7Cdk_%7Cgamecard%7Cgame_card%7Ctime_card%7Cmonth_card%7Cseason_card%29%27%29%20",
"payload_snippet": "GET \/?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Cto",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"scanner"
],
"recommended_client_action": "investigate",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "541c1c85c1be2a9dde2764fa05e360438e093c62",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Ctopup%7Ctop_up%7Cpoint_card%7Ccharge_card%7Cdianka%7Cdk_%7Cgamecard%7Cgam\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Cto",
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"classification_reason_label_fr": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u2014 risque 53\/100 (Moyen) \u2014 MITRE TA0007 \u2014 confiance 49 % \u2014 via HTTP",
"confidence_pct": 49,
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 53,
"risk_label": "Moyen",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": [
"pat-0737"
],
"tags_summary_labels_fr": [
"pat-0737"
],
"recommended_action": "investigate",
"recommended_action_label": "Investiguer",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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": "Confiance mod\u00e9r\u00e9e \u2014 signal unique",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Ctopup%7Ctop_up%7Cpoint_card%7Ccharge_card%7Cdianka%7Cdk_%7Cgamecard%7Cgam\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SELECT%20database%2Cname%2Ctotal_rows%20FROM%20system.tables%20WHERE%20match%28lower%28name%29%2C%27%28recharge%7Cto",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"confidence_factors_fr": "Confiance 49 % \u2014 Score WAF 100 \u00b7 5 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"active": true,
"kind": "chain",
"hint_fr": null
}
]
},
"meta_truncated": true,
"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": "discovery",
"ban_policy": "advisory_investigate",
"tags_list": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}
27/07/2026 14:17:49 UTC
TCP
8123 · HTTP
clickhouse probe
clickhouse probe · via HTTP:8123 · (sonde / probe)
Élevée
Moyen · 53
Détails
Voir
Étape
Sonde / probe
Chaîne
Découverte
Persona
mail.sensor-1.internal
Rôle capteur
Renseignement menaces
MITRE
TA0007
TA0007
TA0001
Protocole
GET / UA curl/8
Émulateur
HTTP
WAF
29
Recommandation
Investiguer
Tags
950005:sqli-1
950037:sqli-9
950325:rce-0
950734:sap-sapcontrol-path
Cible HTTP
GET
/
TLS SNI
—
Capteur
paris-1
Méthode
GET
Port
8123
Chemin / cible
/
Pourquoi cette classification : Type « clickhouse_probe » (signaux protocolaires) · confiance 49%
Confiance classification
49%
Confiance modérée — signal unique
Risque capteur
Moyen
· 53
Confiance : Confiance 49 % — Motif catalogue confirmé · 5 tag(s) WAF
Protocole émulé
1 Signaux
pat-0737
Technique MITRE
TA0007
Tactiques MITRE
TA0007
TA0001
Motifs de détection (base)
ClickHouse query
Ligne de requête
GET /?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20%28match%28lower%28name%29%2C%27%28license%7Cgift_code%7Credeem_code%7Ccdkey%7Ccard_code%7Cpin_code%7Cserial_no%7Ckey_code%7Ccard_no%29%27%29%29%20GROUP%20BY%20database%2Ctable%20LIMIT%2020 HTTP/1.1
User-Agent
curl/8
Règles WAF
sqli-1
sqli-9
rce-0
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27syste
Requête brute (extrait)
GET /?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20%28match%28lower%28name%29%2C%27%28license%7Cgift_code%7Cr
Meta JSON brut
{
"protocol_emulated": true,
"emulator_response": "485454502f312e3120323030204f4b0d0a5365727665723a204170616368652f322e342e35370d0a436f6e74656e742d4c656e6774683a20320d0a436f6e6e656374696f6e3a20636c6f73650d0a0d0a4f4b",
"emulator_response_len": 82,
"http_header_count": 4,
"http_query_params": 1,
"http_path_depth": 0,
"http_path_ext": null,
"http_ua_hash": "a13d219e5ded760716f5952758285c6f6a575108",
"http_host_hash": "15f4f9799fa92d8e7e5cb90724eb1ec2b33ec46f",
"http_target_hash": "e37568bcd616fddf5bd2ce8cabc9152baa0e9cd6",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 489,
"payload_entropy": 5.237979144583702,
"port_category": "registered",
"org": "HostRoyale Technologies Pvt Ltd",
"service": "http",
"app_proto": "http",
"asn": 203020,
"country": "ES",
"dst_port": 8123,
"risk_waf": 100,
"risk_classification": 60,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 35,
"risk_boost": 0,
"risk_granularity": 3.2,
"risk_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35
},
"risk_score": 53,
"tag_count": 9,
"anomaly_count": 2,
"campaign_key": "e84efbc9ffcdb7d0dd5ae8251a2f0667c7a8bbf7",
"event_fingerprint": "f6617bcfd058b878e5a7000c2b95b045d96605ad",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"confidence": 0.49,
"classification_confidence": 0.49,
"precision_score": 58,
"precision_signals": [
"pat-0737"
],
"kb_rule_ids": [
"pat-0737"
],
"matched_patterns": [
"pat-0737"
],
"matched_pattern_names": [
"ClickHouse query"
],
"pattern_ids": [
"pat-0737"
],
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 49,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "ES",
"asn": 203020,
"org": "HostRoyale Technologies Pvt Ltd",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "6a5547703c75a570fb82555cbcadbe02",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 53
},
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20%28match%28lower%28name%29%2C%27%28license%7Cgift_code%7Credeem_code%7Ccdkey%7Ccard_code%7Cpin_code%7Cserial_no%7Ckey_code%7Ccard_no%29%27%29%29%20GROUP%20BY%20database%2Ctable%20LIMIT%2020",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20%28match%28lower%28name%29%2C%27%28license%7Cgift_code%7Credeem_code%7Ccdkey%7Ccard_code%7Cpin_code%7Cserial_no%7Ckey_code%7Ccard_no%29%27%29%29%20GROUP%20BY%20database%2Ctable%20LIMIT%2020 HTTP\/1.1",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27syste",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20%28match%28lower%28name%29%2C%27%28license%7Cgift_code%7Credeem_code%7Ccdkey%7Ccard_code%7Cpin_code%7Cserial_no%7Ckey_code%7Ccard_no%29%27%29%29%20GROUP%20BY%20database%2Ctable%20LIMIT%2020",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"sqli-9",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20%28match%28lower%28name%29%2C%27%28license%7Cgift_code%7Credeem_code%7Ccdkey%7Ccard_code%7Cpin_code%7Cserial_no%7Ckey_code%7Ccard_no%29%27%29%29%20GROUP%20BY%20database%2Ctable%20LIMIT%2020 HTTP\/1.1",
"request_sample": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20%28match%28lower%28name%29%2C%27%28license%7Cgift_code%7Cr",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27syste",
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%"
},
"attack_stage": "probe",
"mitre_tactics": [
"TA0007",
"TA0001"
],
"mitre": "TA0007",
"threat_family": [
"scanner"
],
"recommended_client_action": "investigate",
"policy_mode": "intelligence",
"sensor_role": "threat_intelligence",
"event_signature": "f757fe102d65065ae0602441e59c79db234c0ba3",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27syste",
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"site_display": {
"classification": null,
"classification_reason": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"classification_reason_label_fr": "Type \u00ab clickhouse_probe \u00bb (signaux protocolaires) \u00b7 confiance 49%",
"executive_one_liner_fr": "Activit\u00e9 suspecte \u2014 risque 53\/100 (Moyen) \u2014 MITRE TA0007 \u2014 confiance 49 % \u2014 via HTTP",
"confidence_pct": 49,
"confidence_breakdown": {
"waf": 100,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 53
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 53,
"risk_label": "Moyen",
"service_name": "http",
"service_label_fr": "HTTP",
"dst_port": 8123,
"protocol_emulated": true,
"tags_summary": [
"pat-0737"
],
"tags_summary_labels_fr": [
"pat-0737"
],
"recommended_action": "investigate",
"recommended_action_label": "Investiguer",
"mitre": "TA0007",
"mitre_technique": "TA0007",
"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": "Confiance mod\u00e9r\u00e9e \u2014 signal unique",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20AND%20%\u2026",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"attack_vector": "clickhouse probe \u00b7 via HTTP:8123 \u00b7 (sonde \/ probe)",
"evidence_snippet": "GET \/?query=SELECT%20database%2Ctable%2CgroupArray%28name%29%20FROM%20system.columns%20WHERE%20database%20NOT%20IN%20%28%27syste",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 5 tag(s) WAF",
"confidence_factors_fr": "Confiance 49 % \u2014 Score WAF 100 \u00b7 5 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": true,
"kind": "stage"
},
{
"key": "exploit_attempt",
"label_fr": "Tentative d'exploit",
"active": false,
"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": "discovery",
"label_fr": "D\u00e9couverte",
"active": true,
"kind": "chain",
"hint_fr": null
}
]
},
"meta_truncated": true,
"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": "discovery",
"ban_policy": "advisory_investigate",
"tags_list": [
"950005:sqli-1",
"950037:sqli-9",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}