Snort mailing list archives
Re: Snort create TABLES on mysql 5.0
From: Joel Esler <joel.esler () sourcefire com>
Date: Sun, 30 Oct 2005 09:28:43 -0500
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 howcan 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
Current thread:
- Snort create TABLES on mysql 5.0 Ferdy Riphagen (Oct 30)
- Re: Snort create TABLES on mysql 5.0 Joel Esler (Oct 30)
- Re: Snort create TABLES on mysql 5.0 Ferdy Riphagen (Oct 30)
- Re: Snort create TABLES on mysql 5.0 Joel Esler (Oct 30)