Wifi Counter Mikrotik

Good day! I can prepare a counter system with MikroTik and MySQL to You confidently because I am MikroTik certified network engineer (MTCTCE/MTCNA) having over 10 years of experience in configuring, maintaining and troubleshooting of enterprise network devices and Linux servers. Also, I've done it before. It was ssh script for pulling info from RouterOS via SSH (sshpass), preparing data (Linux utilities like tr, sed, grep) and pushing it to MySQL table.

Hello! I have briefly read the description on Wifi-Counter-Mikrotik project, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well. I reach out to see whether the opportunity is still available. If the job’s no longer available, I’d appreciate you throwing my hat into the ring for any similar opportunities in the future. 100 % Customer Anonymity 100 % Money-back Guarantee 100 % Plagiarism Free 100 % Authenticity 100 % Financial Data Safety Thank you for your time, I look forward to hearing from you soon, Best Wishes, Kevin M.

Hi. I have working with MikroTik routers (and RouterOS) for over 10 years. I have already done various scripts for MikroTik. For you project it just need to execute a script by scheduller and the script collect data from wifi card, parse then send data to your server. It can't directly write to your database. Need to create a webservice that receive data from MikroTik and then populate the database. Regards, Maciej

Hi. I did a similar project. It is divided into two parts. On Mikrotik, a wireless sniffer is launched that writes a dump to a file. Every N minutes a new file begins to be recorded. The old file is sent via FTP to your server for further processing. Only headers are written to the file. These headers contain information about MAC and signal levels. But as you probably know you will see real MAC only if the wireless device is connected to the any access point. In other cases, MAC addresses will be random. On the server you get pcap files. They can be parsed by the tshark program. Or you can use any library supporting work with pcap. You can write the received data to the database or process it in any way you like. If you want to store non-aggregated information up to the level of an individual package, then you will get huge databases.