[Snort-users] (no subject)

Chris Reid Chris.Reid at ...2817...
Thu Aug 8 20:31:02 EDT 2002

Try checking the database section of your snort.conf, and ensuring that you
are using the "mysql" line rather than the "mssql" line.  These are two very
different databases with two very similar acronyms.  The only database
server which uses/requires the string "[schema]" is Microsoft SQL Server.  I
expect you uncommented the wrong line in your snort.conf.

Chris Reid

----- Original Message -----
From: <herris at ...6560...>
To: <snort-users at lists.sourceforge.net>
Sent: Thursday, August 08, 2002 7:33 PM
Subject: [Snort-users] (no subject)


I installed snort-1.8.7-win32.exe but am having problems. I did a search of
the mailing list archives and only found 1 post that was of the same issue.
The one reply to it did not seem to fix the problem and truthfully does not
seem to address what the real problem is.

Below is the error I get trying to run snort.

database:     sensor id = 1
database: mysql_error: You have an error in your SQL syntax near '[schema]'
at line 1
database: schema version = 0
database: The underlying database seems to be running an older version of
the DB
          Please re-run the appropriate DB creation script (e.g.
          create_postgresql, create_oracle) located in the contrib\
Fatal Error, Quitting..

I used the 1.8.7 source to get the create_mysql table entries.

Not sure what is going on and I am not a mysql expert but I think the
problem is the brackets around schema.

Anyone else ran into this issue and gotten it resolved?

mail2web - Check your email from the web at
http://mail2web.com/ .

This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
Snort-users mailing list
Snort-users at lists.sourceforge.net
Go to this URL to change user options or unsubscribe:
Snort-users list archive:

More information about the Snort-users mailing list