SQLite format 3 @
wQtablelogslogsCREATE TABLE logs(id int auto increment,timestamp datetime default current_timestamp,message text) η ϋφρμη017-08-21 02:29:34{u'message': {u'account': u'homez9de', u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'homez9de', u'unblock'], u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'homez9de', 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': '9177916a-8618-11e7-9bb3-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}\ 32017-08-21 02:29:33{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'homez9de', u'block'], u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'homez9de', u'unblock'], u'account': u'homez9de', 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'}
!
32017-08-21 02:29:34{u'message': {u'account': u'homez9de', u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'homez9de', u'unblock'], u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'homez9de', 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': '9177916a-8618-11e7-9bb3-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}\ 32017-08-21 02:29:33{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'homez9de', u'block'], u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'homez9de', u'unblock'], u'account': u'homez9de', 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-08-21 02:29:44{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'psorin7c', u'block'], u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'psorin7c', u'unblock'], u'account': u'psorin7c', 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-08-21 02:29:35{u'message': {'status': 'done', 'parent_action_id': None, 'action_id': '9177916a-8618-11e7-9bb3-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
μ P 3}2017-08-21 02:29:45{u'message': {'status': 'done', 'parent_action_id': None, 'action_id': '97dd8f3c-8618-11e7-81a7-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'} 32017-08-21 02:29:44{u'message': {u'account': u'psorin7c', u'undo_action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'psorin7c', u'unblock'], u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'psorin7c', 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': '97dd8f3c-8618-11e7-81a7-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
32017-08-21 02:29:51{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'indiabig', u'unblock'], u'account': u'indiabig', 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': '9c00f86a-8618-11e7-abbf-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}^ 3
2017-08-21 02:29:51{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'indiabig', u'unblock'], u'account': u'indiabig', 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'}
- - ^
3
2017-08-21 05:46:06{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'homez9de', u'unblock'], u'account': u'homez9de', 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-08-21 02:29:52{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': '9c00f86a-8618-11e7-abbf-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}
j P 3}2017-08-21 05:46:07{u'message': {'status': 'done', 'parent_action_id': None, 'action_id': '06864954-8634-11e7-8769-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'} 32017-08-21 05:46:06{u'message': {u'action_params': [u'BAN_USER', u'eth1', u'80,443,465,587', u'homez9de', u'unblock'], u'account': u'homez9de', 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': '06864954-8634-11e7-8769-0cc47aca427c'}, 'meta': {'sender_ip_address': '172.23.210.143'}, u'service': u'execute'}