Snort mailing list archives
RE: Snort on XP SP2 W/ MSSQL
From: "Briggs, Bruce" <Bruce.Briggs () suny edu>
Date: Tue, 10 May 2005 15:15:04 -0400
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 <http://www.snetworking.com/cis/Installing_a_complete_IDS_using_the_IIS% 205.htm> 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
Current thread:
- Snort on XP SP2 W/ MSSQL James Bruce (May 10)
- <Possible follow-ups>
- RE: Snort on XP SP2 W/ MSSQL Briggs, Bruce (May 10)
- RE: Snort on XP SP2 W/ MSSQL Michael Steele (May 10)
- Snort on XP SP2 W/ MSSQL James Bruce (May 20)