| 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" |