Community discussions

MikroTik App
 
ourplan
newbie
Topic Author
Posts: 28
Joined: Mon Oct 23, 2017 10:42 am

firewall log parse

Tue Nov 06, 2018 5:58 pm

Hello there. I want to break the message I received on the screen with the firewall log. I need to save the following data to different fields saved in Mysql e. Can you help me?

in: <pppoe-user1> out: vlan1, src-mac 4c: 5e: 0c: 0c: 0c: 0c, proto TCP (ACK), 192.168.1.5:47694->74.125.154.73:443, NAT (192.168.1.5 : 47694-> 123.123.123.123:15400) -> 74.125.154.73:443, len 52

mysql register should be as follows

1 column : user1
2 column : 4c: 5e: 0c: 0c: 0c: 0c
3 column : 192.168.1.5:47694
4 column : 74.125.154.73:443
5 column : 123.123.123.123:15400
6 column : 74.125.154.73:443

Who is online

Users browsing this forum: baragoon and 62 guests