Snort mailing list archives
RE: Migrating from 1.8.6 to 1.9.0 and updating the MySQL-DB scheme, any docs outthere?
From: "Gene Gomez" <gegomez () tycoint com>
Date: Thu, 10 Oct 2002 16:42:11 -0700
Yeah, seriously, I upgraded last night when I downloaded a copy of the new snortrules.tar.gz from the web site and found that they needed 1.9.0 to run. The db schema update from 1.05 to 1.06 was the biggest issue, mostly because I couldn't find any documentation on how to upgrade manually. After reading the db plugin documentation and noting what had changed in the schema, I decided to read the create_mysql database creation script to figure out what the new field (sensor.last_cid, I think) was supposed to look like in the database and I manually updated the table, then updated the schema.vseq in the same way. Later on I found this in the ChangeLog: 2002-09-03 Roman Danyliw <roman () danyliw com> * src/output-plugin/spo_database.c - DB schema v106 - Added the sensor.last_cid field to the schema so the database can store the last used cid for a given sensor. This field will ensure that a cid will never be reused. Upgrading from v105 -> v106 is as simple as: mysql> ALTER TABLE sensor ADD last_cid INT UNSIGNED NOT NULL; mysql> UPDATE schema SET vseq=106; psql> ALTER TABLE sensor ADD last_cid INT8; psql> UPDATE schema SET vseq=106; - Improved error messages I would have LOVED to have seen this in the db plugin documentation instead of hidden in the ChangeLog. :) What the heck is sensor.last_cid used for anyway? There's some funky number in there that I don't recognize attached to sensor 1 (my only sensor). Gene -----Original Message----- From: snort-users-admin () lists sourceforge net [mailto:snort-users-admin () lists sourceforge net]On Behalf Of Edin Dizdarevic Sent: Thursday, October 10, 2002 2:42 AM To: snort-users () lists sourceforge net Subject: [Snort-users] Migrating from 1.8.6 to 1.9.0 and updating the MySQL-DB scheme, any docs outthere? Hello, see the subject ;). I couldn't find anything in the docs dir... Greetings, Edin_ -- Edin Dizdarevic ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- Migrating from 1.8.6 to 1.9.0 and updating the MySQL-DB scheme, any docs outthere? Edin Dizdarevic (Oct 10)
- RE: Migrating from 1.8.6 to 1.9.0 and updating the MySQL-DB scheme, any docs outthere? Gene Gomez (Oct 10)
- Re: Migrating from 1.8.6 to 1.9.0 and updating the MySQL-DB scheme, any docs outthere? Edin Dizdarevic (Oct 10)
- RE: Migrating from 1.8.6 to 1.9.0 and updating the MySQL-DB scheme, any docs outthere? Gene Gomez (Oct 10)