Debian Codegraph @

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

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