Re: [Snort-users] Snort create TABLES on mysql 5.0

Joel,

I managed to fix it, I'm using 2.4.3 but was using an old revision of
create_mysql.
The lines for schema are now replaced by `schema` in create_mysql

Regards,

Ferdy

Joel Esler wrote:
> What version of Snort are you running?  I know I fixed this as  of ....
> 2.4.2 IIRC.
>
> J
>
>
> 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
> > 'schema'
> >
> > 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
> > -----
> >
> > Regards,
> >
> > Ferdy
> >
> >
> > -------------------------------------------------------
> > 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@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


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