Honeyd2MySQL is yet another simple piece of software that extracts all the basic stats from honeyd’s text-based log files and inserts them in a MySQL database. Then you can run some queries and of course visualize the data if you want to.
Many things are hardcoded or dead simple, but it does the job. The file is a modified version of “honeyd_importer” perl script originally writen by Joshua Gimer and shared through “honeypots” mailing list. This script works in combination with Honeyd-Viz, the web based interface for honeyd’s results visualization that was created along the lines of Kippo-Graph.
Important!Download the latest version (0.3) here: honeyd2mysql-0.3
MD5 Checksum: 4856122B53264D9077A005864095C0DF
SHA-1 Checksum: CBB0ABD48B430AF521B43E8F6E1BD453EBD8F86E
Notice: Honeyd2MySQL can also be found at GitHub: https://github.com/ikoniaris/honeyd2mysql
You will have to change the script and enter the correct paths, your MySQL credentials, have a database and a db user created beforehand, etc. It’s pretty straightforward if you take a look at the script and have some basic understanding of perl and MySQL server.