[prev in list] [next in list] [prev in thread] [next in thread] 

List:       snort-devel
Subject:    [Snort-devel] [ snort-Bugs-1274381 ] Databases & mysql 5.0
From:       "SourceForge.net" <noreply () sourceforge ! net>
Date:       2005-08-27 0:35:56
Message-ID: E1E8ofs-0001an-1b () sc8-sf-web1 ! sourceforge ! net
[Download RAW message or body]

Bugs item #1274381, was opened at 2005-08-27 00:35
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=103357&aid=1274381&group_id=3357

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Adolfo Gomez (dkmaster)
Assigned to: Nobody/Anonymous (nobody)
Summary: Databases & mysql 5.0

Initial Comment:
The mysql 5.0 version now has a new keyword. "schema".
In order to keep functional snort mysql database
backend with this version (and i think prior versions
works the same way), the table name "schema" must be
sourrounded by the character "`" in case the db backend
is mysql . I think that changing "create_mysql" in
schema directory and "spo_database.c" in
src/output-plugins should be sufficient.

the first should be something like this: (create_mysql).

23c23
< CREATE TABLE schema ( vseq        INT      UNSIGNED
NOT NULL,
---
> CREATE TABLE `schema` ( vseq        INT      UNSIGNED
NOT NULL,
26c26
< INSERT INTO schema  (vseq, ctime) VALUES ('106', now());
---
> INSERT INTO `schema`  (vseq, ctime) VALUES ('106',
now());

and the second (spo_database.c)

> #if defined(ENABLE_MYSQL)
>    if ( data->shared->dbtype_id == DB_MYSQL )
>    {
>       /* "schema" is also a keyword in MYSQL 5.0, so
indicate that we
>        * are refering to the table using "`"
>        */
>       snprintf( select0, MAX_QUERY_LENTH,
>               "SELECT vseq "
>               "  FROM `schema`");
>    }
>    else
> #endif


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=103357&aid=1274381&group_id=3357


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Snort-devel mailing list
Snort-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/snort-devel
[prev in list] [next in list] [prev in thread] [next in thread]