mySQL database for nessusd (code!)

Just an update on the database backend for nessusd...

I've started coding a mysql interface/library for nessusd.
It is written in C and uses mysql.h (the mysql C API).

The code can be found at:
<a href="http://www.rit.edu/~wjh3710/pub/save_mysql.c">save_mysql.c</a>
and
<a href="http://www.rit.edu/~wjh3710/pub/save_mysql.h">save_mysql.h</a>

This is by no means complete. I will try to update it as much as
possible. But if others want to assist with the development, it
might be best to set up a CVS server (anyone interested?).

I'm working with the database schema that Javi posted awhile back,
but due to my lack of SQL knowledge and the way nessusd is set-up,
I don't think that some of the tables can be setup in that manner.

I think the easiest way to incorporate the non-session specific data
(i.e. the Nessus-plugin table and Services table and the like...) is
to write a simple [perl?] script to create an sql modules directly
from the plugins' directory and hard code a script to deal with the
services.

----------------------
William Heinbockel
Information Security Incident Response Assistant
Co-op Risk & Safety Management
Rochester Institute of Technology
E-mail: [email protected]