trouble with creating "schema" table in mysql5

["Aleem Mawji" <am1 () mawji org>]

Just installed snort ver 2.3.3 with mysql version 5.

seems that "schema" is a reserved word in mysql 5 and as a result, i have
to modify the schema script to include `backticks` in order to create the
schema table.  unfortunately, although the table gets created and a
record gets inserted, snort fails to startup because it says that the
schema table does not exist (to query a table that is identified by a
reserved word in mysql5, the application needs to use the `backtick`
operator...probably).

how can i correct this problem?  any other work arounds?

thanks in advance,

aleem






-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&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