[Snort-users] trouble with creating "schema" table in mysql5
wcyoung at ...12754...
Mon Jun 20 04:59:28 EDT 2005
-----BEGIN PGP SIGNED MESSAGE-----
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`
> how can i correct this problem? any other work arounds?
> thanks in advance,
> 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:
> Snort-users list archive:
Network Security Analyst
University at Buffalo
GPG Key: http://saxjazman9-security.blogspot.com/2005/01/gpg-key.html
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
-----END PGP SIGNATURE-----
More information about the Snort-users