[Snort-users] WinSnort and MSSQL Problem

Uso usofwd at ...158...
Tue Dec 30 21:35:01 EST 2003


With 2.1.0 I get that weired MSSQL error  with 2.0.6 I don't.
If it makes you happy: "Snort does not have bugs, never had and never will
have any". ;-)
(that doesn's solve my problem with 2.1 but 2.0.6 will have to do at the
moment) or I switch back to MySQL instead of MSSQL (which was also working
fine on 2.1, just wanted to see if MSSQL is any faster with ACID then
MySQL).

So, sorry if you got offended by mentioning the possibility that snort might
have a bug.
Wish u a happy new year.

regards
Uso


----- Original Message -----
From: "Michael Steele" <michaels at ...9077...>
To: "'Snort Users List'" <snort-users at lists.sourceforge.net>
Sent: Wednesday, December 31, 2003 8:08 AM
Subject: RE: [Snort-users] WinSnort and MSSQL Problem


> There are NO bugs in the 2.0.6 or 2.1.0 versions of Snort located at
> CodeCraft Consultants or WINSNORT.com.
>
> Kindest regards,
>
> The WINSNORT.com Management Team
> --
> 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
>
>
> > -----Original Message-----
> > From: snort-users-admin at lists.sourceforge.net [mailto:snort-users-
> > admin at lists.sourceforge.net] On Behalf Of Uso
> > Sent: Tuesday, December 30, 2003 7:47 PM
> > To: snort-users at lists.sourceforge.net
> > Subject: Re: [Snort-users] WinSnort and MSSQL Problem
> >
> > I have now installed Snort 2.06 (the version on the codecrafts site) and
> > it
> > works fine, which leads me to believe that 2.1 has some sort of bug in
> > that
> > regard.
> >
> > regards
> > Uso
> >
> > ----- Original Message -----
> > From: "Uso" <usofwd at ...158...>
> > To: <snort-users at lists.sourceforge.net>
> > Sent: Tuesday, December 30, 2003 1:31 PM
> > Subject: [Snort-users] WinSnort and MSSQL Problem
> >
> >
> > > Hi,
> > > I just finished installing snort with ACID and MSSQL according to the
> > > documentation on WinSnort.com.
> > > I am receiving some errors that I don't understand on the console but
> > the
> > > system seems to be working fine as ACID is reporting correctly
(however
> > CPU
> > > utilization is high because of the scrolling of these error messages
in
> > the
> > > console window).
> > > Does anyone have a clue what that error means?
> > >
> > > regards
> > > Uso
> > >
> > >
> > > -*> Snort! <*-
> > > Version 2.1.0-ODBC-MySQL-MSSQL-FlexRESP-WIN32 (Build 9)
> > > 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 'ITTSLAB1', Line 1
> > > database:  The above error was caused by the following statement:
> > > INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '4978',
> > '1',
> > > '2003-
> > > 12-30 13:21:37.197')
> > > database: SQL Server message 3621, state 0, severity 0:
> > >         The statement has been terminated.
> > > Server 'ITTSLAB1', Line 1
> > > database:  The above error was caused by the following statement:
> > > INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '4978',
> > '1',
> > > '2003-
> > > 12-30 13:21:37.197')
> > > 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', '4978',
> > '1',
> > > '2003-
> > > 12-30 13:21:37.197')
> > > 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 'ITTSLAB1', Line 1
> > > database:  The above error was caused by the following statement:
> > > INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '4979',
> > '1',
> > > '2003-
> > > 12-30 13:21:37.197')
> > > database: SQL Server message 3621, state 0, severity 0:
> > >         The statement has been terminated.
> > > Server 'ITTSLAB1', Line 1
> > > database:  The above error was caused by the following statement:
> > > INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '4979',
> > '1',
> > > '2003-
> > > 12-30 13:21:37.197')
> > > 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', '4979',
> > '1',
> > > '2003-
> > > 12-30 13:21:37.197')
> > > 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 'ITTSLAB1', Line 1
> > > database:  The above error was caused by the following statement:
> > > INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '4980',
> > '1',
> > > '2003-
> > > 12-30 13:21:37.197')
> > > database: SQL Server message 3621, state 0, severity 0:
> > >         The statement has been terminated.
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.net email is sponsored by: IBM Linux Tutorials.
> > > Become an expert in LINUX or just sharpen your skills.  Sign up for
> > IBM's
> > > Free Linux Tutorials.  Learn everything from the bash shell to sys
> > admin.
> > > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > > _______________________________________________
> > > Snort-users mailing list
> > > Snort-users at 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
> > >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: IBM Linux Tutorials.
> > Become an expert in LINUX or just sharpen your skills.  Sign up for
IBM's
> > Free Linux Tutorials.  Learn everything from the bash shell to sys
admin.
> > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> > _______________________________________________
> > Snort-users mailing list
> > Snort-users at 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
>
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: IBM Linux Tutorials.
> Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
> Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
> Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
> _______________________________________________
> Snort-users mailing list
> Snort-users at 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
>





More information about the Snort-users mailing list