Project:
  Development of a MYSQL Auditing Software.

Modules:
 The separate aspects of the software are:

 1). Netowrk Process : Monitoring of packets through a network of nodes
 2). Graphs and Reports : Reports showing the statistics accompanied with the graphs
 3). Administrative interface

Building on the concept of the "poor man's query profiler" at http://forge.mysql.com/snippets/view.php?id=15 , this project entails developing a process to listen to network packets to find MySQL packets destined for a server, and keeping a copy of the packet to use in the auditing of what commands are sent to that MySQL server. This project can accommodate a light or heavy workload, and one or more students.

The separate aspects of the software are: Network process: process to intercept network packets on a separate machine (in the same network range) for full access to information being sent to the database without causing any load on the MySQL server or interference with the queries. This process should also parse the queries and be able to store them in its own database.

Graphs and reports: This module will show statistics and graphs.

Administrative interface: This will take user input and write to the configuration file that the "network process", described above, will read to determine which queries to keep and which to not worry about. It will also configure the "graphs and reports" desired by the user

All deliverables will be released under the GNU General Public License