[Snort-users] Snort, MSSQL and Win2k Question

Chris Reid Chris.Reid at ...2817...
Mon Jul 22 17:20:12 EDT 2002


Edit create_mssql, and change all occurrences of TEXT to VARCHAR(7000).


----- Original Message ----- 
From: "Nick Patellis" <NPatellis at ...6343...>
To: <snort-users at lists.sourceforge.net>
Sent: Monday, July 22, 2002 2:29 PM
Subject: [Snort-users] Snort, MSSQL and Win2k Question


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

 






More information about the Snort-users mailing list