[Snort-users] HELP: Error MSSQL and ACID

Michael Steele michaels at ...9077...
Fri Apr 2 10:49:13 EST 2004


John,

It looks like its trying to insert a key that has already been inserted. I
don't know much about MSSQL but you might try either removing or renaming
that key. Backup your database prior to altering.

If you are not sure how then do a search on Google.

Found This:

You can run DBCC CHECKIDENT to correct this error. This error sometimes
occurs when you insert new rows.

This is the description of DBCC CHECKIDENT from the SQL Server 6.5 BOL:

DBCC CHECKIDENT [(table_name)] Checks the current identity value and
compares it with the maximum value in the identity column. If the current
identity value is invalid, it will be reset using the maximum value in the
identity column. Invalid identity information can cause SQL Server message
2627 when a PRIMARY KEY or UNIQUEKEY constraint exists on an identity
column.


You can make stored procedure, which will check the identity field and make
this sp as startup (by using the sp_makestartup stored procedure). This is
the test example:

use master
go
CREATE PROCEDURE sp_checkident AS
EXEC ('use pubs       
DBCC CHECKIDENT (jobs)')
go
sp_makestartup sp_checkident
go
 

Kindest regards,
Michael...

WINSNORT.com Management Team Member
--
Pick up your FREE Windows or UNIX Snort installation guides      
mailto:support at ...9077...
Website: http://www.winsnort.com
Snort: Open Source Network IDS - http://www.snort.org

________________________________________
From: snort-users-admin at lists.sourceforge.net
[mailto:snort-users-admin at lists.sourceforge.net] On Behalf Of Kromodimedjo,
John
Sent: Friday, April 02, 2004 4:32 AM
To: snort-users at lists.sourceforge.net
Subject: [Snort-users] HELP: Error MSSQL and ACID

Hi all,

This is my second (from scratch) installation and I still get this error
message on the command line – I know that it try to add a record with a
duplicate key but I not sure it should do that.
I use SNORT/ACID/MSSQL200 using Windows 2003 and IIS6 and have followed
exactly as specified in the WinSNORT installation Guide.

Can somebody help, I am really lost.

Thanks a million

John Kromodimedjo
UNAIDS-Geneva

-------Error message-----


D:\applications\snort\bin>snort -c d:\applications\snort\etc\snort.conf -l
d:\ap
plications\snort\log -i1
-*> Snort! <*-
Version 2.1.1-ODBC-MySQL-MSSQL-FlexRESP-WIN32 (Build 24)
By Martin Roesch (roesch at ...1935..., www.snort.org)
1.7-WIN32 Port By Michael Davis (mike at ...92...,
www.datanerds.net/~mike)
1.8 - 2.1 WIN32 Port By Chris Reid (chris.reid at ...3029...)
database: SQL Server message 2627, state 1, severity 14:
        Violation of PRIMARY KEY constraint 'PK__event__78B3EFCA'. Cannot
insert
 duplicate key in object 'event'.
Server 'GE-3E-06', Line 1
database:  The above error was caused by the following statement:
INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '1', '1',
'2004-04-
02 14:11:32.191')
database: SQL Server message 3621, state 0, severity 0:
        The statement has been terminated.
Server 'GE-3E-06', Line 1
database:  The above error was caused by the following statement:
INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '1', '1',
'2004-04-
02 14:11:32.191')
database: DB-Library error:
        General SQL Server error: Check messages from the SQL Server.
database:  The above error was caused by the following statement:
INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '1', '1',
'2004-04-
02 14:11:32.191')

________________________________
John Kromodimedjo
Network Administrator
UNAIDS / ONUSIDA
Phone: +41.22.791.4707
FAX: +41.22.791.4187
Email: KromodimedjoJ at ...11499...





More information about the Snort-users mailing list