Log firewall -->> Connection ?

RouterOS General
1

Hi there
I wanna to know that is it possible to export the connection list in firewall to external database such as SQL or anything else?
If yes, is this need to write some Scripts?

2

http://wiki.mikrotik.com/wiki/Manual:IP/Traffic_Flow

Install a NetFlow collector that can write to a database. Several free ones are available and can be found via Google, or by searching the forums for “netflow” and “traffic flow”.

3

Hi fewi (or anybody),

Ive seen you suggest this in a couple of places. will this log things like mac address, requested url, downloaded data handles etc?

Ive tried looking at setting up ntopng on our Ubuntu server in the cloud but I stopped as I wasnt sure what depth of data would be available by this means.

4

As far as I have found out, you do not get mac in the connection logs, only sourceIP, DestIP, SourcePort, DestPort and username if you using hotspot.
This can be graphed with Splunk/Graylog or other tools.
http://forum.mikrotik.com/t/using-splunk-to-analyse-mikrotik-logs/105668/1

5

Hmm yeah thats what I thought when I installed it and began setting it up.

I need to log all activity so back to the drawing board for me

6

I am able to get mac, sourceIP and destIP. How will I capture the username on my hotspot ?