**** This is still a work in progress in alpha stage ****
Hello everyone,
I would like to present my work in progress project about Mikrotik, it is a software to view, generate and store the web-proxy, accounting and traffic data from Mikrotik devices…
Motivations
I have came from an ISA/TMG environment, and I am an IT professional who implement network and other various solutions to our customers… one of these solutions is Mikrotik with its various features and configurations…
Among these setups, we have implemented a number of web-proxy and internet filtering related projects, then we have realized the need for a software that can provide many of our customers requests about reporting and monitoring for the data coming from Mikrotik…
The currently available applications for these requirements are good, but each one of them is lacking a key feature that we felt along with our customers frustrated not to have it… such as traffic usage statistics, automated logs capturing, automatic name resolution for IPs, graphs and more important, platform compatibility…
While I am working slowly on this project, I am going steadily in the development, but I have to balance my work, social life and other self training and development works I do as well…
Goals and Targets
I would like to achieve the following goals from the software:
- Address the most critical shortages from the currently available applications
- Fully automated real-time logs capturing and storing in a SQL database
- Fully automated reports generation mechanics and settings
- Flexible installation environment and application components configuration
- Detailed reports that include visited sites, most requested domains, download/upload statistics, time ranges selection for reports
Features
- Built using VB.NET, and can work on most recent Windows operating systems, with the slight possibility to work on Linux operating systems through Mono, this is yet to be tested and worked on.
- Reports by single user, either by IP address or computer name, that provide details for all visited sites, download/upload statistics, and simple graphs and charts
- Can auto-resolve IPs to hostnames with proper DNS settings in the network
- Overall report for users, shows top users, most visited domains, with charts and graphs
- Ability to setup automated reports to be generated based on time schedules
- Can generate reports based on time range, target domains, or special conditions can be defined be user
Current Status
Work in progress.
Single user report is now fully functional
Work on overall users report is in progress
Downloads and Information (work in progress for documentation and wiki)
Github page (downloads and support/how to install): https://github.com/salehram/mikrotik-proxy-logger
Latest release: 0.0.4a [Link_to_be_posted]
Notes
- This is still in pretty much alpha stage, and the wiki, documentation pages are yet to be changed to be much more better and informative… However, I will do my best to support any issue and to organize the wiki as fast as I can…
- I will be available on Github and on the forums here to address and support any question and issue.
- I would love to know about any issue or bugs for the current completed work, and to make the best out of any bug reported or issue, please follow the following format for any report on bugs:
- Platform:
- Error code:
- Application version:
- Type of the bug/issue: (causing software crash, causing wrong data output, causing parts of the software to be disfunctional)
- Summary of the bug:
- Detailed description:
- How to reproduce: