Ethical Hacking

Learn to find vulnerabilities before the bad guys do! Gain real world hands on hacking experience in our state of the art hacking lab. Course designed and taught by expert instructors with years of penetration testing experience. 12 student maximum in every class. Certification attempt included in every package.
Computer Forensics Training at InfoSec Institute

Gain the in-demand skills of a certified computer examiner, learn to recover trace data left behind by fraud, theft, and cybercrime perpetrators. Discover the source of computer crime and abuse at your organization so that it never happens again. All of our class sizes are guaranteed to be 12 students or less to facilitate one-on-one interaction with one of our expert instructors.




Network Security Snort-Users
[Top] [All Lists]

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

Subject: Re: [Snort-users] trouble with creating "schema" table in mysql5
Date: Mon, 20 Jun 2005 07:58:10 -0400
-----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

<Prev in Thread] Current Thread [Next in Thread>