Re: trouble with creating "schema" table in mysql5

[Wes Young <wcyoung () buffalo edu>]

-----BEGIN PGP SIGNED MESSAGE-----
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 () 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
http://tinyurl.com/l18g
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFCtq9S1M5o0FsrrbERAq9cAJ98jSbAAJrhlFdPe1xoBLiQct5aDgCfUVmz
5nPCvzmIX2TYNe/mfTkgPug=
=Wkvk
-----END PGP SIGNATURE-----


-------------------------------------------------------
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