Snort Forums Archive

Archive Home » Third Party Tools » Honeynet Security Console sql script issue

Please note that the categories listed below represent an archived version of our forums pages. To view the current version and be able to post and reply to threads, please register and login here to go to the full forums pages.

[ Notice: Full Version of This Topic ]

Honeynet Security Console sql script issue

Posted by talb on October 27, 2005 13:27:48

Hello Group,

I am using mysql ver 5.0 trying to execute hsc.v104.sql script under MySql query browser but I get error since I am not familiar dba maybe anyone encountred this issue can help me.

Thanks in Advanced
Tal,

Posted by Joel_Esler on October 28, 2005 16:31:22

Get ahold of Jeff Dell jeff [ @ ] activeworx.com, he's the author.

Joel Esler
SOURCEfire

Posted by awx on November 08, 2005 06:47:00

Try downloaded the latest version of HSC or just put a ` before and after the word schema in the sql script. schema is a reserved word in MySQL 5.0.

i.e.

CREATE TABLE `schema` (
vseq INT UNSIGNED NOT NULL,
ctime DATETIME NOT NULL,
stype VARCHAR(10) NOT NULL,
PRIMARY KEY (vseq)
);
INSERT INTO `schema` (vseq, ctime, stype) VALUES ('104', now(), 'hsc');