I’ve started my first open source project, sort of at least.

I have my pix logging to a central syslog server. The last weeks I’ve been googling around for a good pix.log analyzer, but they are commercial or bound to the win32 platform.

So I decided to make a web-enabled pixlog parser.
Version 0.0.1 is up and running, having parsed little over 16000 pix log entries. Right know I’m deciding how the front end should look. But it already enables me to gather some nice statistics.

<br /> mysql> SELECT count(logentry_id) AS number_entries, src_ip<br /> -> FROM pixlogentries<br /> -> WHERE src_ip != ''<br /> -> GROUP BY src_ip<br /> -> ORDER BY number_entries DESC limit 5;<br /> +----------------+--------------+<br /> | number_entries | src_ip |<br /> +----------------+--------------+<br /> | 63 | 82.48.88.45 |<br /> | 63 | 82.131.12.31 |<br /> | 54 | 82.224.67.67 |<br /> | 54 | 82.135.15.15 |<br /> | 54 | 64.75.146.37 |<br /> +----------------+--------------+<br /> 5 rows in set (0.03 sec)<br />

I expect to make the first version available to the public within 4-6 weeks.