| 1 |
len(results) == 4 |
| 2 |
len(results["s00-raw"]["crowdsecurity/non-syslog"]) == 3 |
| 3 |
results["s00-raw"]["crowdsecurity/non-syslog"][0].Success == true |
| 4 |
results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Parsed["message"] == "2020-04-16T05:13:40.861934Z 344 [Note] Access denied for user 'root'@'27.155.87.54' (using password: YES)" |
| 5 |
results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Parsed["program"] == "mysql" |
| 6 |
results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Meta["datasource_path"] == "mysql-logs.log" |
| 7 |
results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Meta["datasource_type"] == "file" |
| 8 |
results["s00-raw"]["crowdsecurity/non-syslog"][1].Success == true |
| 9 |
results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Parsed["message"] == "2020-04-16T05:13:41.144260Z 345 [Note] Access denied for user 'root'@'27.155.87.54' (using password: NO)" |
| 10 |
results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Parsed["program"] == "mysql" |
| 11 |
results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Meta["datasource_path"] == "mysql-logs.log" |
| 12 |
results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Meta["datasource_type"] == "file" |
| 13 |
results["s00-raw"]["crowdsecurity/non-syslog"][2].Success == true |
| 14 |
results["s00-raw"]["crowdsecurity/non-syslog"][2].Evt.Parsed["message"] == "2021-10-28T08:06:45.411498Z 25 [Note] [MY-010926] [Server] Access denied for user 'seb'@'42.42.42.42' (using password: NO)" |
| 15 |
results["s00-raw"]["crowdsecurity/non-syslog"][2].Evt.Parsed["program"] == "mysql" |
| 16 |
results["s00-raw"]["crowdsecurity/non-syslog"][2].Evt.Meta["datasource_path"] == "mysql-logs.log" |
| 17 |
results["s00-raw"]["crowdsecurity/non-syslog"][2].Evt.Meta["datasource_type"] == "file" |
| 18 |
len(results["s01-parse"]["crowdsecurity/mysql-logs"]) == 3 |
| 19 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Success == true |
| 20 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Parsed["message"] == "2020-04-16T05:13:40.861934Z 344 [Note] Access denied for user 'root'@'27.155.87.54' (using password: YES)" |
| 21 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Parsed["program"] == "mysql" |
| 22 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Parsed["source_ip"] == "27.155.87.54" |
| 23 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Parsed["time"] == "2020-04-16T05:13:40.861934Z" |
| 24 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Parsed["user"] == "root" |
| 25 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Parsed["using_password"] == "YES" |
| 26 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Meta["datasource_path"] == "mysql-logs.log" |
| 27 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Meta["datasource_type"] == "file" |
| 28 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Meta["log_type"] == "mysql_failed_auth" |
| 29 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Meta["source_ip"] == "27.155.87.54" |
| 30 |
results["s01-parse"]["crowdsecurity/mysql-logs"][0].Evt.Meta["user"] == "root" |
| 31 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Success == true |
| 32 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Parsed["message"] == "2020-04-16T05:13:41.144260Z 345 [Note] Access denied for user 'root'@'27.155.87.54' (using password: NO)" |
| 33 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Parsed["program"] == "mysql" |
| 34 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Parsed["source_ip"] == "27.155.87.54" |
| 35 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Parsed["time"] == "2020-04-16T05:13:41.144260Z" |
| 36 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Parsed["user"] == "root" |
| 37 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Parsed["using_password"] == "NO" |
| 38 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Meta["datasource_type"] == "file" |
| 39 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Meta["log_type"] == "mysql_failed_auth" |
| 40 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Meta["source_ip"] == "27.155.87.54" |
| 41 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Meta["user"] == "root" |
| 42 |
results["s01-parse"]["crowdsecurity/mysql-logs"][1].Evt.Meta["datasource_path"] == "mysql-logs.log" |
| 43 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Success == true |
| 44 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Parsed["err_code"] == "MY-010926" |
| 45 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Parsed["message"] == "2021-10-28T08:06:45.411498Z 25 [Note] [MY-010926] [Server] Access denied for user 'seb'@'42.42.42.42' (using password: NO)" |
| 46 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Parsed["program"] == "mysql" |
| 47 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Parsed["source_ip"] == "42.42.42.42" |
| 48 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Parsed["subsystem"] == "Server" |
| 49 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Parsed["time"] == "2021-10-28T08:06:45.411498Z" |
| 50 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Parsed["user"] == "seb" |
| 51 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Parsed["using_password"] == "NO" |
| 52 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Meta["user"] == "seb" |
| 53 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Meta["datasource_path"] == "mysql-logs.log" |
| 54 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Meta["datasource_type"] == "file" |
| 55 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Meta["log_type"] == "mysql_failed_auth" |
| 56 |
results["s01-parse"]["crowdsecurity/mysql-logs"][2].Evt.Meta["source_ip"] == "42.42.42.42" |