I also just encountered this problem. I tried the above steps described by Javier and hit the following problems.
I tried to do these updates by logging into MySQL using the snort user. It didn't have the privileges to run the SQL commands described. So I looked at my /etc/mysql/debian.cnf file to get the password for the debian-sys-maint MySQL user and connected like so: mysql -u debian-sys-maint -h localhost -p snort Then supplied the correct password when prompted. The next problem I encountered is that the word 'schema' is a reserved word (at least in MySQL 5.0.45 it is). Therefore any operation I tried to perform on the schema table failed with an error. The solution is to wrap the table name in backticks. Finally it wasn't clear to me from Javier's description that in the third step you need to specify the old vseq number. So the steps are: 1. ALTER TABLE signature ADD sig_gid INT UNSIGNED; 2. INSERT INTO `schema` (vseq, ctime) VALUES ('107', now()); 3. DELETE from `schema` where vseq=106; Is it possible to have the package check the vseq number in the schema table and then automatically perform the upgrade? Fixing this problem involved a lot of mucking around since the information required was not in any of the README.Debian or NEW.Debian files (or any other file that I could find). Regards, -- ---------- Jim Barber DDI Health -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]