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]
