Project Detail

Description

You will start with some large (50MB-200MB) "pcap" capture files as generated by Ethereal or Wireshark, which include only SIP messages. The final goal is a database table that contains one entry per SIP message, with the essential fields inserted into the DB (source IP/port, destination IP/port, From, To, Call-Id, etc). I want this so that I can perform SQL queries and gather statistics from captures off my switch.

Your tasks will be to:
1. Create the MySQL "create" statements for this table (I will provide the exact fields later) as well as scripts to clear the table when required.
2. Write a java program that reads the capture file and populates the DB. (java because I need it to be cross-platform)

This is only for proof of concept, so you you can just hardcode the input filename, DB address, DB name, and username/password. The code must be able to process 50MB of SIP capture files within 10 seconds. I'll provide some example capture files to use.

This is just the beginning, if I like what I can do then I'll be happy to pay extra later for a "full" program with command-line switches, advanced filtering, etc.