Snort mailing list archives

Snort 1.9.0 on Windows and MSSQL


From: "Robbins, Mark" <MRobbins () sf edu>
Date: Thu, 24 Oct 2002 13:43:46 -0500

Has anyone gotten Snort 1.9.0 to log to an MSSQL database with the available
(compiled) executables?

I am getting the error message 

database: SQL Server message 156, state 1, severity 15:
Incorrect syntax near the keyword 'schema'.
database: The above error was caused by the following statement:
SELECT vseq FROM schema

In MSSQL, schema is a reserved word, and the syntax would have to be SELECT
vseq FROM [schema] for this to work. I have used previous versions of snort
to log to MSSQL with no difficulty.

Could this problem arise from a configuration mistake I have made, or is the
problem in snort.exe itself?

Thanks for any help you can provide.

Mark Robbins


Current thread: