Snort mailing list archives
Question about MSSQL
From: "Don" <Don () WeberOnTheWeb com>
Date: Sat, 2 Nov 2002 01:32:18 -0800
I'm getting just tons of errors is anyone suing this option yet with win2k server and mssql, snort build 1.8.6, i used the mssql-create script that came with the build, one problem i am having is with schema, apparently when snort goes to look at the schema version it gets a 0 as return value, which i blv is an error in how it asks, using query ana, i must type SELECT vseq from [schema]; to get results typing simply SELECT vseq from schema; results in syntax error, i'm thinking this is why snort doesnt get the correct results when attempting to connect to the db here's some of the text from the screen, any ideas what is going on? actually first i had to allow nulls on column 'last_cid' to even get this far. here's the error before i made that change, it had quite a few more errors after that one, so i was taking them one at a time, allowing nulls in this column seems to have fixed the rest of those errors tho. database: SQL Server message 515, state 2, severity 16: Cannot insert the value NULL into column 'last_cid', table 'Snort.snortu sr.sensor'; column does not allow nulls. INSERT fails. now i get this error, which i think if the code put the word schema in [] it would probably work fine, or could there be some configuration error on my system that wont let it see just the word schema as a table somehow, i usually dont have to put tables in brackets. database: sensor id = 1 database: SQL Server message 156, state 1, severity 15: Incorrect syntax near the keyword 'schema'. Server 'WEBER', Line 1 database: The above error was caused by the following statement: SELECT vseq FROM schema database: DB-Library error: General SQL Server error: Check messages from the SQL Server. database: The above error was caused by the following statement: SELECT vseq FROM schema database: schema version = 0 database: The underlying database seems to be running an older version of the DB schema (current version=0, required minimum version= 106). thanks in advance Don ------------------------------------------------------- This sf.net email is sponsored by: See the NEW Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- Question about MSSQL Don (Nov 02)
- Re: Question about MSSQL Erek Adams (Nov 02)
- <Possible follow-ups>
- RE: Question about MSSQL Robbins, Mark (Nov 04)
- RE: Question about MSSQL Michael Steele (Nov 04)