[Snort-users] trouble with creating "schema" table in mysql5

Aleem Mawji am1 at ...13365...
Fri Jun 17 19:51:34 EDT 2005


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








More information about the Snort-users mailing list