[Snort-users] Snort create TABLES on mysql 5.0
f.riphagen at ...13595...
Sun Oct 30 06:49:13 EST 2005
I managed to fix it, I'm using 2.4.3 but was using an old revision of
The lines for schema are now replaced by `schema` in create_mysql
Joel Esler wrote:
> What version of Snort are you running? I know I fixed this as of ....
> 2.4.2 IIRC.
> On Oct 30, 2005, at 7:01 AM, Ferdy Riphagen wrote:
>> Hello All,
>> I've a problem with a new installation of snort on a MySQL 5.0 database.
>> When I use the create_mysql script all the tables will be setup but not
>> See below the output when I do it manualy.
>> Any ideas what it could be?
>> I noticed a bug that 'shema' has become a reserved word in MySQL but how
>> can I make it work.
>> mysql> CREATE TABLE schema ( vseq INT UNSIGNED NOT NULL,
>> -> ctime DATETIME NOT NULL,
>> -> PRIMARY KEY (vseq));
>> ERROR 1064 (42000): You have an error in your SQL syntax; check the
>> manual that corresponds to your MySQL server version for the right
>> syntax to use near 'schema ( vseq INT UNSIGNED NOT NULL,
>> ctime ' at line 1
>> This SF.Net email is sponsored by the JBoss Inc.
>> Get Certified Today * Register for a JBoss Training Course
>> Free Certification Exam for All Training Attendees Through End of 2005
>> Visit http://www.jboss.com/services/certification for more information
>> Snort-users mailing list
>> Snort-users at lists.sourceforge.net
>> Go to this URL to change user options or unsubscribe:
>> Snort-users list archive:
More information about the Snort-users