Debian Codegraph @

hub1/.tests/pgsql-logs/parser.assert

raw
1 len(results["s01-parse"]["crowdsecurity/pgsql-logs"]) == 6
2 results["s00-raw"]["crowdsecurity/non-syslog"][0].Success == true
3 results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Parsed["message"] == "2021-09-28 09:22:18.536 UTC [147] 1.2.3.4 i_dont_exist@postgres FATAL: password authentication failed for user \"i_dont_exist\""
4 results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Parsed["program"] == "postgres"
5 results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Meta["datasource_path"] == "pgsql-logs.log"
6 results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Meta["datasource_type"] == "file"
7 results["s00-raw"]["crowdsecurity/non-syslog"][1].Success == true
8 results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Parsed["message"] == "2021-09-28 09:22:19.536 UTC:1.2.3.4(5432):i_dont_exist@postgres:[127]:FATAL: password authentication failed for user \"i_dont_exist\""
9 results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Parsed["program"] == "postgres"
10 results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Meta["datasource_type"] == "file"
11 results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Meta["datasource_path"] == "pgsql-logs.log"
12 results["s00-raw"]["crowdsecurity/syslog-logs"][0].Success == false
13 results["s00-raw"]["crowdsecurity/syslog-logs"][1].Success == false
14 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Success == true
15 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Parsed["timestamp"] == "21-09-28 09:22:18.536"
16 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Parsed["zone"] == "UTC"
17 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Parsed["PID"] == "147"
18 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Parsed["pgsql_dbname"] == "postgres"
19 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Parsed["pgsql_target_user"] == "i_dont_exist"
20 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Parsed["program"] == "postgres"
21 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Parsed["source_ip"] == "1.2.3.4"
22 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Parsed["auth_method"] == "password"
23 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Parsed["message"] == "2021-09-28 09:22:18.536 UTC [147] 1.2.3.4 i_dont_exist@postgres FATAL: password authentication failed for user \"i_dont_exist\""
24 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Parsed["pgsql_user"] == "i_dont_exist"
25 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Meta["log_type"] == "pgsql_failed_auth"
26 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Meta["source_ip"] == "1.2.3.4"
27 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Meta["user"] == "i_dont_exist"
28 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Meta["auth_method"] == "password"
29 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Meta["datasource_path"] == "pgsql-logs.log"
30 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Meta["datasource_type"] == "file"
31 results["s01-parse"]["crowdsecurity/pgsql-logs"][0].Evt.Meta["db"] == "postgres"
32 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Success == true
33 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["pgsql_user"] == "i_dont_exist"
34 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["program"] == "postgres"
35 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["zone"] == "UTC"
36 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["source_ip"] == "1.2.3.4"
37 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["source_port"] == "5432"
38 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["timestamp"] == "21-09-28 09:22:19.536"
39 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["auth_method"] == "password"
40 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["message"] == "2021-09-28 09:22:19.536 UTC:1.2.3.4(5432):i_dont_exist@postgres:[127]:FATAL: password authentication failed for user \"i_dont_exist\""
41 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["pgsql_dbname"] == "postgres"
42 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["pgsql_target_user"] == "i_dont_exist"
43 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Parsed["pid"] == "127"
44 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Meta["auth_method"] == "password"
45 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Meta["datasource_path"] == "pgsql-logs.log"
46 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Meta["datasource_type"] == "file"
47 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Meta["db"] == "postgres"
48 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Meta["log_type"] == "pgsql_failed_auth"
49 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Meta["source_ip"] == "1.2.3.4"
50 results["s01-parse"]["crowdsecurity/pgsql-logs"][1].Evt.Meta["user"] == "i_dont_exist"