SQLite format 3 @
wQtablelogslogsCREATE TABLE logs(id int auto increment,timestamp datetime default current_timestamp,message text) μ ϋφρμ2017-04-04 22:38:53{u'message': {u'account': u'bmesotuk', u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'bmesotuk', u'unblock'], u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'bmesotuk', 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': '7a8c7810-1987-11e7-b975-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}\ 32017-04-04 22:38:52{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'bmesotuk', u'block'], u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'bmesotuk', u'unblock'], u'account': u'bmesotuk', 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's
!
32017-04-04 22:38:53{u'message': {u'account': u'bmesotuk', u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'bmesotuk', u'unblock'], u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'bmesotuk', 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': '7a8c7810-1987-11e7-b975-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}\ 32017-04-04 22:38:52{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'bmesotuk', u'block'], u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'bmesotuk', u'unblock'], u'account': u'bmesotuk', 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-04 22:38:56{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'colleagz', u'block'], u'undo_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'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-04 22:38:53{u'message': {'status': 'done', 'parent_action_id': None, 'action_id': '7a8c7810-1987-11e7-b975-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
μ P 3}2017-04-04 22:38:57{u'message': {'status': 'done', 'parent_action_id': None, 'action_id': '7cd60276-1987-11e7-9bb3-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'} 32017-04-04 22:38:56{u'message': {u'account': u'colleagz', u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'colleagz', u'unblock'], u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'colleagz', 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': '7cd60276-1987-11e7-9bb3-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
32017-04-04 22:39:00{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'brotrohe', u'unblock'], u'account': u'brotrohe', 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': '7f1df048-1987-11e7-81a7-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}^ 3
2017-04-04 22:39:00{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'brotrohe', u'unblock'], u'account': u'brotrohe', 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-04 22:39:01{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': '7f1df048-1987-11e7-81a7-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}