Snort mailing list archives
Re: Update schema
From: roman () danyliw com
Date: Sat, 20 Oct 2001 01:23:51 US/Eastern
If you have a v103 database, the only steps you need to take to upgrade to v104 are as follows: mysql> DELETE FROM schema WHERE vseq = 103; mysql> INSERT INTO schema (vseq, ctime) VALUES (104, now()); mysql> ALTER TABLE reference MODIFY ref_tag VARCHAR(100) NOT NULL; Roman On Thu, 18 Oct 2001, East, Bill wrote:
I simply must be dim. Running snort 1.8.1, ACID v0.9.6b16. ACID shows schema version 1.03. I downloaded the latest and extracted the create_mysql script. Entered mysql, USEd the proper database, and SOURCEd the script. It ran, and I can do a SELECT * from schema to get +------+---------------------+ | vseq | ctime | +------+---------------------+ | 103 | 2001-09-20 14:18:21 | | 104 | 2001-10-18 16:13:44 | But ACID stays with schema 103, even after killing and restarting mysql and snort. Was there magic that I needed to do prior to the update? Do I need a later version of snort? Am I missing something painfully obvious? Are all Vulcans as snippy as T'Pol? I give up.
--------------------------------------------- This message was sent using Voicenet WebMail. http://www.voicenet.com/webmail/ _______________________________________________ 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:
- Update schema East, Bill (Oct 18)
- <Possible follow-ups>
- Re: Update schema roman (Oct 19)
- RE: Update schema East, Bill (Oct 22)