RE: Snort on XP SP2 W/ MSSQL

["Michael Steele" <michaels () winsnort com>]

He is using MSSQL.

Kindest regards,

Michael...

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

________________________________________
From: snort-users-admin () lists sourceforge net
[mailto:snort-users-admin () lists sourceforge net] On Behalf Of Briggs, Bruce
Sent: Tuesday, May 10, 2005 12:15 PM
To: James Bruce; Snort-users () lists sourceforge net
Subject: RE: [Snort-users] Snort on XP SP2 W/ MSSQL

Could be related to the MySQL Use old passwords issue.
 
The easiest way to deal with this is to download MySQL Administrator and run
it.
Select Startup Variables -> Security tab -> Use old passwords
 
The update the Snort password again.
Hopefully that should do it.
 
Bruce

________________________________________
From: snort-users-admin () lists sourceforge net
[mailto:snort-users-admin () lists sourceforge net] On Behalf Of James Bruce
Sent: Tuesday, May 10, 2005 1:09 PM
To: Snort-users () lists sourceforge net
Subject: [Snort-users] Snort on XP SP2 W/ MSSQL
Hi,
Hopefully someone can help me. I'm trying to get snort 232 build 12 running
on XP SP2 w/ one interface. I keep getting the error listed below when I
start the service. I have followed the snort installation guide: Installing
a complete IDS using IIS 5/6 Webserver step by step. When I get to the part
to test the service I get the following error listed below. 
I have checked to make sure the user snort has the proper INSERT and SELECT
permissions. I have also verified that the CREATE TABLE sensor was listed in
the create_mssql script that was run in query analyzer for the snort
database.

This is listed in the event viewer:
When this plugin starts, a SELECT query is run to find the sensor id for the
currently running sensor. If the sensor id is not found, the plugin will run
an INSERT query to insert the proper data and generate a new sensor id. Then
a SELECT query is run to get the newly allocated sensor id. If that fails
then this error message is generated.

 Some possible causes for this error are:
  * the user does not have proper INSERT or SELECT privileges
  * the sensor table does not exist

 If you are _absolutely_ certain that you have the proper privileges set and
 that your database structure is built properly please let me know if you
 continue to get this error.

Any help would be appreciated. 

Thanks, 
James Bruce






-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_ids93&alloc_id281&op=click
_______________________________________________
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