SQLite format 3 @
wQtablelogslogsCREATE TABLE logs(id int auto increment,timestamp datetime default current_timestamp,message text) β ϋφρμηβ7-04-08 14:46:17{u'message': {u'account': u'makkhens', u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'makkhens', u'unblock'], u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'makkhens', u'block'], u'abuse_type': u'compromised', u'undo_action': u'clamdscan_action', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action', 'action_id': '1f02b51e-1c6a-11e7-b975-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}\ 32017-04-08 14:46:17{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'makkhens', u'block'], u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'makkhens', u'unblock'], u'account': u'makkhens', u'abuse_type': u'compromised', u'undo_action': u'clamdscan_action', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action'}, 'meta': {'sender_ip_address': '172.23.210.
!
32017-04-08 14:46:17{u'message': {u'account': u'makkhens', u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'makkhens', u'unblock'], u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'makkhens', u'block'], u'abuse_type': u'compromised', u'undo_action': u'clamdscan_action', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action', 'action_id': '1f02b51e-1c6a-11e7-b975-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}\ 32017-04-08 14:46:17{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'makkhens', u'block'], u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'makkhens', u'unblock'], u'account': u'makkhens', u'abuse_type': u'compromised', u'undo_action': u'clamdscan_action', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
N -N \ 32017-04-08 14:46:21{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'ymswehfw', u'block'], u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'ymswehfw', u'unblock'], u'account': u'ymswehfw', u'abuse_type': u'compromised', u'undo_action': u'clamdscan_action', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}P 3}2017-04-08 14:46:18{u'message': {'status': 'done', 'parent_action_id': None, 'action_id': '1f02b51e-1c6a-11e7-b975-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
μ P 3}2017-04-08 14:46:23{u'message': {'status': 'done', 'parent_action_id': None, 'action_id': '21eeb9d0-1c6a-11e7-9bb3-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'} 32017-04-08 14:46:22{u'message': {u'account': u'ymswehfw', u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'ymswehfw', u'unblock'], u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'ymswehfw', u'block'], u'abuse_type': u'compromised', u'undo_action': u'clamdscan_action', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action', 'action_id': '21eeb9d0-1c6a-11e7-9bb3-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
!
32017-04-08 14:46:26{u'message': {u'account': u'zozoidzr', u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'zozoidzr', u'unblock'], u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'zozoidzr', u'block'], u'abuse_type': u'compromised', u'undo_action': u'clamdscan_action', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action', 'action_id': '248dbbb4-1c6a-11e7-81a7-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}\ 32017-04-08 14:46:26{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'zozoidzr', u'block'], u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'zozoidzr', u'unblock'], u'account': u'zozoidzr', u'abuse_type': u'compromised', u'undo_action': u'clamdscan_action', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
6 -Μ 6 32017-04-08 14:46:30{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'sswtehjb', u'unblock'], u'account': u'sswtehjb', u'abuse_type': u'compromised', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action', 'action_id': '26ed5b1c-1c6a-11e7-abbf-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}^
3
2017-04-08 14:46:30{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'sswtehjb', u'unblock'], u'account': u'sswtehjb', u'abuse_type': u'compromised', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}P 3}2017-04-08 14:46:27{u'message': {'status': 'done', 'parent_action_id': None, 'action_id': '248dbbb4-1c6a-11e7-81a7-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
- - ^
3
2017-04-08 14:46:32{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'colleagz', u'unblock'], u'account': u'colleagz', u'abuse_type': u'compromised', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}o 3
;2017-04-08 14:46:31{u'message': {'status': 'not done', 'parent_action_id': None, 'error_message': 'There were errors during execution - error message = iptables: Bad rule (does a matching rule exist in that chain?).\n , exit code = 1', 'action_id': '26ed5b1c-1c6a-11e7-abbf-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
ψ j ψ o 3
;2017-04-08 14:46:33{u'message': {'status': 'not done', 'parent_action_id': None, 'error_message': 'There were errors during execution - error message = iptables: Bad rule (does a matching rule exist in that chain?).\n , exit code = 1', 'action_id': '2820979c-1c6a-11e7-8769-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'} 32017-04-08 14:46:32{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'colleagz', u'unblock'], u'account': u'colleagz', u'abuse_type': u'compromised', u'host_name': u'md-in-64.webhostbox.net', u'action_type': u'do', u'action': u'clamdscan_action', 'action_id': '2820979c-1c6a-11e7-8769-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}