save connection record

RouterOS General
1

hi
can any one tell me how to save connection record of users to database so that in future i can get is if required for legal purpose

we are using mikrotik as hotspot and freeradius for authentication

Please help

2

you can log connections/disconnections using a syslog

3

yes but that makes the list really long and i want to track url also
using proxy is not a solution as we are giving public ip and if we do proxy they all will be masked behind the proxy ip

4

i think you cannot store url visited by your users.
this is also useless for legal purposes.

you can use a trasparent proxy or write a rule in firewall to log new http connections, i.e. using a L7 matcher