Re: Snort, MSSQL and Win2k Question

["Chris Reid" <Chris.Reid () CodeCraftConsultants com>]

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


----- Original Message ----- 
From: "Nick Patellis" <NPatellis () TheFund com>
To: <snort-users () 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

 




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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