mySQL

[Javier Fernandez-Sanguino]

Jarien wrote:

  > i'm also interested in knowing how to dump nessus results into
> mysql.
> i've tried using import-nbe.pl and nessQuick as suggested.
> however, i faced some problems.
> 
> for import-nbe.pl,  i have messages showing ..
> 
> Name "main::opt_m" used only once: possible typo at
> import-nbe.pl line 86.
> Name "main::fakesql" used only once: possible typo at
> import-nbe.pl line 77.
> Name "main::opt_p" used only once: possible typo at
> import-nbe.pl line 96.
> Name "main::opt_u" used only once: possible typo at
> import-nbe.pl line 95.

Those are just warnings from Perl, you can safely disregard those. 
What did you actually run? You have to provide a nbe file in standard 
input. If you do, then it will try to connect to a remote database and 
  execute a number of statements. You can actually "fake" that (change 
$fakedb to '1' in the script so that you get the SQL statements on screen.

In order to create the database see the documentation below, you also 
need to:

1.- Create the database
2.- Run nessus-extract to populate the database with information based 
on the NASL scripts you have in your system

> 
> ... then, nothing happens. is it that i have to change anything
> in the perl script? what does the sessionid, hostid and
> executionid means in the script?

For information on the database schema used check the NESSUS_SQL 
branch, more specifically the information available at:
http://cvsweb.nessus.org/cgi-bin/cvsweb.cgi/nessus-core/doc/database/?only_with_tag=NESSUS_SQL

The documentation there should also give some additional information 
on how to import your nbe files. If you find it lacking, please speak up.


Regards

Javier