I've been happily using hMailServer for more than 10 years now, and it has accumulates lots of logs. Before archiving them, I wanted to see who is abusing the server and should be added to the firewall blocking rules.
The program that I wrote helped me to put all IP addresses that accessed the server into a database, for further analysis.
I built it in Visual Studio 2015. If you want to use it, you can probably use any version out there. It is built on .NET full framework 4.7.1, but if you want it will likely convert to Core with little effort.
For MySQL, you need MySQL .NET Connector installed. For MS SQL you need SQL client.
Here's how to run it:
Code: Select all
hMailServerLogImporter MsSql "P:\Program Files (x86)\hMailServer\Logs" hmailserver_2018-12-29.log hmailserver_2019-01-01.log
I am open to suggestions, so if you have any wishes, leave them in this thread, and I will check it every once in a while.