[Snort-users] Snort create TABLES on mysql 5.0

Joel Esler joel.esler at ...1935...
Sun Oct 30 06:29:28 EST 2005


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





More information about the Snort-users mailing list