Snort mailing list archives
Re: Snort, MSSQL and Win2k Question
From: "Chris Reid" <Chris.Reid () CodeCraftConsultants com>
Date: Mon, 22 Jul 2002 18:17:50 -0600
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
Current thread:
- Snort, MSSQL and Win2k Question Nick Patellis (Jul 22)
- Re: Snort, MSSQL and Win2k Question Chris Reid (Jul 22)