RE: mySQL database for nessusd (code!)

I am interested in contributing whatever I can to this. There are
probably going to be some tough decisions to be made in the process 
of moving nessus over to a database backend.

I'll snag a copy of your code and start looking through it tonight. 
I think Renaud actually gave Javi some hints in a previous email. 
I need to go back and look for that.

-----Original Message-----
From: William Heinbockel [mailto:[email protected]]
Sent: Thursday, February 06, 2003 12:23 PM
To: [email protected]
Subject: 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]