[Snort-users] Updating the Database Schema for Snort 2.6

Jeff Dell jdell at ...1095...
Sun Jun 11 12:49:06 EDT 2006


I didn't see anyone really talk about this yet, but if you are upgrading
Snort from 2.4 to Snort 2.6 and you are using a database, you are going to
need to upgrade your schema from version 106 to version 107. This is a very
minor change and could do be done with the following commands for MySQL:

ALTER TABLE signature ADD sig_gid INT UNSIGNED;

DELETE FROM `schema` WHERE vseq = '106';
INSERT INTO `schema`  (vseq, ctime) VALUES ('107', now());

Cheers,

Jeff





More information about the Snort-users mailing list