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

Wes Young wcyoung at ...12754...
Mon Jun 20 04:59:28 EDT 2005

Hash: SHA1

Yea, someone just brought this up the other day in bleeding...

we fixed it by adding those ticks in spo_database.c

at about line 1915 (snort2.3.2)

just do a search in that file for the 'checkdbver' function or
something, then just add the ticks in the sql stmt, recompile...

should work ok (from what I was told).

Aleem Mawji wrote:
> 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 at 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

- --
Wes Young
Network Security Analyst
University at Buffalo
GPG Key: http://saxjazman9-security.blogspot.com/2005/01/gpg-key.html
Version: GnuPG v1.4.1 (GNU/Linux)


More information about the Snort-users mailing list