Snort mailing list archives
Snort, MSSQL and Win2k Question
From: "Nick Patellis" <NPatellis () TheFund com>
Date: Mon, 22 Jul 2002 16:29:43 -0400
Hi, I am running snort 1.8.7 on a win2K SP2 server along with MSSQL 2000 SP2 and am getting some errors which appear to be related to incorrect table creation. I used the create_mssql script to create the tables. Here is a sample of errors: The text, ntext, and image data types cannot be compared or sorted, exce pt when using IS NULL or LIKE operator. Server 'ELF1', Line 1 database: The above error was caused by the following statement: SELECT ref_id FROM reference WHERE ref_system_id = 1 AND ref_tag = '4474' 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 ref_id FROM reference WHERE ref_system_id = 1 AND ref_tag = '4474' database: SQL Server message 306, state 1, severity 16: The text, ntext, and image data types cannot be compared or sorted, exce pt when using IS NULL or LIKE operator. Server 'ELF1', Line 1 database: The above error was caused by the following statement: SELECT ref_id FROM reference WHERE ref_system_id = 1 AND ref_tag = '4474' 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 ref_id FROM reference WHERE ref_system_id = 1 AND ref_tag = '4474' database: Unable to insert the alert reference into the DB database: SQL Server message 306, state 1, severity 16: The text, ntext, and image data types cannot be compared or sorted, exce pt when using IS NULL or LIKE operator. Server 'ELF1', Line 1 database: The above error was caused by the following statement: SELECT ref_id FROM reference WHERE ref_system_id = 2 AND ref_tag = 'CAN-2002-007 9' 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 ref_id FROM reference WHERE ref_system_id = 2 AND ref_tag = 'CAN-2002-007 9' database: SQL Server message 306, state 1, severity 16: The text, ntext, and image data types cannot be compared or sorted, exce pt when using IS NULL or LIKE operator. Server 'ELF1', Line 1 database: The above error was caused by the following statement: SELECT ref_id FROM reference WHERE ref_system_id = 2 AND ref_tag = 'CAN-2002-007 9' Any ideas? Thanks Nick ======================================= Nick Patellis Computer Security Analyst Attorneys' Title Insurance Fund 407.240.3863
Current thread:
- Snort, MSSQL and Win2k Question Nick Patellis (Jul 22)
- Re: Snort, MSSQL and Win2k Question Chris Reid (Jul 22)