Snort mailing list archives
Snort create TABLES on mysql 5.0
From: Ferdy Riphagen <f.riphagen () nsec nl>
Date: Sun, 30 Oct 2005 13:01:05 +0100
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
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)