22/07/2026 00:25:28 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%27api_secret%7Csecret_key%7Cprivate_key%7Cexchange%7Cbinance%7Cbybit%7Cokx%7Cokex%7Ckucoin%7Cbitget%7Cgateio%7Cwithdraw%7Cbot_token%7Ctrading%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2030 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%27api_secret%7Csecret_
Requête brute (extrait)
GET /?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27api_secret%7Csecret_key%7Cprivate_key%7Cexchange%7Cbinance%7Cbybit%7Cokx%7Cokex%7Ckucoin%7Cbitget%7Cgateio%7Cwithdraw%7Cbot_token%7Ctrading%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": "3911f3bcc41a4a114706ce3557e5fcc091d32e54",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 471,
"payload_entropy": 5.272376694926496,
"port_category": "registered",
"org": "Private Layer INC",
"service": "http",
"app_proto": "http",
"asn": 51852,
"country": "CH",
"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": "3abb0162e73ee371eb0fd97ea3987b717ce4c6fb",
"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": "CH",
"asn": 51852,
"org": "Private Layer INC",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "6ce2baebca5968dc3b5d892f30d81af1",
"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%27api_secret%7Csecret_key%7Cprivate_key%7Cexchange%7Cbinance%7Cbybit%7Cokx%7Cokex%7Ckucoin%7Cbitget%7Cgateio%7Cwithdraw%7Cbot_token%7Ctrading%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2030",
"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%27api_secret%7Csecret_key%7Cprivate_key%7Cexchange%7Cbinance%7Cbybit%7Cokx%7Cokex%7Ckucoin%7Cbitget%7Cgateio%7Cwithdraw%7Cbot_token%7Ctrading%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2030 HTTP\/1.1",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27api_secret%7Csecret_",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27api_secret%7Csecret_key%7Cprivate_key%7Cexchange%7Cbinance%7Cbybit%7Cokx%7Cokex%7Ckucoin%7Cbitget%7Cgateio%7Cwithdraw%7Cbot_token%7Ctrading%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2030",
"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%27api_secret%7Csecret_key%7Cprivate_key%7Cexchange%7Cbinance%7Cbybit%7Cokx%7Cokex%7Ckucoin%7Cbitget%7Cgateio%7Cwithdraw%7Cbot_token%7Ctrading%27%29%20AND%20database%20NOT%20IN%20%28%27system%27%2C%27INFORMATION_SCHEMA%27%2C%27information_schema%27%29%20LIMIT%2030 HTTP\/1.1",
"request_sample": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27api_secret%7Csecret_key%7Cprivate_key%7Cexchange%7Cbinance%7Cbybit%7Cokx%7Cokex%7Ckucoin%7Cbitget%7Cgateio%7Cwithdraw%7Cbot_token%7Ctrading%27%29%20",
"payload_snippet": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27api_secret%7Csecret_",
"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": "be4659a961563d46af5cca4ad34cb47e123b3f95",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2Ctable%2Cname%20FROM%20system.columns%20WHERE%20match%28lower%28name%29%2C%27api_secret%7Csecret_key%7Cprivate_key%7Cexchange%7Cbinance%7Cbybit%7Cokx%7Cokex%7Ckucoin%7C\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%27api_secret%7Csecret_",
"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%27api_secret%7Csecret_key%7Cprivate_key%7Cexchange%7Cbinance%7Cbybit%7Cokx%7Cokex%7Ckucoin%7C\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%27api_secret%7Csecret_",
"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"
]
}
21/07/2026 22:23:10 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": "Private Layer INC",
"service": "http",
"app_proto": "http",
"asn": 51852,
"country": "CH",
"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": "CH",
"asn": 51852,
"org": "Private Layer INC",
"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"
],
"behavior_alert_count": 1,
"behavior_priority": 72
}
21/07/2026 22:23:10 UTC
TCP
8123 · HTTP
clickhouse probe
clickhouse probe · via HTTP:8123 · (sonde / probe)
Élevée
Moyen · 51
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
22
Recommandation
Investiguer
Tags
950005:sqli-1
950325:rce-0
950734:sap-sapcontrol-path
scanner-ua
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
· 51
Confiance : Confiance 49 % — Motif catalogue confirmé · 4 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%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20total_rows%20DESC%20LIMIT%208 HTTP/1.1
User-Agent
curl/8
Règles WAF
sqli-1
rce-0
sap-sapcontrol-path
scanner-ua
Payload (extrait)
GET /?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20
Requête brute (extrait)
GET /?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20total_rows%20DESC%20LIMIT%208 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": "799a879562cc281bc8aa20e41c4c403edb8b9c92",
"http_referer_hash": null,
"http_method": "GET",
"http_ua_is_cli": true,
"http_ua_is_browser": false,
"bytes_in": 259,
"payload_entropy": 5.267444162365034,
"port_category": "registered",
"org": "Private Layer INC",
"service": "http",
"app_proto": "http",
"asn": 51852,
"country": "CH",
"dst_port": 8123,
"risk_waf": 96,
"risk_classification": 60,
"risk_behavior": 0,
"risk_geo": 0,
"risk_protocol": 43,
"risk_novelty": 35,
"risk_boost": 0,
"risk_granularity": 3,
"risk_breakdown": {
"waf": 96,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35
},
"risk_score": 51,
"tag_count": 8,
"anomaly_count": 2,
"campaign_key": "3b21d29d522675d4a5c5a12850038bc315885938",
"event_fingerprint": "06a320928f0c0654399081114401a86a537ff636",
"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": 96,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 51
},
"named_classification_skipped": false,
"service_name": "http",
"risk_confidence_factor": 49,
"city": null,
"is_datacenter": false,
"is_tor_hint": false,
"geo": {
"country": "CH",
"asn": 51852,
"org": "Private Layer INC",
"is_datacenter": false,
"is_tor_hint": false
},
"fingerprint": {
"http_ua_hash": "d26c0650abb48cff3c037b137b03713f",
"payload_hash": "0f76a8ba87efddfbf0dee6e709d86b17",
"path_pattern_hash": "8a5edab282632443219e051e4ade2d1d"
},
"target_context": {
"dst_port": 8123,
"service": "http",
"service_name": "http",
"risk_score": 51
},
"payload_preview": "GET \/?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20",
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20total_rows%20DESC%20LIMIT%208",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20total_rows%20DESC%20LIMIT%208 HTTP\/1.1",
"request_sample": "GET \/?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20total_rows%20DESC%20LIMIT%208 HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r",
"payload_snippet": "GET \/?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20",
"evidence": {
"method": "GET",
"path": "\/",
"query_string": "query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20total_rows%20DESC%20LIMIT%208",
"user_agent": "curl\/8",
"waf_tags": [
"950005:sqli-1",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"scanner-ua"
],
"waf_rule_names": [
"sqli-1",
"rce-0",
"sap-sapcontrol-path",
"scanner-ua"
],
"request_line": "GET \/?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20total_rows%20DESC%20LIMIT%208 HTTP\/1.1",
"request_sample": "GET \/?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20total_rows%20DESC%20LIMIT%208 HTTP\/1.1\r\nAccept-Encoding: identity\r\nHost: 62.3.50.33:8123\r\nUser-Agent: curl\/8\r\nConnection: close\r",
"payload_snippet": "GET \/?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20",
"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": "f531ede75b89a4e127bac871c310007ad1cab161",
"protocol_details": {
"http_method": "GET",
"http_path": "\/",
"request_line": "GET \/?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20total_rows%20DESC%20LIMIT%208 HTTP\/1.1",
"http_user_agent": "curl\/8",
"port": 8123,
"service": "http",
"service_label_fr": "HTTP"
},
"evidence_snippet": "GET \/?query=SELECT%20database%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20",
"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 4 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 51\/100 (Moyen) \u2014 MITRE TA0007 \u2014 confiance 49 % \u2014 via HTTP",
"confidence_pct": 49,
"confidence_breakdown": {
"waf": 96,
"classification": 60,
"behavior": 0,
"geo": 0,
"protocol": 43,
"novelty": 35,
"risk_score": 51
},
"attack_stage": "probe",
"attack_stage_label": "Sonde \/ probe",
"attack_chain_stage": "discovery",
"attack_chain_stage_label_fr": "D\u00e9couverte",
"risk_score": 51,
"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%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20total_rows%20DESC%20LIMIT%208 HTTP\/1.1",
"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%2C%20name%2C%20total_rows%20FROM%20system.tables%20WHERE%20total_rows%20%3E%205000%20ORDER%20BY%20",
"target_port_label": "8123 \u00b7 HTTP",
"emulator_service": "http",
"confidence_reason": "Confiance 49 % \u2014 Motif catalogue confirm\u00e9 \u00b7 4 tag(s) WAF",
"confidence_factors_fr": "Confiance 49 % \u2014 Score WAF 96 \u00b7 4 tag(s) WAF",
"campaign_hint_fr": null,
"attack_phases_timeline_fr": [
{
"key": "recon",
"label_fr": "Reconnaissance",
"active": false,
"kind": "stage"
},
{
"key": "probe",
"label_fr": "Sonde \/ probe",
"active": 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",
"950325:rce-0",
"950734:sap-sapcontrol-path",
"anomaly:high-entropy-query",
"anomaly:scanner-ua",
"http_ua_suspicious",
"net_web_probe",
"scanner-ua"
]
}