Kippo2MySQL

This is yet another simple piece of software that simply extracts some VERY BASIC stats from Kippo’s text-based log files (a mess to analyze!) 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 “kippo-stats” perl script originally writen by Tomasz Miklas and modified by mig5. Later on I might update Kippo-Graph or write a new tool specifically for Kippo2MySQL to generate some graphs from this type of data.

DOWNLOAD:

Download Kippo2MySQL v0.1.2 here: kippo2mysql-0.1.2

MD5 Checksum: 11C7755FB760959A24A7981E4C7BEBCB
SHA-1 Checksum: 6BB5CAC87135BD6E39651AEA87ED6496F0DBB05F

INSTALLATION:

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.