Wednesday, November 5, 2008

Upgrading Snort Schema from 1.06 to 1.07

Use this if you need to update you snort DB Schema from 1.06 to 1.07:

USE snort;

ALTER TABLE signature ADD sig_gid INT UNSIGNED;
INSERT INTO `schema` (vseq, ctime) VALUES ('107', now());
DELETE FROM `schema` where vseq = '106';

The only change to the tables comes from the second line. The last two lines are just for updating the version number.

No comments: